Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 311:

  You issue the following command on the RMAN prompt.

  REPORT NEED BACKUP DAYS 5;

  Which statement is true about executing this command?

  A. It will display a list of files that need incremental backup
  B. It will display a list of files that need backup after five days
  C. It will display a list of files that were backed up in the last five days
  D. It will display a list of files that have not been backed up in the last five days
  E. It will apply the current retention policy to determine the files that need to be backed up
  D. It will display a list of files that have not been backed up in the last five days

• Question 312:

  You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  A. Data Pump Export and Import
  B. conventional export and import
  C. the CONVERT command of RMAN
  D. the BACKUP AS COPY command of RMAN
  D. the BACKUP AS COPY command of RMAN

• Question 313:

  When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?

  A. To indicate the location of the auxiliary-instance online redo logs.
  B. To indicate the location of the target database datafiles.
  C. To indicate the location of the auxiliary-instance control file and online redo logs.
  D. To indicate the location of the auxiliary-instance database datafiles.
  E. This is not a valid parameter when duplicating a database.
  D. To indicate the location of the auxiliary-instance database datafiles.

• Question 314:

  In what view are you likely to see the following output?

  

  A. V$SESSION_EVENT
  B. V$SESSION
  C. V$WAITS
  D. V$WAITSTAT
  E. V$SYSSTAT
  B. V$SESSION

• Question 315:

  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
  A. set Flash Recovery Area
  B. enable Flashback logging
  D. start the database in the ARCHIVELOG mode

• Question 316:

  What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)

  A. It cannot generate recommendations that support multiple workload queries.
  B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
  C. It can recommend partitioning only on tables that have at least 10,000 rows.
  D. It can recommend only B-tree indexes and not bitmap or function-based indexes.
  B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
  C. It can recommend partitioning only on tables that have at least 10,000 rows.

• Question 317:

  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.
  B. It allows only SYSDBA connections.
  D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

• Question 318:

  You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT;

  What is the implication of this command?

  A. The client RDBMS instance can access the file as a read-only file.
  B. A new disk cannot be added to a disk group.
  C. A disk in a disk group can be taken offline.
  D. The client RDBMS instance cannot access the files in the disk group.
  D. The client RDBMS instance cannot access the files in the disk group.

• Question 319:

  Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

  

  A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
  B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
  D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.
  C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

• Question 320:

  View the Exhibit and note the contents of V$DIAG_INFO.

  Which statement is true about the ADR?

  Exhibit:

  

  A. The text alert log file will be available in Diag Trace
  B. A copy alert log file will be kept in Diag Incident for every incident.
  C. The XML version of the alert log file will be available in Diag Trace.
  D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.
  A. The text alert log file will be available in Diag Trace