1Z0-067 questions and answers

Which two statements are true about making RMAN image copies of a database? (Choose two.)

You issue the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which three tasks are performed by the BACKUP DATABASE command?

Which statement is true about unified auditing?

You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE.

What is the effect on the installation?

In which three situations must you use a recovery catalog? (Choose three.)

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded.
Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.

How can you detect the cause of the degraded performance?

Which three statements are true about common roles? (Choose three.)

Which two statements are true about roles in multitenant container databases (CDBs)?

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to
20.

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

You are administering a multitenant container database (CDB) cdb1.

Examine the command and its output:

SQL>show parameterfile

NAMETYPEVALUE
-----------------------------------------------------------------------db_create_file_deststring
db_file_name_convertstring
db_filesinteger200

You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/
oradata/cdb1/salesdb' location.

You plan to create a new pluggable database (PDB) by using the command:

SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

Which statement is true?

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}

Which statement is true about the RMAN RUN block execution?

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

You are administering a multitenant container database (CDB) that contains multiple pluggable databases
(PDBs). RMAN is connected to CDB$ROOT.

Examine the command:
RMAN> LIST FAILURE;

Which statement is true about this command?

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

You use RMAN to take regular backups for your database.
Examine the RMAN commands:

RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPIRED BACKUP;

Which statement is true?

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE

You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges

Why does the startup command return the error shown?

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 have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

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

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:

CREATEORREPLACEPROCEDUREcreate_test_v
(v_emp_idNUMBER,v_enameVARCHAR2,v_SALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/

GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;

How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

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

Examine these Data Pump commands to export and import objects from and to the same database.

The dba has not yet created users hr1 and oe1.

$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table

$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1

What will happen when running these commands?

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

What is the easiest way to perform capacity planning for consolidation?

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.

You set the value of the initialization parameter resumable_timeout to 3600.

Which two statements are true?

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?

Which two statements are true about scheduling operations in a pluggable database (PDB)?

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

Which two statements are true about a common user?

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION (`ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi WHERE o.orderjd = i.order_id and i.product_id = p.product_id;

You execute the command shown in the Exhibit, but only two files are created.

Which parameter must be changed so that four files are created?

A database is running in archive log mode. The database contains locally managed tablespaces. Examine the RMAN command:

RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;

Which statement is true about the execution of the command?

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

Which two statements are true about a multitenant architecture?

You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB) CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.

Examine the list of possible steps required to perform the task:

1. Create a PDB named emp_pdb1.
2. Export the hr_pdb1 PDB by using the full clause.
3. Open the emp_pdb1 PDB.
4. Mount the emp_pdb1 PDB.
5. Synchronize the emp_pdb1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the emp_pdb1 PDB.
8. Import data into emp_pdb1 with the full and remap clauses.
9. Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.

Identify the required steps in the correct order.

Which two statements are true about unified auditing?

Examine the command and its output:

SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAMEORIGINAL_NAMETYPE
--------------------------------------------------------------------------------------------------------------
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

Which two statements are true?

You created a database with DBCA by using one of the Oracle supplied templates.

Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

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 OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.

Identify the required steps in the correct order.