最新的Oracle Database 12cR2 Administration - 1Z0-072免費考試真題
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
Which two actions are performed? (Choose two.)
Which two actions are performed? (Choose two.)
正確答案: C,D
Which two operations can be performed on external tables? (Choose two.)
正確答案: C,D
In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);
Which table segments are created?
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);
Which table segments are created?
正確答案: A
In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?
正確答案: F
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
正確答案: C,E,F
Which two tasks can be performed in the NOMOUNT state? (Choose two.)
正確答案: B,E
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.
Examine these steps:
1. Shut down the database instance.
2. Modify the parameter in the spfile with scope = SPFILE.
3. Modify the parameter in a pfile.
4. Use the spfile to create a pfile.
5. Use the pfile to create a spfile.
6. Modify the parameter in the spfile with scope = BOTH.
7. Start up the database instance.
Which are the minimum required steps in the correct order?
Examine these steps:
1. Shut down the database instance.
2. Modify the parameter in the spfile with scope = SPFILE.
3. Modify the parameter in a pfile.
4. Use the spfile to create a pfile.
5. Use the pfile to create a spfile.
6. Modify the parameter in the spfile with scope = BOTH.
7. Start up the database instance.
Which are the minimum required steps in the correct order?
正確答案: E
Your client application and Oracle database are located on different hosts.
Which statement is true about establishing a connection between them?
Which statement is true about establishing a connection between them?
正確答案: A
Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)
正確答案: B,D