Online Access Free 1z0-034 Practice Test

Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

• A.It is a copy or a subset of the target database.
• B.It is opened in RESTRICT mode after a duplicating operation.
• C.It is created by using backups and archived redo log files from the target database.
• D.It is created with the same database identifier (DBID) as that of target database.

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
704
SQL> ALTER TABLE altb SHRINK SPACE COMPACT;
Table altered.
SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;
BLOCKS
704
View the Exhibit and examine the output and commands executed on the ALTB table.
Why does the number of blocks for the table remain the same after the shrink operation?

• A.because the row IDs remain the same for all rows during the shrink operation
• B.because the table did not contain migrated or chained rows
• C.because the progress of the shrink operation is not saved in the bitmap blocks of the table
• D.because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?

• A.Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• B.Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
• C.Perform Export before TSPITR and Import after TSPITR
• D.Move objects to another schema that has the same tablespace assigned

--- -
Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to 7 days in RMAN.
The most recent backup to disk for the TOOLS tablespace was taken on
November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

• A.The RMAN makes backup because optimization can be enabled only for backups to disk
• B.The RMAN backup fails because the TOOLS tablespace is read-only
• C.The RMAN makes the backup because no backup of the tablespace exists within the seven day window
• D.The RMAN skips the backup of the tablespace because backup optimization is enabled

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 7, because file name must have a .dat extension
• B.line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table
• C.line 9, because the PARALLEL option cannot be specified with one file name
• D.line 3, because ORGANIZATION EXTERNAL has been specified
• E.line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement
• F.line 2, because the column names have been specified