Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 161:

  Examine the exhibit to view the parameters set in your parameter file. You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?

  Exhibit:

  

  A. 120M
  B. 320M
  C. 440M
  D. 600M
  D. 600M

• Question 162:

  The environmental variable ORACLE_BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set in your database.

  What will be the location of the ADR base?

  Exhibit:

  

  A. It is set to ORACLE_BASE.
  B. It is set to ORACLE_HOME/log.
  C. It is set to /u01/app/oracle/admin/orcl/adump.
  D. It is set to /u01/app/oracle/flash_recovery_area.
  A. It is set to ORACLE_BASE.

• Question 163:

  If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?

  A. TS_OBJECTS_TO_BE_DROPPED
  B. TS_PTTR_OBJECT_DROPPED
  C. TS_PITR_OBJECTS_TO_BE_DROPPED
  D. TS_OBJECTS_DROPPED
  E. TS_DROPPED_OBJECTS
  C. TS_PITR_OBJECTS_TO_BE_DROPPED

• Question 164:

  Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

  A. a cumulative level 1 backup
  B. a differential level 1 backup
  C. a full backup
  D. a whole backup
  A. a cumulative level 1 backup

• Question 165:

  Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

  A. PLSQL_BLOCK
  B. JAVA_STORED_PROCEDURE
  C. STORED_PROCEDURE
  D. EXECUTABLE
  E. None of the above are invalid settings.
  B. JAVA_STORED_PROCEDURE

• Question 166:

  Which of the following is not a valid linguistic sort element?

  A. Accent expansion
  B. Canonical equivalence
  C. Reverse secondary sorting
  D. Ignorable characters
  E. Character rearrangement
  A. Accent expansion

• Question 167:

  Observe the following PL/SQL block:

  BEGIN dbms_spm.configure('SPACE_BUDGET_PERCENT', 30); END;

  Which statement is correct regarding the above PL/SQL block?

  A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
  B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
  C. It reserves 30% of the space in the SYSTEM tablespace for SMB.
  D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
  D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

• Question 168:

  You want to make sure that your database backup does not exceed 10 hours in length.

  What command would you issue that would meet this condition?

  A. backup database plus archivelog;
  B. backup database plus archivelog until time 10:00;
  C. backup database plus archivelog timeout 10:00;
  D. backup database plus archivelog duration 10:00;
  E. backup database plus archivelog timeout 10:00;
  D. backup database plus archivelog duration 10:00;

• Question 169:

  Which two statements are true with respect to the maintenance window? (Choose two.)

  A. A DBA can enable or disable an individual task in all maintenance windows.
  B. A DBA cannot change the duration of the maintenance window after it is created.
  C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
  A. A DBA can enable or disable an individual task in all maintenance windows.
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

• Question 170:

  You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)

  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
  D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.