Q1. You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as thesys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO
C##CONNECT;
SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement istrue about the c##connect role?
A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B. It is granted to the c##admin user only in the CDB.
C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
Answer: C
Q2. The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
Srman
RMAN> CONNECT CATALOG rc12c/pass12c8catdbI2c
RMAN> IMPOST CATALOG rc1l/pwdcatl19catdbl1 DBID=I423241;
What is the outcome of the import?
A. It fails because the target database and recovery catalog database are of different versions.
B. It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
C. It succeeds but the database is not automatically registered in the Rc12c catalog.
D. It fails because RMAN is not connected to the target database with DBID=1423241.
Answer: B
Q3. You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1.Place all user-defined tablespaces in read-only mode on the source database.
2.Use the RMAN convert command to convert data files to the target platform's endian
format, if required.
3.Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4.
Transport the data files forall the user-defined tablespaces.
5.
Transport the export dump file to the target database.
6.Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7.Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.
A. 1, 3, 5, 4, 2, and 6
B. 1, 2, 4, 6, 5, 3, and 7
C. 1, 2,4, and 7
D. 2, 4, 5, 6, and 7
Answer: A
Q4. Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset
Answer: A,D,E
Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target
character set is different than the representation in the current character set, but neither
length limit issues nor invalid representation issues have been found.
Q5. You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?
A. switching the online redo log file
B. backing up all data files as image copies and archive log files, and deleting those archive log files
C. backing up only the used blocks in the data files
D. backing up all used and unused blocks in the data files
E. backing up allarchived log files and marking them as obsolete
Answer: A,C,E
Q6. You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
A. by using the connect statement as a local user having only the set container privilege
B. by using easy connect
C. by using external authentication
D. as a common user with the set container privilege
E. by executing the alter session set container command as a local user
Answer: A,D
Q7. Your database is running in archivelog modeand Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?
A. Enable minimal supplemental logging.
B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
C. Enable the recyclebin.
D. Enable undo retention guarantee.
E. Enable Fast Recovery Area.
Answer: A,C
Q8. Which two are prerequisites for creating a backup-based duplicate database?
A. connecting to the target database and a recovery catalog to execute the duplicate command
B. creating a password file for an auxiliary instance
C. connecting to an auxiliary instance
D. matching the database identifier (DBID) of the source database and the duplicate database
E. creating an SPFILE for the target database
Answer: A,B
Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CH DEDFFH
Q9. Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Answer: A
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password –encrypted backups)
Q10. As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files duringthe upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using theSTARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Answer: C