IBM C2090-611 - DB2 10.1 DBA for Linux, UNIX, and Windows Exam
Page: 1 / 24
Total 116 questions
Question #1 (Topic: Topic 1)
The following commands are executed against a database named MY_DB, which has been
configured to usearchival logging:
[IBM-C2090-611-6.0/IBM-C2090-611-3_2.png]
Which statement is true?
configured to usearchival logging:
[IBM-C2090-611-6.0/IBM-C2090-611-3_2.png]
Which statement is true?
A. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.
B. Upon completion of the Load, a backup image of table T1 is automatically generated.
C. After a Restore and Rollforwardoperation, table T1 would be marked unavailable and can only be dropped.
D. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.
Answer: C
Question #2 (Topic: Topic 1)
Given the followingstatement:
[IBM-C2090-611-6.0/IBM-C2090-611-3_3.png]
How many constraints are present in the DEPARTMENT table?
[IBM-C2090-611-6.0/IBM-C2090-611-3_3.png]
How many constraints are present in the DEPARTMENT table?
A. 1
B. 2
C. 3
D. 4
Answer: D
Question #3 (Topic: Topic 1)
Which data movement utility is suitable for moving and processing large amounts of real-
time data without affecting availability?
time data without affecting availability?
A. INGEST
B. REPLICATION
C. LOAD WITH READ ACCESS
D. IMPORT WITH BUFFERED INSERT
Answer: A
Question #4 (Topic: Topic 1)
What are two types of security label components that can be used with Label-Based
Access Control (LBAC)? (Choose two).
Access Control (LBAC)? (Choose two).
A. Set
B. Tree
C. Group
D. Range
E. Hierarchy
Answer: A,B
Question #5 (Topic: Topic 1)
If an MQT named Q1_SALES wascreated as follows:
[IBM-C2090-611-6.0/IBM-C2090-611-5_2.png]
Which statement will execute successfully?
[IBM-C2090-611-6.0/IBM-C2090-611-5_2.png]
Which statement will execute successfully?
A. DELETE FROM q1_sales
B. REFRESH TABLE q1_sales
C. INSERT INTO q1_sales VALUES(80.2)
D. ALTER TABLE q1_sales REFRESH IMMEDIATE
Answer: B
