1Z0-067 Online Practice Questions and Answers

For which three pieces of information can you use the RMAN list command?

A. stored scripts in the recovery catalog

B. available archived redo log files

C. backup sets and image copies that are obsolete

D. backups of tablespaces

E. backups that are marked obsolete according to the current retention policy

In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

You rename the undotbs undo tablespace:

ALTER TABLESPACE undotbs RENAME TO undotbs_old;

Which statement is true?

A. The tablespace will be renamed but the data file headers will not be updated.

B. The statement will fail because you cannot rename an undo tablespace.

C. The tablespace will be renamed and all the changes will be logged in the alert log.

D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Which three statements are true about the SQL*Loader utility?

A. It can be used to load data from multiple external files into multiple tables.

B. It can be used to extract and reorganize data from external files, and then load it into a table.

C. It can be used to load data from external files using direct path only.

D. It can be used to create tables using data that is stored in external files.

E. It can be used to generate unique sequential values in specified columns while loading data.

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 supports an OLTP workload. Examine the output of the query:

SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttr estimated_mttr

0 76

To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.

What is the effect of this setting on the database?

A. Automatic checkpoint tuning is disabled.

B. The frequency of log switches is increased.

C. The overhead on database performance is increased because of frequent writes to disk.

D. The MTTR advisor is disabled.

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.

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.

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?

A. The installation proceeds with the default value but a message is generated in the alert log file

B. The installation terminates with an error

C. The installation proceeds with the default value but the database creation is not attempted

D. The software installation proceeds with the default value but database creation fails

Which three statements are true about Flashback Data Archieve? (Choose three.)

A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first

B. While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve

C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace

D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

E. To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database