1Z0-067 Online Practice Questions and Answers

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In

the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.

You create a common role c##role1 with the create table and select any table privileges.

You then execute the commands:

SQL> GRANTc##role1 TO##Madmin CONTAINER=ALL;

SQL>CONNsys/oracle@HR_PDB as sysdba

SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;

Which two statements are true?

A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.

B. B_admin can create and select any table in both the root container and Hr_pdb.

C. c##admin can create and select any table in the root container and all the PDBs.

D. B_admin can create and select any table only in hr_pdb.

E. The grant c##role1 to b_admin command returns an error because container should be set to ALL.

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?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described.

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Examine the RMAN command:

RMAN> SET ENCRYPTION IDENTIFIED BY 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

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.

Which two statements are true?

A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

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 for all 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 7

B. 1, 2, 4, 6, 5, 3, and 7

C. 1, 2,4, and 7

D. 2, 4, 5, 6, and 7

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR base is shared across multiple instances.

B. The ADR base keeps all diagnostic information in binary format.

C. The ADR can be used to store statspack snapshots to diagnose database performance issues.

D. The ADR can be used for problem diagnosis even when the database instance is down.

E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:

RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE;

Which two statements are true about the execution of the DUPLICATE command?

A. All archive redo log files are automatically copied to the duplicate database.

B. The duplicate database has the same directory structure as the source database.

C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.

D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.

E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

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

A. Encrypted backups can only be written to disk.

B. Image copy backups can be created by using password encryption.

C. A database uses the same encryption key for every encrypted backup.

D. Transparent encryption of backups uses an encryption wallet.

E. A password encryption of backups uses the password while creating and restoring backups.

Examine the statements that use flashback technologies:

1.

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYYMM-DD HH:MI:SS');

2.

SELECT * FROM customers AS OF SCN 123456;

3.

FLASHBACK TABLE customers TO BEFORE DROP;

4.

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM-DD HH:MI:SS');

5.

SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

6.

ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

A. 1, 2, 5

B. 1, 3, 6

C. 2, 3, 5, 6

D. 3, 4, 5

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two.)

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database