1Z0-067 Online Practice Questions and Answers

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/ oracle/product/12.1.0/db 1.

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAME TYPE VALUE

audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring

What is the location of the ADR base?

A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.

B. It is set to /u01/app/oracle/admin/en12.1.0/adump.

C. It is set to /u01/app/oracle.

D. It is set to /u01/app/oracle/flash_recovery_area.

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.

Which three are prerequisites to fulfill this requirement?

A. Minimal supplemental logging must be enabled.

B. The database must be running in archivelog mode.

C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

D. The flashback any table privilege must be granted to the user.

E. The select any transaction privilege must be granted to the user.

F. The recycle bin parameter must be set to on.

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

Examine the steps required to recover the database:

1.Restore an autobackup of the server parameter file. 2.Restore the control file.

3. Start up the database instance in nomount state.

4.Mount the database.

5.Restore the data files.

6.Open the database with the resetlogs option.

7.Recover the data files.

8.Set DBID for the database.

Identify the required steps in the correct order.

A. 1, 8, 3, 2, 4, 5, 7, 6

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

C. 1, 3, 2, 4, 8, 5, 6, 7

D. 8, 3, 2, 4, 5, 7, 6

E. 8, 1, 3, 2, 4, 5, 6

Examine the parameters for your database instance:

NAME TYPE VALUE

optimizer_adaptive_reporting_onlyboolean FALSE optimizer_capture_sql_plan_baselinesboolean FALSE optimizer_dynamic_samplinginteger 2 optimizer_features_enablestring 12.1.0.1

Which three statements are true about the process of automatic optimization by using statistics feedback?

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

B. The optimizer can re optimize a query only once using cardinality feedback.

C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Which two statements are true about service creation for pluggable databases (PDBs)?

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D. Only a common user can create additional services for a PDB.

E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

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

A. Default permanent tablespaces can be shared across pluggable databases (PDBs).

B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

C. Each PDB can have its own default temporary tablespace.

D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

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-only at the source database.

2.

Export metadata from the source database.

3.

Import metadata into the target database.

4.

Transfer the dump file and data files to the target machine.

5.

Convert data files by using Recovery Manager (RMAN).

6.

Make the tablespace read-write at the target database.

Identify the required steps in the correct order. (Choose the best answer.)

A. 1, 2, 4, 3, and 6

B. 2, 4, 3, and 5

C. 2, 4, and 3

D. 1, 5, 2, 4, 3, and 6

Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

A. A window specifies a Resource Manager plan that is automatically activated when the windows opens.

B. A window specifies a job class that will be activated when that window opens.

C. A job class specifies a window that will be open when that job class becomes active.

D. A window and the job class associated with a job controls resource allocation for that job.

E. A window and the Resource Manager plan that is active when a job runs determine the job class for the job.

You want to create a database and you have the following: Oracle Grid Infrastructure is installed and configured Oracle Database Vault is installed in ORACLE_HOME to be used for this database Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server

Examine the requirements:

1.

Configuring the database instance to support shared server mode

2.

Using Automatic Storage Management (ASM) for storing database files

3.

Configuring a naming method to help a remote user connect to a database instance

4.

Configuring the Fast Recovery Area

5.

Configuring Database Vault

6.

Configuring Enterprise Manager (EM) Database Express

7.

Registering with EM Cloud Control

8.

Configuring remote log archive destinations

9.

Enabling daily incremental backups 10.Configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1,2,3,4,5,6,8,9, and 10

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

C. 1, 2, 3, 8, 9, and 10

D. 1, 2, 4, 5, 7, 8, 9, and 10

E. 1, 2, 4, 5, 6, and 7

You execute the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk

RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';

RMAN> BACKUP DATABASE;

Which statement is true about the backup set created by the BACKUP command?

A. Two channels are allocated and two copies of the backup set are taken in parallel in both locations

B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

C. The default channel is allocated and the backup set is created in only one destination

D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2