Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 391:

  Examine the following values of the initialization parameters in the database having the SID ORCL:

  BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=

  The environment variables have the following value:

  ORACLE_BASE=/u01/app/oracle

  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

  What is the location of the Automatic Diagnostic Repository (ADR) home?

  A. /u01/app/oracle/product/11.1.0/db_1
  B. /u01/app/oracle
  C. $ORACLE_HOME/bdump
  D. $ORACLE_HOME/log
  B. /u01/app/oracle

• Question 392:

  You executed the following commands in a database session: Which statement is true about the contents of the recycle bin in this situation?

  

  A. They remain unaffected.
  B. They are moved to flashback logs.
  C. They are moved to the undo tablespace.
  D. They are moved to a temporary tablespace.
  E. The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.
  E. The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.

• Question 393:

  Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)

  A. BACKGROUND_DUMP_DEST
  B. FOREGROUND_DUMP_DEST
  C. CORE_DUMP_DEST
  D. USER_DUMP_DEST
  E. DIAGNOSTIC_DEST
  F. All of the above
  A. BACKGROUND_DUMP_DEST
  C. CORE_DUMP_DEST
  D. USER_DUMP_DEST

• Question 394:

  You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456;

  The employees table has triggers associated with it.

  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?

  A. All the triggers are disabled.
  B. All the triggers are enabled by default.
  C. Enabled triggers remain enabled and disabled triggers remain disabled.
  D. Triggers are deleted when a Flashback Table operation is performed.
  A. All the triggers are disabled.

• Question 395:

  You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? (Choose two.)

  A. Backup compression should be enabled
  B. Parallelism for the channel should be set to 2
  C. All the files must be backed up as backup sets
  D. The backup may be stored either on disk or on media with media manager
  C. All the files must be backed up as backup sets
  D. The backup may be stored either on disk or on media with media manager

• Question 396:

  Examine the section of the Health Check report given below:

  DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0 Source Incident Id : 7418 Number of Incidents Created :0

  Which two statements are true regarding the Health Check report? (Choose two.)

  A. Health Check was performed manually.
  B. Health Check was performed to check the disk image block corruptions.
  C. Health Check was performed to check interblock and intersegment corruption.
  D. Health Check was performed to verify the integrity of database files and report failures.
  E. Health Check was performed by the Health Monitor automatically in response to a critical error.
  A. Health Check was performed manually.
  B. Health Check was performed to check the disk image block corruptions.

• Question 397:

  Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

  A. The SGA Tuning Advisor
  B. The SQL Access Advisor
  C. The SQL Tuning Advisor
  D. The Memory Advisor
  C. The SQL Tuning Advisor

• Question 398:

  You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?

  A. You will need to open the database with the resetlogs command.
  B. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
  C. You will use the resetlogs version of the create controlfile command.
  D. You will use the noresetlogs version of the create controlfile command.
  E. You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
  D. You will use the noresetlogs version of the create controlfile command.

• Question 399:

  Examine the following RMAN command:

  BACKUP DATABASE

  TAG TESTDB

  KEEP UNTIL 'SYSDATE+1'

  RESTORE POINT TESTDB06;

  Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

  A. Only data files and the control file are backed up.
  B. Archived redo logs are backed up only if the database is open during the backup.
  C. The backup is deleted after one day, regardless of the default retention policy settings.
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
  B. Archived redo logs are backed up only if the database is open during the backup.
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

• Question 400:

  You executed the following command to drop a user: DROP USER scott CASCADE;

  Which two statements regarding the above command are correct? (Choose two.)

  A. All the objects of scott are moved to the Recycle Bin.
  B. Any objects in the Recycle Bin belonging to scott are purged.
  C. All the objects owned by scott are permanently dropped from the database.
  D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
  E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
  B. Any objects in the Recycle Bin belonging to scott are purged.
  C. All the objects owned by scott are permanently dropped from the database.