最新的Oracle Database 11g Certified Master Upgrade - 11gocmu免費考試真題
Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)
正確答案: B,D,E
View the exhibit and examine the TRANS table's storage information.
After a massive delete operation, you executed the following statement to shrink the
TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
Exhibit:
After a massive delete operation, you executed the following statement to shrink the
TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
Exhibit:
正確答案: A
說明：（僅 Fast2test 成員可見）
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
正確答案: B,C
Note the following statements that use flashback technology:
1.FLASHBACK TABLE <table> TO SCN <scn>;
2.SELECT * FROM <table> AS OF SCN 123456;
3.FLASHBACK TABLE <table> TO BEFORE DROP;
4.FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5.SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
1.FLASHBACK TABLE <table> TO SCN <scn>;
2.SELECT * FROM <table> AS OF SCN 123456;
3.FLASHBACK TABLE <table> TO BEFORE DROP;
4.FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5.SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
正確答案: D
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
正確答案: B,C,D
What is the result of this command? RMAN> Report need backup days 3;
正確答案: E
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
正確答案: C
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA' Using RMAN, how would you respond to this error?
正確答案: C
Which statements are true regarding table compression? (Choose all that apply.)
正確答案: B,D
Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)
正確答案: A,D,E
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?
SQL>@utlu111i.sql
Which statement about the execution of this script is true?
正確答案: A
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?
正確答案: D
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)
正確答案: A,B,C,D