1Z0-053 | how many questions of 1Z0-053 practice test?


Q341. You are managing an ASM instance. You previously issued the following statements:

ALTER DISKGROUP dg1 DROP DISK disk2;

ALTER DISKGROUP dg1 DROP DISK disk3;

ALTER DISKGROUP dg1 DROP DISK disk5;

You want to cancel the disk drops that are pending for the DG1 disk group.

Which statement should you issue?

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;

B. ALTER DISKGROUP dg1 UNDROP;

C. ALTER DISKGROUP dg1 UNDROP DISKS;

D. You cannot cancel the pending disk drops.

Answer: C

Q342. What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

A. Channel failover

B. Restartable backups

C. Rescheduable backups

D. Automatic backup recovery

E. Channel recovery

Answer: A

Q343. Which NLS parameter directly governs linguistic searches?

A. NLS_SEARCH_L

B. NLS_SORT

C. NLS_SEARCH

D. NLS_SORT_L

E. None of the above

Answer: B

Q344. Which three actions are required to configure the Flashback Database? (Choose three.)

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode

Answer: ABD

Q345. You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:

CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

Which statement is true?

A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled

B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up

C. Backup optimization is permanently disabled

D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

Answer: B

Q346. The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

A. Create two custom ADDM tasks.

B. Modify the AWR snapshot time interval to two hours.

C. Create a new scheduler window for a time period of two hours.

D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

Answer: B

Q347. You are managing a 24*7 database. The backup strategy for the database is to perform user- managed backups. Identify two prerequisites to perform the backups. (Choose two.)

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup

Answer: BC

Q348. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. failures because a data file is renamed by error

B. failures when no standby database is configured

C. failures that require no archive logs to be applied for recovery

D. failures due to loss of connectivity-for example, an unplugged disk cable

Answer: AD

Q349. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A. TEST_TBS is a small file tablespace.

B. TEST_TBS is a bigfile tablespace (BFT).

C. TEST_TBS is the default temporary tablespace.

D. TEST_TBS is a dictionary-managed tablespace.

Answer: D

Q350. While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.

Identify the two events that can occur in the event of a log switch? (Choose two.)

A. An entry is created in the alert log file and the database instance continues to function normally

B. The log switch hangs occur for transactions until free space is available in the flash recovery area

C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: BC