Free C2090-616 Questions for IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam as PDF & Practice Test Engine
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?
Correct Answer: A
Vote an answer
What is the primary use case for creating an index with the RANDOM option on a table?
Correct Answer: D
Vote an answer
A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?
Correct Answer: C
Vote an answer
The creator of an index or an index specification automatically receives which privilege on the index?
Correct Answer: A
Vote an answer
Which of the following is TRUE about DB2 OLAP functions?
Correct Answer: A
Vote an answer
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
Correct Answer: A,C
Vote an answer
The DDL statement is used to create table T1:
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?
Correct Answer: C
Vote an answer
0
0
0
10