Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

Oracle 1z0-034 Exam - Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Download Free Oracle 1z0-034 Exam Questions

File name

Views

Size

Downloads

 

206

1.7 MB

246

Questions & Answers for Oracle 1z0-034

Showing 1-15 of 148 Questions

Question #1

You want to perform an RMAN backup of database as a copy. Which two factors will you
consider while performing the backup operation?

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database

Question #2

View the Exhibit and examine the parameter settings in your server-side parameter file
(SPFILE). When you tried to start the database instance, you received the following error:
SQL> startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal
settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

A. Because the PGA_AGGREGATE_TARGET parameter is not set

B. Because the STATISTICS_LEVEL parameter is set to BASIC

C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

Explanation:
Setting SGA Target Size
You enable the automatic shared memory management feature by setting the
SGA_TARGET parameter to an on zero value. This parameter sets the total size of the
SGA. It replaces the parameters that control the memory allocated for a specific set of
individual components, which are now automatically and dynamically resized (tuned) as
needed.
Note:
The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or
ALL for automatic shared memory management to function.

Question #3

Your database is running in ARCHIVELOG mode. You have been taking backups of all the
data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been
dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';
Identify the files that must be restored to recover the missing tables successfully.

A. Restore the backup of all the data files.

B. Restore the backup of all the data files and the control file.

C. Restore the backup of only the data files that contain the dropped tables.

D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.

Question #4

Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

A. It cancels all pending disk drops within the disk group.

B. It adds previously dropped disks back into the disk group.

C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

D. It mounts disks in the disk group for which the drop-disk operation has already been completed.

E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Question #5

You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)

A. ALTER TABLESPACE adtbs RESIZE 20G;

B. ALTER TABLESPACE adtbs ADD DATAFILE;

C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;

E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;

Explanation:
C:\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> CREATE BIGFILE TABLESPACE adtbs
DATAFILE'C:\adtbs.dbf' SIZE 1G;
Tablespace created.
(A)
SQL> ALTER TABLESPACE adtbs RESIZE 2G
Tablespace altered.
(B) and (D)
SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:\adtbs.dbf' SIZE 1G;
ALTER TABLESPACE adtbs ADD DATAFILE 'C:\adtbs.dbf' SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
(C)
SQL> ALTER TABLESPACE adtbs AUTOEXTEND ON;
Tablespace altered.
(E)
SQL> ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON;
ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option

Question #6

Which steps are mandatory to enable Direct NFS?
1. Mount all required file systems using the kernel NFS driver.
2. Create an oranfstab file containing the attributes for each NFS server to be accessed
using Direct NFS.
3. Replace the ODM library libodm11.so_stub with libodm11.so.

A. 2 and 3

B. 1 and 3

C. 1 and 2

D. 1, 2 and 3

Question #7

You are managing an Oracle Database 11g database. You configured the database to run
in ARCHIVELOG mode. Which two statements are true in this scenario?

A. You must shut down the database instance to perform the backups.

B. You must configure the flash recovery area (fast recovery area) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Question #8

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As
a DBA, which commands must you execute to enable SCOTT to flash back the
transactions?

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT ANY TRANSACTION TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Question #9

Examine the following scenario: The target database instance is running. The most recent
backup available for the target database was taken two days ago. Log files switches have
occurred in last two days. The target database is duplicated on the same host, using the
Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb;
Which statement is true about the duplicate database in this scenario?

A. It contains data till the last backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database

Question #10

Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion

Question #11

Identify two options that Oracle recommends while configuring the backup and recovery
environment for your recovery catalog. (Choose two.)

A. configuring control file autobackup to be ON

B. backing up data filed only and not the archived redo log files

C. running the recovery catalog database in NOARCHIVELOG mode.

D. setting the retention policy to a REDUNDANCY value greater than 1

E. backing up the recovery catalog to the same disk as that of the target database

Explanation:
Refer to here.
Configuring the Recovery Catalog Database
When you use a recovery catalog, RMAN requires that you maintain a recovery catalog
schema. The recovery catalog is stored in the default tablespace of the schema. The SYS
user cannot be the owner of the recovery catalog.
Decide which database you will use to install the recovery catalog schema, and also how
you will back up this database. Also, decide whether to operate the catalog database in
ARCHIVELOG mode, which is recommended.
Note: Do not use the target database to be backed up as the database for the recovery
catalog. The recovery catalog must be protected if the target database is lost.

Question #12

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

Question #13

You are using the control file to maintain information about the database backups that are
being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.

A. To store the backup information of multiple database

B. To restrict the amount of space that is used by the backups

C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

D. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.

Question #14

Which three elements can a job chain process involve? (Choose three)

A. an event

B. a schedule

C. a program

D. another chain

E. a lightweight job

Explanation:
Don't really understand the answer so far.
Defining Chain Steps
After creating a chain object, you define one or more chain steps. Each step can point to
one of the following:
✑ A Scheduler program object (program)
✑ Another chain (a nested chain)
✑ An event schedule, inline event, or file watcher

Question #15

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having
three disks.
One of the disks in the disk group becomes unavailable because of power failure. You
issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours
to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

A. all disks in the disk group

B. all disks that are currently in OFFLINE mode

C. all disks that are not currently in OFFLINE mode

D. all disks in the disk group only if all of them are ONLINE

Explanation:
Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks.
Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately.
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline
before Oracle ASM drops the disk. If a disk is made available before the
DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the
ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror
side. In Oracle Database 11g, the online disk operation does not restart if there is a failure
of the instance on which the disk is running. You must reissue the command manually to
bring the disk online.

You Need Avanset VCE Player in Order to Open VCE Files

Try Our Special 30% Discount Offer for
Premium 1z0-034 VCE File

  • Verified by experts

1z0-034 Premium File

  • Real Questions
  • Last Update: Sep 3, 2019
  • 100% Accurate Answers
  • Fast Exam Update

$14.99

$21.41

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected] and follow the directions.