Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 341:

  Given the script

  create script db_backup_datafile_script

  {backup datafile and 1, and2 plus archivelog delete input;}

  What is the result of running this command?

  Run {execute script db_backup_datafile_script using 2;}

  A. The script will fail since you instructed RMAN to back up only one datafile rather than two.
  B. The script will successfully back up datafile 3 without error.
  C. The script will fail since it uses a substitution variable which is not supported.
  D. The execute script command will prompt for the value of and2 since it's not included in the command.
  E. The script will fail because you cannot use the plus archivelog command when backing up database datafiles.
  D. The execute script command will prompt for the value of and2 since it's not included in the command.

• Question 342:

  If a job references a schedule that has been disabled, what will be the result?

  A. The job will be automatically disabled.
  B. The job will never execute.
  C. The job will attempt to execute but will fail.
  D. The job will inherit the DEFAULT_SCHEDULE schedule.
  E. A schedule object cannot be disabled.
  E. A schedule object cannot be disabled.

• Question 343:

  What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?

  A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
  B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
  C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
  D. There is no ASM_POWER_LIMIT setting used in ASM.
  E. None of the above
  C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.

• Question 344:

  Evaluate the following statements:

  CREATE TABLE purchase_orders (

  po_id NUMBER(4),

  po_date TIMESTAMP,

  supplier_id NUMBER(6),

  po_total NUMBER(8,2),

  CONSTRAINT order_pk PRIMARY KEY(po_id))

  PARTITION BY RANGE(po_date) (

  PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES

  LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1oct-2007','d-mon-yyyy'), PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));

  CREATE TABLE purchase_order_items (

  po_id NUMBER(4) NOT NULL,

  product_id NUMBER(6) NOT NULL,

  unit_price NUMBER(8,2),

  quantity NUMBER(8),

  CONSTRAINT po_items_fk FOREIGN KEY (po_id)

  REFERENCES purchase_orders(po_id))

  PARTITION BY REFERENCE(po_items_fk);

  What are the two consequences of the above statements? (Choose two.)

  A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
  D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
  E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

• Question 345:

  A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated.

  Which Flashback option would allow you to undo this transaction and restore the table to its previous state?

  A. Flashback Drop
  B. Flashback Query
  C. Flashback Versions Query
  D. Flashback Transaction Query
  E. Flashback Table
  E. Flashback Table

• Question 346:

  Consider the following code snippet:

  

  If this code were executed, which of the following statements would be true?

  A. The priority of the lne_job1 job would be set to 1.
  B. The lne_job1 job would be executed synchronously.
  C. The lne_job1 job would run immediately in the users current session.
  D. The lne_job1 job would retain its current priority.
  E. The job will immediately take priority over all running jobs.
  A. The priority of the lne_job1 job would be set to 1.

• Question 347:

  When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)

  A. Tablespace name
  B. Storage quota
  C. Retention
  D. Table name
  E. Create a default archive
  A. Tablespace name
  C. Retention

• Question 348:

  You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?

  A. ASM_POWER_LIMIT
  B. ASM_DISKSTRING
  C. ASM_DISKGROUPS
  D. INSTANCE_TYPE
  A. ASM_POWER_LIMIT

• Question 349:

  You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog.

  You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.

  So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

  

  A. B. C. D.
  A. B. C. D.

• Question 350:

  Which view provides information on the backup status of the datafiles in the database?

  A. V$BACKUP
  B. V$BACKUP_STATUS
  C. V$BACKUP_DATAFILE
  D. V$DATAFILE_BACKUP
  E. V$TABLESPCE_BACKUP
  A. V$BACKUP