1Z0_067 questions • Exam prepare

Exam contains 176 questions

Page 21 of 30

Question 121 🔥

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:RMAN> DUPLICATE TARGET DATABASE TO dup1FROM ACTIVE DATABASE -NOFILENAMECHECK -PASSWORD FILE -SPFILE;Which two statements are true about the execution of the duplicate command?

Which database solution meets these requirements?

A. All archive redo log files are automatically copied to the duplicate database.

Highly voted

B. The duplicate database has the same directory structure as the source database.

C. The duplicate database is created by using the backups created during the execution of

D. the duplicate command.

E. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Highly voted

Discussion of the question

Question 122 🔥

A user issues a query on the sales table and receives the following error:ERROR at line 1:ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'ORA-27037: unable to obtain file statusWhich two actions would you take to recover the temporary tablespace?

Which database solution meets these requirements?

A. Drop the tenpOi.dbf file, and then re-create the temp file.

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

Highly voted

E. Create a new temporary tablespace and assign it as the default to the user.

Highly voted

Discussion of the question

Question 123 🔥

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.Which two actions would you take to solve this problem?

Which database solution meets these requirements?

A. Enable temporary undo for the database.

B. Enable undo retention guarantee.

C. Increase the size of the redo log buffer.

D. Enable Automatic Memory Management (AMM).

Highly voted

E. Increase the size of the temporary tablespace.

Highly voted

Discussion of the question

Question 124 🔥

Which two statements are true about service creation for pluggable databases (PDBs)?

Which database solution meets these requirements?

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

Highly voted

D. Only a common user can create additional services for a PDB.

E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Highly voted

Discussion of the question

Question 125 🔥

You want to move your existing recovery catalog to another database.Examine the steps:1)Export the catalog data by using the Data Pump Export utility in the source database.2) Create a recovery catalog user and grant the necessary privileges in the target database.3) Create a recovery catalog by using the create catalog command.4)Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.5)Import the source recovery catalog schema by using the import catalog command.6)Connect to the destination database.7) Connect as catalog to the destination recovery catalog schema.Identify the option with the correct sequence for moving the recovery catalog.

Which database solution meets these requirements?

A. 1, 6, 4

B. 2, 3, 7, 5

C. 1, 2, 6, 4

Highly voted

D. 1, 2, 3, 6, 5

Discussion of the question

Question 126 🔥

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 TABLEYou then successfully execute the command:SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;Which two statements are true?

Which database solution meets these requirements?

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

Highly voted

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

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

Highly voted

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.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_067

Exam contains 176 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us