問題1
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
Identify the reason the instance failed to start.
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
Identify the reason the instance failed to start.
正確答案: C
說明：（僅 NewDumps 成員可見）
問題2
Examine these two statements:
Which three are true about the MRKTtablespace? (Choose three.)
Examine these two statements:
Which three are true about the MRKTtablespace? (Choose three.)
正確答案: B,C,D
問題3
Which two statements are true about the Oracle Direct Network File system (DNFS)?
Which two statements are true about the Oracle Direct Network File system (DNFS)?
正確答案: B,C
說明：（僅 NewDumps 成員可見）
問題4
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
正確答案: C
說明：（僅 NewDumps 成員可見）
問題5
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
正確答案: A,C,E
說明：（僅 NewDumps 成員可見）
問題6
You execute the following PL/SQL:
Which two statements are true?
You execute the following PL/SQL:
Which two statements are true?
正確答案: A,D
說明：（僅 NewDumps 成員可見）
問題7
You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?
You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?
正確答案: B
問題8
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
正確答案: B,D,E
說明：（僅 NewDumps 成員可見）
問題9
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:
What is the result?
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:
What is the result?
正確答案: C
說明：（僅 NewDumps 成員可見）
問題10
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
正確答案: B