1Z0-053 | The Secret of Oracle 1Z0-053 examcollection
Q221. Which two prerequisites are needed for performing workload capture and replay? (Choose two.)
A. Close all sessions performing queries using database links.
B. running the database in shared server mode
C. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
D. setting up the directory to capture the workload
Answer: CD
Q222. Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.
a. restore database;
b. recover database;
c. shutdown immediate
d. startup
e. restore archivelog all;
f. alter database open
A. a, b, c, d, e, f
B. c, b, a, d, e, f
C. c, b, a, d, f
D. c, a, b, d
E. c, a, e, b, d, f
Answer: E
Q223. In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT
---------- ---------- ------------------------------ ---------------
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63
130 270 SQL*Net message from client 8
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SYSSTAT
Answer: B
Q224. Identify three key features of ASM. (Choose three.)
A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management
Answer: ABC
Q225. Which view provides information on the backup status of the datafiles in the database?
A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP
Answer: A
Q226. Which command would correctly start a TSPITR of the USERS tablespace?
A. recover tablespace users
until time `10/06/2008:22:42:00' auxiliary `c:oracleauxiliary'
B. recover tablespace users
time `10/06/2008:22:42:00' auxiliary destination `c:oracleauxiliary'
C. recover tablespace users
to point-in-time `10/06/2008:22:42:00'
auxiliary destination `c:oracleauxiliary'
D. recover tablespace users
except time `10/06/2008:22:42:00'
auxiliary destination `c:oracleauxiliary'
E. recover tablespace users
until time `10/06/2008:22:42:00'
auxiliary destination `c:oracleauxiliary'
Answer: E
Q227. You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;
Which statement is true in this scenario?
A. It starts the ASM fast mirror resync.
B. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
C. It drops all disk paths from the dga disk group.
D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
Answer: D
Q228. You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?
A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog
Answer: A
Q229. You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?
A. Create a manual incremental online database backup.
B. Back up all the archived redo logs generated since the 8 a.m. backup.
C. Create a brand-new backup after all the changes have been applied.
D. There is no way to make the changes recoverable based on the 8 a.m. backup.
E. Perform an online backup of the tablespace(s) that contained changed data.
Answer: B
Q230. You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.
C. The database instance starts, but Automatic Memory Management is disabled.
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.
Answer: B