Free 1z0-067 sample questions
Questions from the Upgrade Oracle 9i/10g/11g to Oracle Database 12c OCP practice bank, with the correct answer and an explanation for each one. No junk, no filler.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
Which two statements are true about encrypted backups performed by using RMAN? Choose two.
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
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.)
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?
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?
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?
Which statement is true about unified auditing?
10 more free samples are waiting
Create a free account to unlock the whole 1z0-067 sample bank, or get full access to all 264 practice questions in the simulator.