CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Online 1z0-060 Questions Video

Page: 5 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF

Upgrade to Oracle Database 12c Questions and Answers

Question 17

You executed startup restrict foe a multitenant container database (CDB) containing several LUGGABLE databases (PDBs).

You then attempt an alter PLUGGABLE database PDBI open for a PDB called PDB1.

What is the result?

Options:

A.

PDB1 opens read-only with restricted sessions enabled.

B.

PDB1 opens read-only with restricted sessions disabled.

C.

PDB1 opens read/write with restricted sessions disabled.

D.

The statement will fail because PDBs may not be opened read write when the CDB is In restricted session mode.

E.

PDBI opens read/write with restricted sessions enabled.

Question 18

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

Options:

A.

Re-enable redaction policies that use FULL data redaction.

B.

Re-create redaction policies that use FULL data redaction.

C.

Re-connect the sessions that access objects with redaction policies defined on them.

D.

Flush the shared pool.

E.

Restart the database instance.

Question 19

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c? (Choose five.)

Options:

A.

Restart the database Instance in RESTRICTED mode.

B.

Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.

C.

Shut down the database instance.

D.

Restart the database instance in UPGRADE mode.

E.

Restart the instance in normal mode.

F.

Run the Database Migration Assistant.

G.

Set the MAX_STRING_SIZE parameter to EXTENDED.

Question 20

You plan to drop the column of a table that has Flashback Archiving enabled.

You want to ensure minimal service disruption.

How would you do this in your Oracle 12c Database?

Options:

A.

Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

B.

Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

C.

Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

D.

Drop the column using the ALTER TABLE statement.

E.

Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

Page: 5 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF