Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 361:

  Which of the following commands will fail?

  A. report schema;
  B. report need backup;
  C. report need backup days 3;
  D. report user;
  E. report obsolete;
  D. report user;

• Question 362:

  A user sends you an email with the following error message: create table idtable(id number)

  * ERROR at line 1:

  ORA-01116: error in opening database file 4

  ORA-01110: data file 4: '/oracle01/oradata/orcl/users01.dbf' ORA-27041: unable to open file Linux Error: 2:

  No such file or directory Additional information: 3

  You can choose from the following steps:

  a: Restore the missing database datafiles.

  b: Take the missing datafile offline.

  c: Shut down the database.

  d: Issue the recover tablespace USERS command.

  e: Issue the Startup Mount command to mount the database.

  f: Bring the USERS tablespace online.

  g:

  Issue the alter database open command.

  Which is the correct order of these steps in this case?

  A. b, a, d, f
  B. c, a, e, b, d, f, g
  C. c, e, d, g
  D. b, d, f
  E. e, d, g
  A. b, a, d, f

• Question 363:

  In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)

  A. partitioning recommendations
  B. statistics collection recommendations
  C. index creation recommendations
  D. materialized view recommendations
  E. materialized view log recommendations
  A. partitioning recommendations
  C. index creation recommendations
  D. materialized view recommendations
  E. materialized view log recommendations

• Question 364:

  Which of the following datatypes store time-zone information in the database?

  A. TIMESTAMP
  B. DATE
  C. TIMESTAMP WITH TIME ZONE
  D. TIMESTAMP WITH LOCAL TIME ZONE
  E. DATETIME
  C. TIMESTAMP WITH TIME ZONE

• Question 365:

  A user named Arren is executing this query: select table_name, operation, undo_sql from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;

  When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.

  Which of the following SQL statements will correct this problem?

  A. GRANT SELECT ANY TRANSACTION TO ARREN;
  B. GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
  C. GRANT SELECT_ANY_TRANSACTION TO ARREN;
  D. GRANT FLASHBACK TO ARREN;
  E. GRANT SELECT ANY VIEW TO ARREN;
  A. GRANT SELECT ANY TRANSACTION TO ARREN;

• Question 366:

  What is the end result of these commands if they are successful?

  RMAN> show retention policy;

  RMAN configuration parameters for database with db_unique_name ORCL are:

  CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default RMAN> backup database tag=gold_copy plus archivelog tag=gold_copy delete input; RMAN> backup database tag=silver_copy plus archivelog tag=silver_copy delete

  input;

  A. Attempting to restore silver_copy will fail.
  B. Attempting to restore gold_copy will fail.
  C. Both backups will be available for restore without question.
  D. Attempting to restore gold_copy may or may not succeed.
  E. You will not be able to restore either gold_copy or silver_copy.
  D. Attempting to restore gold_copy may or may not succeed.

• Question 367:

  Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?

  A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.
  B. The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.
  C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
  D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.
  B. The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.

• Question 368:

  The user SYS creates a job by using the following command:

  BEGIN

  DBMS_SCHEDULER.CREATE_JOB (

  job_name => 'update_sales',

  job_type => 'STORED-PROCEDURE',

  job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',

  start_date => '28-DEC-07 07.00.00 PM Australia/Sydney', repeat_interval => 'FREQ=DAILY;

  INTERVAL=2',

  end_date => '20-JAN-08 07.00.00 PM Australia/Sydney', comments => 'New sales job');

  END;

  /

  Which two statements are true about the job that was created by the preceding command? (Choose two.)

  A. The job is enabled by default after creation
  B. The job is automatically dropped after the end date
  C. The job executes with the privileges of the user SYS
  D. The globalization environment that exists at the time of the job creation prevails at the job runs
  B. The job is automatically dropped after the end date
  C. The job executes with the privileges of the user SYS

• Question 369:

  You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.

  How would you achieve this?

  A. Implement job classes
  B. Implement Scheduler windows
  C. Implement the mapping rule for the consumer groups
  D. Set the SWITCH_TIME resource plan directive for both the resource plans
  B. Implement Scheduler windows

• Question 370:

  When you are performing active database duplication, a backup of what kind is required?

  A. A current RMAN backup-set backup is required.
  B. No backup is required.
  C. An RMAN image backup is required.
  D. A manual backup is required.
  E. A "duplicate" preparatory backup is required.
  B. No backup is required.