1Z0-067 Online Practice Questions and Answers

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

How can you detect the cause of the degraded performance?

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C. by using Active Session History (ASH) data and performing hang analysis

D. by running ADDM in diagnostic mode

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A. The minimum size for the standard buffer cache is 100 MB.

B. The maximum size for the standard buffer cache is 100 MB.

C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.

D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

E. The minimum size for all buffer caches is 100 MB.

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.

LDAP_DIRECTORY_SYSAUTH is set to YES.

Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).

SSL has been configure for the database and OLD and the password file has been configured for the database.

User scott with sysdba privilege tries to connect remotely using this command:

$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.

Which authentication method will be attempted first?

A. authentication by password file

B. authentication by using certificates over SSL

C. authentication by using the Oracle Internet Directory D. authentication by using the local OS of the database server

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media

failure, the current online redo log group, which has one member, is lost and the instance is aborted.

Examine the steps to recover the online redo log group and move it to a new location.

1.Restore the corrupted redo log group.

2.Restore the database from the most recent database backup.

3.Perform an incomplete recovery.

4.Relocate the member of the damaged online redo log group to a new location.

5.Open the database with the resetlogs option.

6. Issue a checkpoint and clear the log.

Identify the required steps in the correct order.

A. 1, 3, 4, 5

B. 6, 3, 4, 5

C. 2, 3, 4, 5

D. 6, 4, 3, 5

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.

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?

A. It flashes back the employee table and all the constraints associated with the table.

B. It automatically flashes back all the indexes on the employes table.

C. It automatically flashes back any triggers defined on the table.

D. It flashes back only the structure of the table and not the data.

E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

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

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset

E. The DMU can report columns that are not represented in the converted characterset