Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 291:

  What type of backup is stored in a proprietary RMAN format?

  A. Backup set
  B. Image copy
  C. Backup section
  D. Backup group
  A. Backup set

• Question 292:

  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.
  C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

• Question 293:

  While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?

  A. RECOVER FILE=1201 BLOCK=1968;
  B. RECOVER CORRUPTION LIST;
  C. RECOVER DATAFILE 1201 BLOCK 1968;
  D. RECOVER BLOCK CORRUPTION LIST;
  E. None of the above
  B. RECOVER CORRUPTION LIST;
  C. RECOVER DATAFILE 1201 BLOCK 1968;

• Question 294:

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

  

  Which statement is true about the outcome?

  A. Only one channel is allocated and the backup is created in the flash recovery area
  B. Only one channel is allocated and the backup is created in the destination specified for channel
  C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
  D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
  A. Only one channel is allocated and the backup is created in the flash recovery area

• Question 295:

  View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. Which statement is true about the block corruption detected by the command?

  

  A. No action is taken except the output in the Exhibit.
  B. The ADVISE FAILURE command is automatically called to display the repair script.
  C. The failure is logged into the Automatic Diagnostic Repository (ADR).
  D. The corruption is repaired by the command implicitly.
  C. The failure is logged into the Automatic Diagnostic Repository (ADR).

• Question 296:

  You issued the following commands to configure setting in RMAN;

  RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  Then you issued the following command to take the backup:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of the above command?

  A. The backup will terminate because the FORMAT clause was not configured for the channel
  B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
  C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

• Question 297:

  View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:

  SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));

  SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');

  At this moment, a second user also logs in to the HR schema and issues the following command:

  SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);

  What happens in the above scenario?

  Exhibit:

  

  A. The second user's session immediately produces the resource busy error.
  B. The second user's command executes successfully.
  C. The second user's session waits for a time period before producing the resource busy error.
  D. A deadlock is created.
  C. The second user's session waits for a time period before producing the resource busy error.

• Question 298:

  Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

  A. It repairs blocks that have read disk I/O errors.
  B. It checks whether the alias metadata directory and the file directory are linked correctly.
  C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
  A. It repairs blocks that have read disk I/O errors.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

• Question 299:

  What are three benefits of using ASM? (Choose three.)

  A. Ease of disk administration and maintenance
  B. Load balancing across physical disks
  C. Software RAID-1 data redundancy with double or triple mirrors
  D. Automatic recovery of failed disks
  A. Ease of disk administration and maintenance
  B. Load balancing across physical disks
  C. Software RAID-1 data redundancy with double or triple mirrors

• Question 300:

  View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? Exhibit:

  

  A. The incident has been newly created and is in the process of collecting diagnostic information.
  B. The incident is now in the Done state and the ADR can select the incident to be purged.
  C. The DBA is working on the incident and prefers that the incident be kept in the ADR.
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.