Create Next App

Exam contains 149 questions

Page 7 of 25

Question 37 🔥

Which new process was introduced as of Oracle Database 12c?

Which database solution meets these requirements?

A. Result Cache Background process (RCBG)

Highly voted

B. AQ Coordinator process (QMNC)

Highly voted

C. Change Tracking Writer process (CTWR)

Highly voted

D. Listener Registration process (LREG)

Highly voted

Discussion of the question

Question 38 🔥

Which two statements are true about this common user?

Which database solution meets these requirements?

A. SQL> conn c##usr/pwd@pdb1You are connected to PDB1 successfully.

Highly voted

B. SQL> conn c##usr/pwd@pdb2You are connected to PDB2 successfully.

Highly voted

C. SQL> conn c##usr/pwd@pdb2You are unable to create a connection. You first need to sync PDB2 by executing:SQL> conn / as sysdbaSQL>exec DBMS_PDB.SYNC_PDB;

Highly voted

D. SQL> conn c##usr/pwd@pdb2You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:SQL>conn system/pwd@pdb2SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;Now you are able to connect as common user c##usr to

Highly voted

Discussion of the question

Question 39 🔥

Which two statements are true regarding undo data records?

Which database solution meets these requirements?

A. They are required to support Flashback features.

Highly voted

B. They are not required if Flashback features are enabled.

Highly voted

C. They are retained until the session making the changes ends.

Highly voted

D. Undo records contain copies of data as it appears after a change is made.

Highly voted

E. Undo records contain copies of data as it appears before a change is made.

Highly voted

Discussion of the question

Question 40 🔥

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?

Which database solution meets these requirements?

A. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;

Highly voted

B. You alter the salesprd source database to open in read-only mode, and start cloning the source database:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

Highly voted

C. You alter the salesprd source database to open in read-only mode:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB:SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

Highly voted

D. Connected as the salesprd local DBA, you create an XML using:SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:SQL> CREATE PLUGGABLE

Highly voted

Discussion of the question

Question 41 🔥

Your database is down. You log in as the SYS user and issue this command:SQL> STARTUP -What happens after the instance is started?

Which database solution meets these requirements?

A. Nothing else happens.

Highly voted

B. The database is mounted but not opened.

Highly voted

C. The database is mounted and finally opened.

Highly voted

D. The database is opened and finally mounted.

Highly voted

Discussion of the question

Question 42 🔥

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