1z0-067 Upgrade Oracle 9i/10g/11g to Oracle Database 12c OCP Practice Questions
Prepare for 1z0-067 with more than an answer.
- 1
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
Show answer details
Correct answer: B, C, D
B,C,D--Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the 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.B,C,D--Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the 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.B,C,D--Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the 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. - 2
You administer a database that was created using Oracle Database 10g.
The default tablespace type property was not changed. You execute this statement to create a tablespace, mytbs: CREATE TABLESPACE mytbs DATAFILE 7u1/data/mytbs.dbf SIZE 100M;Which two statements are correct regarding the mytbs tablespace? (Choose two.)
Show answer details
Correct answer: A, E
A,E
A,E
- 3
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL; SQL> GRANT CREATE VIEW TO C##rolel CONTAINER=ALL; SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?
Show answer details
Correct answer: D
D--Explanation:
SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin * ERROR at line 1: ORA - 01951: ROLE ‘C##ROLET not granted to ‘C##A_ADMIN’ SQL> REVOKE c##role1 FROM c##a_admin CONTAINER=ALL; Revoke succeeded. SQL> This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create common user event container is not specified. - 4
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys 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 is true about the c##connect role?
Show answer details
Correct answer: B
B--Explanation:
“CONTAINER Clause The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB.” --References: docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311">https://docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311 - 5
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command: $sqlplusscott/tiger@DBOI As sysdba where DB01 is the net service name.Which authentication method will be attempted first?
Show answer details
Correct answer: D
D--Explanation:
If the database is configured to use a password file for remote authentication, Oracle Database checks the password file first.
References: docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication. htm">http://docs. oracle. com/cd/E25054_01/network. 1111Ze16543Zauthentication.htm - 6
Show answer details
Correct answer:
- 7
Which statement is true about unified auditing?
Show answer details
Correct answer: A
A
- 8
RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
Show answer details
Correct answer: D, E
D,E
D,E
- 9
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Show answer details
Correct answer: A, B, E
A,B,E
A,B,E
A,B,E
- 10
Identify three benefits of unified auditing.
Show answer details
Correct answer: A, B, E
A,B,E
A,B,E
A,B,E
