1Z0_067 questions • Exam prepare

Exam contains 176 questions

Page 22 of 30

Question 127 🔥

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

Which database solution meets these requirements?

A. Use job classes.

B. Use scheduler windows.

C. Use the mapping rule for the consumer groups.

D. Set the switch_time plan directive for both plans.

E. Use scheduler schedules.

Discussion of the question

Question 128 🔥

Which three statements are true about unplugging a pluggable database (PDB)?

Which database solution meets these requirements?

A. The PDB must be open in read only mode.

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-CDB.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another CDB.

F. The PDB data files are automatically removed from disk.

Discussion of the question

Question 129 🔥

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Which database solution meets these requirements?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B. In a PDB plan, subplans may be used with up to eight consumer groups.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan

Discussion of the question

Question 130 🔥

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Which database solution meets these requirements?

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset

E. The DMU can report columns that are not represented in the converted characterset

Discussion of the question

Question 131 🔥

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.After a few days, you want to alter the EMPLOYEES table by executing the command:SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);Which statement is true about the execution of the command?

Which database solution meets these requirements?

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

C. It executes successfully and continues to store metadata related to the EMPLOYEES table.

D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Discussion of the question

Question 132 🔥

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?

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