1Z0-053 | What Top Quality 1Z0-053 examcollection Is?
Q211. Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)
A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET
Answer: ABCD
Q212. Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache.
B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
Answer: AE
Q213. Note the following parameter settings:
Which setting is NOT allowed?
A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
Answer: B
Q214. You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?
A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.
B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.
C. Use compression when performing tape backups.
D. Configure multiple SBT channels.
Answer: B
Q215. When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
a. Restore the control file from autobackups.
b. Run the RMAN restore and recover command.
c. Restore the database spfile from autobackups.
d. Make the RMAN backup set pieces available.
e. Open the database with the alter database open resetlogs command.
f. Open the database with the alter database open command.
A. a, b, c, d, e, f
B. c, d, a, b, f
C. d, c, a, b, f
D. d, b, d, c, e
E. d, c, a, b, e
Answer: E
Q216. You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?
A. The command succeeds but it retrieves only the disk names.
B. The command produces an error because the ASM instance is down.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
Answer: D
Q217. Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)
A. Database datafiles
B. Control files
C. Archived redo logs
D. Online redo logs
E. Flashback logs
Answer: ABD
Q218. You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database
C. Create Flashback Data Archive in the tablespace where the tables are stored.
D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
Answer: D
Q219. You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)
A. You must configure block change tracking file
B. You must have first level 1 backups for RMAN to restore blocks
C. You must ensure that the SALES database is mounted or open
D. You must have full or level 0 backups for RMAN to restore blocks
E. You must take the tools01.dbf data file offline before you start a block media recovery
Answer: CD
Q220. You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)
A. the SQL text
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
Answer: ACD