Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 181:

  Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.

  A. 13:00 on Tuesday.
  B. 15:00 on Tuesday.
  C. Up until the last available archived redo log on Sunday.
  D. To any point; all the redo should still be available in the online redo logs.
  E. The database is not recoverable.
  E. The database is not recoverable.

• Question 182:

  Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  A. flashback query
  B. distributed transactions
  C. logging in and logging out of sessions
  D. all DDL statements having bind variables
  E. direct path load of data from external files
  C. logging in and logging out of sessions
  D. all DDL statements having bind variables

• Question 183:

  On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time?

  A. Check the alert log file
  B. Query the V$FLASHBACK_DATABASE_LOG view
  C. Query the V$RECOVERY_FILE_DEST_SIZE view
  D. Query the V$FLASHBACK_DATABASE_STAT view
  E. Check the value assigned for the UNDO_RETENTION parameter
  B. Query the V$FLASHBACK_DATABASE_LOG view

• Question 184:

  During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery.

  Which view or views would you use to determine this information? (Choose all that apply.)

  A. V$LOGFILE
  B. V$RECOVER_LOG
  C. V$RECOVER_DATABASE
  D. V$LOG_RECOVER
  E. V$LOG
  A. V$LOGFILE
  E. V$LOG

• Question 185:

  You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:

  RMAN>BACKUP SECTION SIZE 300M TABLESPACE users;

  What configuration should be effected to accomplish faster and optimized backups by using the above command?

  A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
  B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
  C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
  D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.
  C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.

• Question 186:

  View the Exhibit to examine the output for the V$DIAG_INFO view.

  Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

  Exhibit:

  

  A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
  B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
  C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
  A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
  C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

• Question 187:

  Examine the parameter setting in your database:

  

  Which statement is correct about the database?

  A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
  B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
  C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
  D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
  D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

• Question 188:

  Which command would correctly start a TSPITR of the USERS tablespace?

  

  A. B. C. D. E.
  E

• Question 189:

  Which of the following best describes a full backup?

  A. All datafiles of a database
  B. All datafiles, archive logs, and control files
  C. All datafiles and control files
  D. All the used blocks in a datafile
  D. All the used blocks in a datafile

• Question 190:

  The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

  A. owner
  B. touser
  C. attach
  D. remap_schema
  D. remap_schema