Oracle 1Z0-050 問題集

質問 1：
Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+11
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
A. Archived redo logs are backed up only if the database is open during the backup
B. The backup is deleted after one day, regardless of the default retention policy settings.
C. The backup becomes obsolete after one day, regardless of the default retention policy settings.
D. Only data files and the control file are backed up.
正解：A,C

質問 2：
View the Exhibit and examine the output.

You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
A. The Flashback Archive is created on the same tablespace where the tables are stored.
B. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive-
C. The Flashback Archive is created on the SYSAUXtablespace.
D. The table uses the default Flashback Archive.
正解：B

質問 3：
Following is the list of locations in random order where oranfstab can be placed.
1 ./etc/mtab 2 .$ORACLE_HOME/dbs/oranfstab 3 ./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?
A. 1,2,3
B. 1,3,2
C. 3,2, 1
D. 2,3, 1
正解：D

質問 4：
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?
A. Specify undo retention guarantee for the database.
B. Enable Flashback Data Archive for the tables.
C. Create Flashback Data Archive on the tablespace on which the tables are stored.
D. Enable supplemental logging for the database.
E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
正解：B

質問 5：
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
A. Local and global indexes are maintained automatically during the operation.
B. It does not require additional storage because the operation is done online.
C. It cannot be done in parallel.
D. It can be done at the table level or partition level.
正解：D

質問 6：
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It is created by default with the window size being equal to the AWR retention time.
B. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
C. It does not allow you to change the moving window size,
D. Adaptive threshold functionalities use it by default to compute statistics.
正解：A,D

質問 7：
Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)
A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
B. Every problem has a problem key, which is a text string that describes the problem.
C. The database makes an entry into the alert log file when problems and incidents occur.
D. The problem key is the same as the incident number,
E. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
正解：B,C,E

質問 8：
Which two statements are true regarding Health Monitor checks in Oracle Database 11g?
(Choose two.)
A. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption
C. Health Monitor checks are always initiated manually when there is some critical error.
D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
正解：B,D