ExamDumpster

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.

Question 1Choose 2

A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file 7uOI/app/oracle/oradata/ORCL/temp01.dbf ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace?

Question 2Choose 2

Which two statements are true about encrypted backups performed by using RMAN? Choose two.

Question 3Choose 3

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?

Question 4Choose 3

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Question 5Choose 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.)

Question 6Choose one

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?

Question 7Choose one

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?

Question 8Choose one

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?

Question 9Choose one

    Question 10Choose one

    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.

    Create account