Oracle Database 11g Administration II

Here you have the best Oracle 1z0-053 practice exam questions

You have 697 total questions to study from
Each page has 5 questions, making a total of 140 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 24, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 697

The INV_HISTORY table is created using the command:
Exam 1z0-053: Question 1 - Image 1

The following data has been inserted into the INV_HISTORY table:
Exam 1z0-053: Question 1 - Image 2

You would like to store the data belonging to the year 2006 in a single partition and issue the command:

SQL> ALTER TABLE inv_history -

MERGE PARTITIONS -
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),
FOR(TO_DATE('15-apr-2006'))
INTO PARTITION sys_py;
What would be the outcome of this command?

It executes successfully, and the transition point is set to '1-apr-2006'.

It executes successfully, and the transition point is set to '15-apr-2006'.

It produces an error because the partitions specified for merging are not adjacent.

It produces an error because the date values specified in the merge do not match the date values stored in the table.

Correct Answer: C

Question 2 of 697

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

The number of DBWR processes increases

The number of ASMB processes increases

The number of DBWR_TO_SLAVES increases

The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

Correct Answer: D

Question 3 of 697

ASM supports all but which of the following file types? (Choose all that apply.)

Database files

SPFILEs

Redo-log files

Archived log files

RMAN backup sets

Password files

init.ora files

Correct Answer: F, G

What Types of Files Does Oracle ASM Support?
Exam 1z0-053: Question 3 - Image 1

Question 4 of 697

After executing the command -
ALTER DISKGROUP diskgroup2 DROP DISK dg2a;
You issue the following command from the ASM instance:
SELECT group_number, COUNT(*) FROM v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?

The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

The drop disk operation is complete and you can run the undrop disks command if needed.

The drop disk operation is complete and you cannot run the undrop disks command.

The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.

None of the above is true.

Correct Answer: C

Question 5 of 697

What is the net effect of the following command?
alter diskgroup dgroup1 drop disk abc;

The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.

The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.

This command will fail because you cannot drop a specific disk in an ASM disk group.

The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you

Correct Answer: C