Latest Oracle 1z1-067 Actual Free Exam Questions & Community Discussion, Page 5

Question #57

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00','YYYY-MM-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, 3, 6

B. 3, 4, 5

C. 1, 2, 5

D. 2, 3, 5, 6

Discussion 0

Correct Answer: C Vote an answer

Question #58

In which three scenarios is media recovery required?

A. when archived redo log files are lost

B. when a tablespace is accidentally dropped from a database

C. when all control files are lost

D. when data files are lost

E. when one of the online redo log members is corrupted

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #59

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

A. Corrupted blocks, if any, are repaired in the backup created.

B. Corrupted blocks in the data files are checked and repaired before performing the database backup.

C. Only those data files that have corrupted blocks are backed up.

D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Discussion 0

Correct Answer: D Vote an answer

Question #60

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB:
SQL>STARTUP
Which statement is true?

A. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode

B. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode

C. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

D. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode

E. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode

Discussion 0

Correct Answer: C Vote an answer

Question #61

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. No other table with the same name should exist in the HR schema.

B. The recycle bin should be enabled.

C. Undo retention guarantee must be enabled.

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

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

F. SCOTT should have the FLASHBACK ANY TABLE privilege.

Discussion 0

Correct Answer: B,D,F Vote an answer

Question #62

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

B. You can use EM express to manage multiple databases running on the same server.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You can create and configure pluggable databases by using EM express.

E. By default, EM express is available for a database after database creation.

Discussion 0

Correct Answer: E Vote an answer

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

Question #63

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.
A database with dbid=1423241 is registered in the catdb11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
$rman
RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;
What is the outcome of the import?

A. It fails because RMAN is not connected to the target database with DBID=1423241

B. It succeeds but the database is not automatically registered in the RC12C catalog.

C. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

D. It fails because the target database and recovery catalog database are of different versions.

Discussion 0

Correct Answer: D Vote an answer

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

Question #64

You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?

A. Use the mapping rule for the consumer groups.

B. Use scheduler schedules.

C. Set the switch_time plan directive for both plans.

D. Use scheduler windows.

E. Use job classes.

Discussion 0

Correct Answer: D Vote an answer

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

Question #65

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 that are marked obsolete according to the current retention policy

E. backups of tablespaces

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #66

Which two are prerequisites for setting up Flashback Data Archive?

A. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.

B. Undo retention guarantee should be enabled.

C. Automatic Undo Management should be enabled.

D. Fast Recovery Area should be defined.

E. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

F. Supplemental logging should be enabled.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #67

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.

A. 7, 6, 1, 2, 3, 5, 4

B. 7, 2, 1, 3, 5, 8

C. 7, 6, 1, 2, 9, 10, 4

D. 7, 6, 1, 2, 9, 10, 8

Discussion 0

Correct Answer: C Vote an answer

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

Question #68

You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?

A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

B. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

C. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the
/disk1/backups directory and its subdirectories.

D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

Discussion 0

Correct Answer: A Vote an answer

Question #69

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3. Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set DBID for the database.
Identify the required steps in the correct order.

A. 8, 1, 3, 2, 4, 5, 6

B. 1, 3, 2, 4, 8, 5, 6, 7

C. 8, 1, 3, 2, 4, 5, 7, 6

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

E. 8, 3, 2, 4, 5, 7, 6

Discussion 0

Correct Answer: E Vote an answer

Question #70

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 command succeeds only if all the PDBs have the users and temp tablespaces.

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

C. 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 tablespace does not exist in that PDB.

D. 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.

Discussion 0

Correct Answer: A Vote an answer

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

Oracle 1z1-067 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-067 Demo