Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 61:

  Your database is in NOARCHIVELOG mode.

  One of the two data files belonging to the SYSTEM tablespace is corrupt.

  You discover that all online redo logs have been overwritten since the last backup.

  Which method would you use to recover the data file using RMAN?

  A. Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

  B. Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

  C. Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance.

  D. Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

  E. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.

  Correct Answer: E

• Question 62:

  You execute these RMAN commands:

  BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST;

  What will these commands do?

  A. create a backup of the database and recover all corrupted blocks found in the backup

  B. perform a backup validation and list all logically and physically corrupt blocks in the database

  C. perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found

  D. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks

  E. create an image copy of the database and recover all corrupted blocks found in the image copy

  Correct Answer: D

• Question 63:

  Which two statements are correct about database transportation? (Choose two.)

  A. The source and target platforms must be the same

  B. Redo logs, control files and temp files are also transported

  C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

  D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

  E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

  Correct Answer: DE

• Question 64:

  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.

  Correct Answer: BC

• Question 65:

  View the Exhibits exhibit1 and exhibit2.

  Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs

  are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in

  exhibit1 takes less time than the process in exhibit2.

  What is the reason for this?

  lightweight-job-1 (exhibit):

  

  lightweight-job-2 (exhibit): A. It updates several tables in the SYSTEM tablespace instead of creating new tables.

  

  B. It creates jobs temporarily in memory only.

  C. It creates less metadata for the jobs.

  D. It writes the job metadata to disk in compressed format.

  Correct Answer: C

• Question 66:

  Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?

  A. the SYSTEM tablespace

  B. the default permanent tablespace for the non-SYSTEM users

  C. an offline tablespace

  D. a temporary tablespace

  E. a read-only tablespace

  F. an undo tablespace

  Correct Answer: BDEF

• Question 67:

  Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.

  1.

  CREATE TABLE employee_ext

  2.

  (employee_id, first_name, department_name)

  3.

  ORGANIZATION EXTERNAL

  4.

  (

  5.

  TYPE ORACLE_LOADER

  6.

  DEFAULT DIRECTORY ext_dir

  7.

  LOCATION ('emp1.dmp')

  8.

  )

  9.

  PARALLEL

  10.

  AS

  11.

  SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name

  12.

  FROM employees e, departments d; Which line of the command would cause an error?

  A. line 2, because the column names have been specified

  B. line 7, because file name must have a .dat extension

  C. line 3, because ORGANIZATION EXTERNAL has been specified

  D. line 9, because the PARALLEL option cannot be specified with one file name

  E. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table

  F. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement

  Correct Answer: F

• Question 68:

  You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates.

  Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?

  A. USERS

  B. SYSTEM

  C. SYSAUX

  D. EXAMPLE

  E. SAMPLE

  Correct Answer: A

• Question 69:

  While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.

  Which view would you query to determine the name and status of the stopped job?

  A. DBA_JOBS

  B. V$SESSION

  C. V$SESSION_LONGOPS

  D. DBA_DATAPUMP_JOBS

  E. DBA_DATAPUMP_SESSIONS

  Correct Answer: D

• Question 70:

  Note the output of the following query:

  SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;

  FLASHBACK_ARCHIVE_NAMESTATUS

  -------------------------------------------------------------- FLA1

  You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

  ALTERTABLEexchange_rateFLASHBACK ARCHIVE;

  What is the outcome of this command?

  A. The table uses the default Flashback Data Archive.

  B. The Flashback Data Archive is created in the SYSAUX tablespace.

  C. The Flashback Data Archive is created in the same tablespace where the tables are stored.

  D. The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.

  Correct Answer: A