Online Access Free Oracle.1Z0-060.v2021-08-28.q107 Practice Test (Page 13)

1Z0-060 Exam Question 56

To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE('SH', 'SALES', 'INT_SALES', 600); What is the significance of the dml_lock_timeoutperiod of 600 seconds in the preceding command?

A.All pending DML statements on the SALEStable must be committed 600 seconds before the procedure ends gracefully.

B.All pending DML statements on the SALEStable will wait for 600 seconds before the procedure ends gracefully.

C.All pending DML statements on the SALES_INTtable must be committed 600 seconds before the procedure ends gracefully.

D.It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

1Z0-060 Exam Question 57

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?

A.The ASM compatibility attribute controls the format of the disk group metadata.

B.RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C.The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

D.The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

E.The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Correct Answer: A,B,D

A, D: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.
B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Incorrect Answers:
E:
/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
/ You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create a volume in a disk group.

1Z0-060 Exam Question 58

You plan to migrate your database from a File system to Automatic Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task? (Choose two.)

A.RMAN CONVERTcommand

B.Data Pump Export and import

C.Conventional Export and Import

D.The BACKUP AS COPY DATABASE ... command of RMAN

E.DBMS_FILE_TRANSFERwith transportable tablespace

1Z0-060 Exam Question 59

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?

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

B.The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

C.Only the ORD_CUSTOMER_IX1 index is created.

D.Only the ORD_CUSTOMER_IX2 index is created.

E.Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

1Z0-060 Exam Question 60

The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

A.2, 4, 5

B.2, 1, 4, 3, 5

C.1, 2, 3, 4, 5

D.1, 2, 4, 5

Other Version: 108Oracle.Braindumpsit.1Z0-060.v2022-05-19.by.brian.119q.pdf; 2716Oracle.1Z0-060.v2022-02-05.q119; 114Oracle.Itpass4sure.1Z0-060.v2021-09-12.by.haley.189q.pdf

Latest Upload: 167ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 135SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 135SAP.C_SIGPM_2403.v2025-09-08.q20; 254EXIN.ITIL.v2025-09-08.q161; 170BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-060 Exam Question 56

1Z0-060 Exam Question 57

1Z0-060 Exam Question 58

1Z0-060 Exam Question 59

1Z0-060 Exam Question 60

Download PDF File