問題1
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
正確答案: C,D
問題2
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database.
Examine the possible steps involved in the recovery process:
1. Mount the database.
2. Take the data file offline.
3. Bring the tablespace online.
4. Use the RMAN SWITCH command to switch to the image copy.
5. Recover the tablespace.
6. Open the database.
7. Use the RMAN RESTORE command to switch to the image copy.
Identify the correct sequence of the required steps.
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database.
Examine the possible steps involved in the recovery process:
1. Mount the database.
2. Take the data file offline.
3. Bring the tablespace online.
4. Use the RMAN SWITCH command to switch to the image copy.
5. Recover the tablespace.
6. Open the database.
7. Use the RMAN RESTORE command to switch to the image copy.
Identify the correct sequence of the required steps.
正確答案: D
問題3
Which two statements are true regarding Oracle Data Pump? (Choose two.)
Which two statements are true regarding Oracle Data Pump? (Choose two.)
正確答案: A,C
問題4
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
正確答案: C
問題5
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
正確答案: D
問題6
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
正確答案: D
問題7
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
正確答案: A
問題8
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)
正確答案: A,B,C
問題9
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?
正確答案: A
問題10
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)
正確答案: C,E
說明：（僅 NewDumps 成員可見）