Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 681:

  You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

  RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1; Then you issue the following commands:

  RMAN> CONNECT CATALOG vpc1/oracle@catdb;

  RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

  What is the outcome of the above commands?

  A. They execute and create a virtual catalog for pre-Oracle 11g clients.
  B. They produce an error because PROD1 and PROD2 databases belong to the older version.
  C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
  D. They produce an error because you need to connect to the target database to execute this packaged procedure.
  A. They execute and create a virtual catalog for pre-Oracle 11g clients.

• Question 682:

  Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

  A. ALTER DISKGROUP misc MOUNT;
  B. ALTER DISKGROUP misc DROP DISK misc2;
  C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
  D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
  E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
  A. ALTER DISKGROUP misc MOUNT;
  C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

• Question 683:

  What is the net effect of the following command? alter diskgroup dgroup1 drop disk abc;

  A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.
  B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
  C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.
  D. This command will fail because you cannot drop a specific disk in an ASM disk group.
  E. The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command, ASM will proceed to rebalance the disk group and then drop the disk.
  C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.

• Question 684:

  Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)

  A. SCN
  B. Timestamp
  C. Named recovery point
  D. Transaction ID
  E. Session ID
  A. SCN
  B. Timestamp
  C. Named recovery point

• Question 685:

  Which two statements regarding a SQL profile are true? (Choose two.)

  A. It is built by Automatic Tuning Optimizer.
  B. It cannot be stored persistently in the data dictionary.
  C. It can be used by the query optimizer automatically.
  D. It can be created manually by using the CREATE PROFILE command.
  A. It is built by Automatic Tuning Optimizer.
  C. It can be used by the query optimizer automatically.

• Question 686:

  When performing an online backup, what is the proper order of the following steps?

  a: Issue the ALTER DATABASE END BACKUP command.

  b: Back up the archived redo logs.

  c: Issue the ALTER DATABASE BEGIN BACKUP command.

  d: Back up the database files.

  e: Determine the beginning log sequence number.

  f: Determine the ending log sequence number.

  g:

  Force a log switch with the ALTER SYSTEM SWITCH LOGFILE command.

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

• Question 687:

  Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

  A. Flash recovery area must be defined
  B. Undo retention guarantee must be enabled.
  C. Database must be running in archivelog mode.
  D. Automatic undo management must be enabled.
  E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
  D. Automatic undo management must be enabled.
  E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

• Question 688:

  Which of the following are valid program types for a lightweight job? (Choose all that apply.)

  A. PLSQL_BLOCK
  B. EXECUTABLE
  C. JAVA_STORED_PROCEDURE
  D. STORED_PROCEDURE
  E. EXTERNAL
  A. PLSQL_BLOCK
  D. STORED_PROCEDURE

• Question 689:

  You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.

  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following

  command in regular intervals:

  SQL> EXECUTE

  DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');

  You need statistics to be collected more quickly.

  What can you do to achieve this?

  A. Set DYNAMIC_SAMPLING to level 4.
  B. Set the STATISTICS_LEVEL parameter to BASIC.
  C. Set the INCREMENTAL value to TRUE for the partition table.
  D. Increase the value of STALE_PERCENT for the partition table.
  C. Set the INCREMENTAL value to TRUE for the partition table.

• Question 690:

  Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose Three)

  A. Redo logs
  B. Control file
  C. The latest backup of only the damaged data file
  D. The latest backup of all the data file in the USERS tablespace
  E. Temporary files of temporary tablespace
  F. Archive Logs since the latest backup to point of failure
  A. Redo logs
  C. The latest backup of only the damaged data file
  F. Archive Logs since the latest backup to point of failure