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

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE

You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges

Why does the startup command return the error shown?

A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command

B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command

C. because the threaded architecture requires authentication using a password file before issuing a startup command

D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

E. because the threaded architecture requires restarting the listener before issuing a startup command

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.

B. The PDB is closed and requires media recovery at the PDB level.

C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

D. The PDB does not close and starts by using the default temporary tablespace defined for the CD

In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:

SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;

What are three prerequisites for this command to succeed? (Choose three.)

A. The recycle bin should be enabled.

B. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.

C. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.

D. SCOTT should have the FLASHBACK ANY TABLE privilege.

E. No other table with the same name should exist in the HR schema.

F. Undo retention guarantee must be enabled.

Examine the statements that use flashback technologies:

1.

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYYMM-DD HH:MI:SS');

2.

SELECT * FROM customers AS OF SCN 123456;

3.

FLASHBACK TABLE customers TO BEFORE DROP;

4.

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM-DD HH:MI:SS');

5.

SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

6.

ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

A. 1, 2, 5

B. 1, 3, 6

C. 2, 3, 5, 6

D. 3, 4, 5

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

A. Temporary undo reduces the amount of undo stored in undo tablespaces

B. Performance improves because less redo is written to the redo log

C. Performance improves because no redo and undo are generated for the temporary tables

D. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache

Examine this command:

SQL>ALTER SYSTEM SET db_securefile = `IGNORE';

Which statement is true?

A. It forces SecureFiles to be created even if the BASICFILE option is specified

B. It forces SecureFiles to be created using default values and ignores any SECUREFILE parameters

C. It forces BasicFiles to be created even if the SECUREFILE option is specified

D. It ignores the SECUREFILE option only if storing the LOB segment in a Free List managed tablespace

Examine the query and its output executed in an RDBMS instance:

Which three statements are true about the users (other than SYS) in the output? (Choose three.)

A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)

B. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker

C. The C##A_ADMIN user can perform wallet operations

D. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus

E. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only