1z1-067 by Oracle Actual Free Exam Questions And Answers

Question 1

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

A. They can be made only when the database is running in ARCHIVELOG mode.

B. They can be made only when the database is running in NOARCHIVELOG mode.

C. They can only be written to disk.

D. They can be made only when the database is in MOUNT state.

E. They consist of all used and unused blocks in the data files.

Discussion 0

Correct Answer: C,E Vote an answer

Question 2

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?
(Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to control the time interval for which the access privilege is available to a user.

C. It can be used to selectively restrict the access for each user in a database to different host computers.

D. It can be used to allow the access privilege settings for users as well as roles.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 3

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns are visible by default when the table is described.

B. The valid time columns are not populated by the Oracle Server automatically.

C. The valid time columns employee_time_start and employee_time_end are automatically created.

D. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 4

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?
Choose two.

A. data blocks in data files that have changed since the previous backup

B. online redo log files while the database is open

C. data files while the database is in NOMOUNT state

D. PFILE and password file in MOUNT state

E. data files while the database is open

Discussion 0

Correct Answer: A,E Vote an answer

Question 5

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created? (Choose the best answer.)

A. It is created as a PDB that must be plugged into an existing CDB.

B. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

C. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

D. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

Discussion 0

Correct Answer: C Vote an answer

Question 6

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 backup pieces for the backup set are created in both the specified destinations

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Question 7

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?

A. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location

B. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files

C. Restore the control file from the backup by using the CATALOG options, restore the data files by using the SET NEWNAME command, and recover the data files

D. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files

Discussion 0

Correct Answer: D Vote an answer

Question 8

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

A. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

B. The RMAN backup fails because the tools tablespace is read-only.

C. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

D. RMAN skips the backup of the tools tablespace because backup optimization is enabled.

Discussion 0

Correct Answer: C Vote an answer

Question 9

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/flash_recovery_area.

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

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

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

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A. Oracle Recovery Manager (RMAN)

B. Oracle Real Application Security

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Data Pump

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 11

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR can be used for problem diagnosis even when the database instance is down.

B. The ADR can be used to store statspack snapshots to diagnose database performance issues.

C. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

D. The ADR base is shared across multiple instances.

E. The ADR base keeps all diagnostic information in binary format.

Discussion 0

Correct Answer: A,D Vote an answer

Question 12

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

A. Oracle Suggested Backup Strategy

B. Database Resident Connection Pooling

C. Configure Label Security

D. Database Vault in ORACLE_HOME

E. Nondefaultblocksizetablespaces

Discussion 0

Correct Answer: C,D Vote an answer

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z1-067 Exam Practice Test

Contact Us

Useful Links

Latest Updated