Create Next App

Question 49 🔥

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

Which database solution meets these requirements?

A. You cannot do this, because you can only clone PDBs into another CDB.

Highly voted

B. You can clone only one PDB (either PDB1 or PDB2) into the same CD

Highly voted

C. Cloning a PDB can use the source files copy method to the target PDB files.

Highly voted

D. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

Highly voted

Discussion of the question

Question 50 🔥

Question 51 🔥

What happens if you execute these SQL statements?SQL> show con_name -CON_NAME ---------------------------------CDB$ROOT -SQL> create user 1_freed identified by y container=current;

Which database solution meets these requirements?

A. A common user is created in the root container.

Highly voted

B. A local user is created in the root container.

Highly voted

C. A local user is created in all the PDBs.

Highly voted

D. The second SQL statement fails because a local user cannot be created in the root container.

Highly voted

Discussion of the question

Question 52 🔥

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

Which database solution meets these requirements?

A. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

Highly voted

B. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

Highly voted

C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

Highly voted

D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

Highly voted

Discussion of the question

Question 53 🔥

Which two statements are true about transactions in Oracle Database 12c?

Which database solution meets these requirements?

A. Multiple transactions can use the same undo segment.

Highly voted

B. A transaction is assigned an undo segment when it is started.

Highly voted

C. Multiple transactions cannot share the same extent in an undo tablespace.

Highly voted

D. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.

Highly voted

Discussion of the question

Question 54 🔥

Which statement about CDB architecture is true?

Which database solution meets these requirements?

A. Oracle-supplied metadata resides only in the root container.

Highly voted

B. A seed PDB can sometimes be opened for particular operations.

Highly voted

C. Multiple PDBs with the same name can reside in the same CDB.

Highly voted

E. You can create common users in PDBs.

Highly voted

D. A CDB can have an infinite number of PDBs.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_497

Exam contains 149 questions

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

Company

Product

Resources

Follow us