1Z0-067 Exam Questions

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( OBJECT_SCHEMA => `SCOTT', OBJECT_NAME => `EMP', POLICY_NAME => `SCOTT_EMP', COL...

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified. Which statement is true about the database that is...

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema own...

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format: 1. Make the tablespace read...

Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1...

Which four tablespace types can be renamed? Choose four.

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

Your database is running in ARCHIVELOG mode and flashback is enabled. In which scenario must you use RMAN backups for recovering tables and table partitions? Choose the best answer...

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? Choose two.

In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command: SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP; What are three prerequisit...

During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set...

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES: RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE s...

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

You install Oracle Grid Infrastructure for a standalone server and issue this command: crsctl start has Which two components get automatically added to the Oracle Restart configura...

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo r...

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? Choose two.

You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH `/disk1/backups'; Which statement is true?

Examine these parameter settings: SGA_TARGET = 700M SGA_MAX_SIZE = 1024M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You attempt this: SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M Whi...

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (D...

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backu...

Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required. In which two cases is this true?

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB): 1. RMAN initiates backup and passes the database backup storage selector to...

ENCRYPT_TS an encrypted tablespace that contains tables with data. Which statement is true about queries and data manipulation language statements on these tables?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): $> impdp <user_name> full=Y network_link=hrdb_test transportable=...

Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it. Identify two eve...

RMAN is connected to a target database instance and an auxiliary instance. You execute the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; W...

As part of a manual update process, you install Oracle Database 12c software, prepare a new ORACLE_HOME, you shut down an existing single-instance database that runs from that ORAC...

Which three statements are true about Scheduler Windows? (Choose three.)

You plan to migrate a production database to Real Application Clusters (RAC). You created a test RAC database by cloning the production database and plan to replay a workload, capt...

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM- DD HH:MI:SS'); 2. SELECT * FROM cus...

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues...

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the...

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true? (Choose two.)

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