1Z0-053 Online Practice Questions and Answers

Questions 4

If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?

A. The command fails unless you specify the FORCE option.

B. The command fails unless you specify the REUSE option.

C. The command must be reissued with a more specific discovery string.

D. The other disks, already part of the disk group, are ignored.

Buy Now

Correct Answer: C

Refer to an Oracle Example for adding disk to diskgroup (link) How A Disk is Discovered

While an ASM instance is initialized, ASM discovers and examines the contents of all of the disks that are in the paths that you designated with values in the ASM_DISKSTRING initialization parameter. Disk discovery also occurs when you:

Run the ALTER DISKGROUP...ADD DISK and ALTER DISKGROUP...RESIZE DISK commands Query the V$ASM_DISKGROUP and V$ASM_DISK views

Disk Discovery Rules(link)

The rules for discovering ASM disks are as follows:

ASM can discover up to 10,000 disks. That is, if more than 10,000 disks match the ASM_DISKSTRING initialization parameter, then ASM discovers only the first 10,000.

ASM only discovers disks that contain a partition table.

Note:

ASM does not discover a disk that contains an operating system partition table, even if the disk is in an SM disk string search path and ASM has read and write permission for the disk.

When adding a disk, the FORCE option must be used if ASM recognizes that the disk was managed by Oracle. Such a disk appears in the V$ASM_DISK view with a status of FOREIGN. In this case, you can only add the disk to a disk group

by using the FORCE keyword.

In addition, ASM identifies the following configuration errors during discovery:

Multiple paths to the same disk

In this case, if the disk is part of a disk group, then disk group mount fails. If the disk is being added to a disk group with the ADD DISK or CREATE DISKGROUP command, then the command fails. To correct the error, adjust the

ASM_DISKSTRING value so that ASM will not discover multiple paths to the same disk. Or if you are using multipathing software, then ensure that you include only the pseudo-device name in the ASM_DISKSTRING value. See "ASM and

Multipathing".

Multiple ASM disks with the same disk header

This can be caused by having copied one disk onto another. In this case, the disk group mount operation fails.

Questions 5

View the Exhibits exhibit1 and exhibit2.

Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than

the process in exhibit2.

What is the reason for this?

lightweight-job-1 (exhibit):

lightweight-job-2 (exhibit):

A. It updates several tables in the SYSTEM tablespace instead of creating new tables.

B. It creates jobs temporarily in memory only.

C. It creates less metadata for the jobs.

D. It writes the job metadata to disk in compressed format.

Buy Now

Questions 6

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)

SQL>STARTUP UPGRADE

A. It enables all system triggers.

B. It allows only SYSDBA connections.

C. It ensures that all job queues remain active during the upgrade process.

D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Buy Now

Questions 7

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances

Buy Now

Questions 8

Which of the following statements is true regarding the VERSIONS BETWEEN clause?

A. The VERSIONS BETWEEN clause may be used in DML statements.

B. The VERSIONS BETWEEN clause may be used in DDL statements.

C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Buy Now

Questions 9

As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in the source and target database.

Which of the following steps are required to transport a tablespace from the database to the target database:

Make the tablespace read-only at the source database.

Export metadata from the source database.

Convert data filed by using Recovery Manager (RMAN).

Transfer the dump file and data filed to the target machine.

Import metadata at the target database.

Make the tablespace read/write at the target database.

Exhibit: A. 2, 4, and 5

B. All the steps

C. 2, 3, 4 and 5

D. 1, 2, 4, 5 and 6

Buy Now

Questions 10

Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)

A. Database datafiles

B. Online redo logs

C. Archived redo logs

D. Backup control file

E. Control file from a backup

Buy Now

Questions 11

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.

Which components are backed up when this option is specified?

A. only the control file, the current SPFILE, and data files

B. only the current SPFILE and data files if autobackup is disabled

C. only the data files and the archived redo logs

D. the control file, current SPFILE file, data files, and archived redo logs

Buy Now

Questions 12

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

A. The Oracle database will perform block checking for the index blocks only

B. The Oracle database will not perform block checking for any of the data blocks

C. The Oracle database will perform block checking for the default permanent tablespace only

D. The Oracle database will perform block checking for the data blocks in all user tablespaces

E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

Buy Now

Questions 13

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.

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

Buy Now