Page: 1
/ 24
Total 116 questions
The following commands are executed against a database named MY_DB, which has been configured to usearchival logging:
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
Given the followingstatement:
How many constraints are present in the DEPARTMENT table?
- A. 1
- B. 2
- C. 3
- D. 4
Answer : D
Which data movement utility is suitable for moving and processing large amounts of real- time data without affecting availability?
- A. INGEST
- B. REPLICATION
- C. LOAD WITH READ ACCESS
- D. IMPORT WITH BUFFERED INSERT
Answer : A
What are two types of security label components that can be used with Label-Based
Access Control (LBAC)? (Choose two).
- A. Set
- B. Tree
- C. Group
- D. Range
- E. Hierarchy
Answer : A,B
31 days access 