1Z0-053 | All About Accurate 1Z0-053 practice test
Q21. You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor
Answer: D
Q22. Which dynamic view displays the status of block-change tracking?
A. V$BLOCK_CHANGE
B. V$BLOCK_CHANGE_TRACKING
C. V$BLOCKCHANGE
D. V$BLOCK_TRACKING
Answer: B
Q23. Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)
A. Backup-based database duplication.
B. Active database duplication.
C. Tablespace point-in-time recovery.
D. No operation requires the creation of an auxiliary instance.
Answer: AB
Q24. What is the correct order of steps to perform an online database backup?
a. alter database begin backup;
b. alter database end backup;
c. Back up the database datafiles.
d. Back up the archive log files.
e. alter system switch logfile;
A. a, b, c, d, e
B. e, d, a, b, c
C. a, c, b, d, e
D. d, b, c, a, e
E. a, c, b, e, d
Answer: E
Q25. Which of the following is not a configurable attribute for an individual disk group?
A. AU_SIZE
B. COMPATIBLE.RDBMS
C. COMPATIBLE.ASM
D. DISK_REPAIR_TIME
E. DG_DROP_TIME
Answer: E
Q26. Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
A. It cancels all pending disk drops within the disk group.
B. It adds previously dropped disks back into the disk group.
C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
D. It mounts disks in the disk group for which the drop-disk operation has already been completed.
E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.
Answer: A
Q27. How many different calendars does Oracle 11g support?
A. 22
B. 7
C. 6
D. 15
E. 2
Answer: B
Q28. If two windows overlap, which window attribute will determine whether one should be chosen over the other?
A. WINDOW_PRIORITY
B. PRIORITY
C. PRIORITY_LEVEL
D. WINDOW_PRIORITY_LEVEL
E. OVERLAP_RULE
Answer: A
Q29. Which three tasks can be performed using a duplicate database? (Choose three.)
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
Answer: ABC
Q30. The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
Answer: AD