Oracle 1Z0-053 問題集

質問 1：
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?
A. only the data files and the archived redo logs
B. only the current SPFILE and data files if autobackup is disabled
C. only the control file, the current SPFILE, and data files
D. the control file, current SPFILE file, data files, and archived redo logs
正解：D

質問 2：
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
A. external tables
B. views
C. Index-Organized Tables (IOTs)
D. fixed tables
E. heap tables
F. temporary tables
正解：C,E

質問 3：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?
A. Process Monitor (PMON)
B. System Monitor (SMON)
C. User process
D. Checkpoint process (CKPT)
E. Server process
正解：E

質問 4：
What are the different logging modes available in Oracle Database 11g? (Choose two.)
A. NOLOG mode
B. ARCHIVELOG mode
C. LOGGING mode
D. HOTDATABASE mode
E. NOARCHIVELOG mode
正解：B,E

質問 5：
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
A. Create a repeating baseline template.
B. Insert a finding directive for future ADDM tasks.
C. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
D. Create and populate a SQL Tuning Set from the AWR on every Monday.
正解：A

質問 6：
In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?
A. Configuring Automatic Shared Memory Management
B. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
C. Configuring Automatic Memory Management
D. None of the above
E. Setting a nonzero value for SGA_TARGET
正解：A

質問 7：
What methods are available to recover lost control files? (Choose all that apply.)
A. The restore controlfile SQL*Plus command.
B. The create controlfile command.
C. No backup is required. The database will re-create the control file when it is discovered to be lost.
D. Emergency control file.
E. Backup control file.
正解：B,E