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.

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

A. A job is specified as part of a program definition.

B. A program can be used in the definition of multiple jobs.

C. A program and job can be specified as part of a schedule definition.

D. A program and schedule can be specified as part of a job definition.

E. A program and window can be specified as part of a job definition.

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA I00M ON users TEMPORARY TABLESPACE temp;

Which statement is true about the execution of the command?

A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

B. The command succeeds only if all the PDBs have the users and temp tablespaces.

C. The command gives an error because the container=all clause is missing.

D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.

Which three statements are true about persistent lightweight jobs?

A. A user cannot set privileges on them.

B. They generate large amounts of metadata.

C. They may be created as fully self-contained jobs.

D. They must reference an existing Scheduler Program.

E. The are useful when users need to create a large number of jobs quickly.

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

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?

A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

B. It is granted to the c##admin user only in the CDB.

C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. A base recovery catalog should exist.

B. The owner of VPC cannot own recovery catalog.

C. At least one target database should be registered in the recovery catalog.

D. The register database privilege should be granted to the virtual catalog owner.

E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

The SYS user creates this job:

Which two statements are true about this job? (Choose two.)

A. It executes with the privileges of SYS

B. It is automatically dropped after the last run

C. The globalization environment that exist at job creation is used run time

D. It executes with the privileges of OPS

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incremental every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost. You want to recover the data file as quickly as possible while maximizing availability for the database. Examine the possible steps involved in the recovery process:

1.

Mount the database

2.

Take the data file offline

3.

Bring the tablespace online

4.

Use the RMAN SWITCH command to switch to the image copy

5.

Recover the tablespace

6.

Open the database

7.

Use the RMAN RESTORE command to switch to the image copy

Identify the correct sequence of the required steps:

A. 2, 7, 5, 3

B. 2, 4, 5, 3, 6

C. 1, 2, 4, 6, 3

D. 1, 2, 7, 5, 3, 6

E. 2, 6, 4, 5, 3

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement:

SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;

What is the outcome?

A. An error is returned because the retention period cannot be reduced

B. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time

C. All historical data older than two years, if any, is purged from the flashback archive FDA1.

D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years