Online Access Free Oracle.1Z1-060.v2021-08-31.q180 Practice Test (Page 8)

1Z1-060 Exam Question 31

Which two are prerequisites for performing a flashback transaction?

A.Flashback Database must be enabled.

B.Undo retention guarantee for the database must be configured.

C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D.Supplemental logging must be enabled.

E.Recycle bin must be enabled for the database.

F.Block change tracking must be enabled tor the database.

1Z1-060 Exam Question 32

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

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 and the shares provided to the consumer groups in the PDB plan.

1Z1-060 Exam Question 33

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A.Effectively implements role separation

B.Enables you to take advantage of Oracle Managed Files.

C.Automatically registers the database with Oracle Restart.

D.Helps you to easily upgrade the database from a prior release.

E.Enables the Installation of Grid Infrastructure files on block or raw devices.

1Z1-060 Exam Question 34

On your Oracle 12c database, you issue the following commands to create indexes:
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which statement is correct?

A.Both the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.

B.Only the ORD_CUSTOMER_IX1 index is created and it is visible.

C.Both the indexes are created and both of them are visible.

D.Both the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.

1Z1-060 Exam Question 35

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A.The DBMS_PDB package

B.Data Pump full export / import

C.Transportable tablespace

D.Transportable database

E.RMAN

Other Version: 68Oracle.Latestcram.1Z1-060.v2022-05-23.by.verna.110q.pdf; 2126Oracle.1Z1-060.v2022-04-28.q110; 115Oracle.Pass4training.1Z1-060.v2021-08-16.by.jennifer.153q.pdf

Latest Upload: 165ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 164Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z1-060 Exam Question 31

1Z1-060 Exam Question 32

1Z1-060 Exam Question 33

1Z1-060 Exam Question 34

1Z1-060 Exam Question 35

Download PDF File