oracle.prepaway.1z0-034.v2018-11-28.by.daniel€¦ · you are using the control file to maintain...

https://www.gratisexam.com/

1z0-034.exam.87q

Number: 1z0-034Passing Score: 800Time Limit: 120 min


1z0-034

Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP


Exam A

QUESTION 1You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using theDBMS_NETWORK_ACL_ADMIN package.

Which statement is true regarding the ACL created?


A. It is a list of remote database links stored in the XML file that are available to the users of the database.

B. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

C. It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.

D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages suchas UTL_TCP.

Correct Answer: BSection: (none)Explanation

Explanation/Reference:Explanation:The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL).Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access externalnetwork services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them.Typically, you use this feature to control access to applications that run onspecific host addresses.To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create theaccess control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. Thisguideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for generalconceptual information about access control lists, see Oracle XMLDB Developer's Guide.

QUESTION 2Which four resources can directives be specified by using the Oracle Resource Manager?

A. CPU usage


B. degree of parallelism

C. number of open cursors

D. number of sorts performed

E. idle time for blocking sessions

F. number of I/Os requests

Correct Answer: ABEFSection: (none)Explanation

Explanation/Reference:

QUESTION 3You 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.

Correct Answer: ADSection: (none)Explanation


QUESTION 4View the Exhibit.


You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method.

You execute the command shown on the exhibit, but only two files have been created.

Which parameter must be changed so that four files are created?

A. TYPE

B. LOCATION

C. PARALLEL

D. DEFAULT DIRECTORY

E. ORGANIZATION EXTERNAL

Correct Answer: CSection: (none)Explanation


QUESTION 5Which three statements are true about windows?

A. Only one window can be open at any given time


B. Consumer groups are associated with windows

C. Windows work with job classes to control resource allocation

D. The database service name must be provided during windows creation

E. Windows can automatically start job or change resource allocation among jobs for various time periods.

Correct Answer: ACESection: (none)Explanation


QUESTION 6Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;

Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

Correct Answer: ASection: (none)Explanation

Explanation/Reference:Explanation:The BEFORE DROP clause uses Recycle Bin;The FLASHBACK DATABASE uses flashback logs at FRA area.

QUESTION 7View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received thefollowing error:


SQL> startupORA-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/Reference:Explanation:Setting SGA Target SizeYou enable the automatic shared memory management feature by setting the SGA_TARGET parameter to an on zero value. This parameter sets the total size ofthe SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamicallyresized (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 8Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A. An ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Correct Answer: CDSection: (none)Explanation


QUESTION 9You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usagein the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area islow on specie and you have no more room on disk.

Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

A. Change the RMAN archived log deletion policy.

B. Use the RMAN CROSSCHECK command to reclaim the archived log space.



C. Change the RMAN retention policy to retain backups for a shorter period of time.

D. Use OS command to move files from the flash recovery area to some other location

Correct Answer: BDSection: (none)Explanation


QUESTION 10Which 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*';

Correct Answer: ACSection: (none)Explanation

Explanation/Reference:Explanation:Altering Disk GroupsYou can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online.Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUPstatement can reduce rebalancing operations.Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until theoperation is complete before returning. Query theV$ASM_OPERATION view to monitor the status of this operation.add_disk_clause


Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group aspart of this operation.drop_disk_clauseUse this clause to drop one or more disks from the disk group.DROP DISKThe DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASMrelocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCEkeyword.

QUESTION 11What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The number of DBWR processes increases

B. The number of ASMB processes increases

C. The number of DBWR_TO_SLAVES increases

D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead

Correct Answer: DSection: (none)Explanation


QUESTION 12Your database initialization parameter file has the following entry:

SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3

Which statement is true regarding this setting?

A. It drops the connection after the specified number of login attempts fail for any user.

B. It is enforced only if the password profile is enabled for the user.

C. It locks the user account after the specified number of attempts.

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege.




QUESTION 13You observed the following output for a user session:

What do you infer from the preceding output?

A. Resumable set for session with sid 18

B. The user session has entered into a deadlock

C. The database instance is enabled to use asynchronous commit

D. The threshold warning limit is exceeded for the tablespace that is used by the user session



QUESTION 14In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.

In addition, reports are generated using complex joins with non-equality operators.What table organization is the best for this workload?

A. heap table

B. object table

C. external table

D. sorted hash clustered table

E. global temporary table

F. hash clustered table




QUESTION 15Examine the following scenario:

Database is running in ARCHIVELOG mode.Complete consistent backup is taken every Sunday.On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.The hardware is repaired and the paths for online redo log files and control files are still valid.

Which option would you use to perform the recovery of database till the point of failure?

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.

C. Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.



QUESTION 16You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

SQL> SELECT object_name, original_name, droptime FROM recyclebin;


What would be the outcome of the precedent statement?

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column



QUESTION 17Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different host computers.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Correct Answer: BCDSection: (none)Explanation



QUESTION 18Your database is open and running in ARCHIVELOG mode.

You take RMAN full backups every Sunday night.On Monday morning, while querying the user1.emoloyees table, you receive the following error message:

01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf*

You need to recover from this while ensuring that:

1. The data file remains online.2. Mean Time To Recover (MTTR) is minimized as much as possibleYou have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?

A. flash back the corrupted blocks

B. use the DBMS_REPAIR package

C. use RMAN tablespace point in time recovery

D. use the RMAN BLCCKRECOVER command

E. perform a table point in time recovery with datapump export and import



QUESTION 19You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Identify the statement that correctly describes the implications of this command.

A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups.

D. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.



Explanation/Reference:Explanation:Configuring a Redundancy-Based Retention PolicyThe REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level 0 backups of each data file and control filethat RMAN should keep. If the number of full or level 0backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers theextra backups as obsolete. The default retention policy is REDUNDANCY 1.As you produce more backups, RMAN keeps track of which ones to retain and which are obsolete. RMAN retains all archived logs and incremental backups thatare needed to recover the non obsolete backups.Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and Thursday. You now have four full backups of this data file. IfREDUNDANCY is 2, then the Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the Wednesday backup of data file 7becomes obsolete. Assume a different case in which REDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1 cumulative backup atnoon on Tuesday and Wednesday, and a level 0 backup at noon on Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE.The Wednesday DELETE command does not remove the Tuesday level 1 backup because this backup is not redundant: the Tuesday level 1 backup could be usedto recover the Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday. However, the DELETE command on Thursday removes theprevious level 0 and level 1backups.Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example: CONFIGURE RETENTION POLICY TO REDUNDANCY3;

QUESTION 20Examine 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 21You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.

Which two statements are true?

A. You must ensure that the SALES database is mounted or open.

B. You must restore a backup control file to perform a block media recovery.

C. You must take the tools01.dbf data file offline before you start a block media recovery.

D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

Correct Answer: AESection: (none)Explanation


QUESTION 22Examine the parameter settings in your database.


Which statement is correct about the database?

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program GlobalArea (PGA) will be distributed at startup


Explanation/Reference:http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#47750

Configuring Automatic PGA MemoryWhen configuring a brand new instance, it is hard to know precisely the appropriate setting for PGA_AGGREGATE_TARGET. You can determine this setting inthree stages:


Make a first estimate for PGA_AGGREGATE_TARGET, based on a rule of thumb. By default, Oracle uses 20% of the SGA size. However, this initial setting maybe too low for a large DSS system.

Run a representative workload on the instance and monitor performance, using PGA statistics collected by Oracle, to see whether the maximum PGA size is under-configured or over-configured.

Tune PGA_AGGREGATE_TARGET, using Oracle PGA advice statistics.

QUESTION 23memory_target big integer 808Mpga_aggregate_target big integer 0sga_target big integer 0SQL> SHOW PARAMETER SGA_MAX_SIZE

NAME TYPE VALUE-------------------------------------------------------------------------------------------------sga_max_size big integer 808MWhich statement is correct about the database?

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

C. SGA_TARGET are set.

D. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for ProgramGlobal Area (PGA) will be distributed at startup.

Correct Answer: ESection: (none)Explanation


QUESTION 24The DB_BLOCK_CHECKING parameter is set to FALSE.

What level of block checking will be performed?

A. The Oracle database will not perform block checking for any of the data blocks.

B. The Oracle database will perform block checking for the default permanent tablespace only.


C. The Oracle database will perform block checking for the data blocks in all user tablespaces.

D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.



QUESTION 25As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the sourcedatabase are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the featuresinthe source and target database.

Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

1. Make the tablespace read-only at the source database.2. Export metadata from the source database.3. Convert data filed by using Recovery Manager (RMAN).4. Transfer the dump file and data filed to the target machine.5. Import metadata at the target database.6. Make the tablespace read/write at the target database.

Exhibit:


A. 2, 4, and 5

B. All the steps

C. 2, 3, 4 and 5

D. 1, 2, 4, 5 and 6


Explanation/Reference:Explanation:Refer to here. Generate a Transportable Tablespace Set


read_only--expdp--4-import-read_wrtie

1, 2, 4, 5, 6 (optional)

If both platforms have the same endianness, no conversion is necessary. Otherwise you must do aconversion of the tablespace set either at the source ordestination database.Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to any otherdirectory of your choosing.

Run the following query to determine the location of DATA_PUMP_DIR:SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';

Transport the data files to the location of the existing data files of the destination database.On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or +DISKGROUP/SID/datafile/.

QUESTION 26You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10gdatabases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes thefollowing command to grantprivileges 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 packagedprocedure.




QUESTION 27Examine the following command for RMAN backup:

RMAN> RUN {ALLOCATE CHANNEL c1 DEVICE TYPE sbt;ALLOCATE CHANNEL c2 DEVICE TYPE sbt;ALLOCATE CHANNEL c3 DEVICE TYPE sbt;BACKUPINCREMENTAL LEVEL = 0(DATAFILE 1,4,5 CHANNEL c1)(DATAFILE 2,3,9 CHANNEL c2)(DATAFILE 6,7,8 CHANNEL c3);SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';}

Which statement is true regarding the approach in the command?

A. The RMAN multiplexing level is 4.

B. It is the use of asynchronous I/O by RMAN.

C. It is a case of parallelization of the backup set.

D. It is an implementation of a multi section backup.



QUESTION 28Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

A. It's only supported for the backups performed on the tape

B. It is not supported for backup operations that produce image copies

C. Duplex backups need a parallelism for the device to be equal to number of copies

D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously




QUESTION 29To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?(Choose two.)

A. Multiple change tracking files can be created for a database.

B. The change tracking file must be created after the first level 0 backup.

C. RMAN does not support backup and recovery of the change tracking file.

D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Correct Answer: CDSection: (none)Explanation


QUESTION 30For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

A. fixed tables

B. heap tables

C. external tables

D. temporary tables

E. Index-Organized Tables (IOTs)

F. views

Correct Answer: BESection: (none)Explanation



QUESTION 31The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.Which statement is true while performing a tape backup in an RMAN session?

A. The tape I/O performed is asynchronous

B. The tape buffer is allocated from the System Global Area (SGA)

C. The tape buffer is allocated from the Program Global Area (PGA)

D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes


Explanation/Reference:Explanation:Tape I/O SlavesRMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA),depending on whether I/O slaves are used. If you set theinitialization parameterBACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only beaccessed by one process at a time, so RMAN startsas many slaves as necessary for the number of tapedevices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers fromthelarge pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA.If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory toholding these large memory allocations. This parameterprevents RMAN I/O buffers from competing with thelibrary cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space intheSGA for them, slaves are not used, and a message appears in the alert log.The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than thenumber of slave processes. Tape devices can only beaccessed by one process at a time, and RMAN uses thenumber of slaves necessary for the number of tape devices.

QUESTION 32What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space




QUESTION 33You 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 34You executed the following commands:

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.




QUESTION 35Which two statements are true about encrypting RMAN backups?

A. The transparent encryption of backups uses the encryption wallet.

B. The database uses the same encryption key for every encrypted backup.

C. The password encryption of backups only uses the password while creating and restoring backups.

D. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.



QUESTION 36After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option youwould consider for the new database?

A. Opening the database in RESTRICTED mode

B. Opening the database with the RESETLOGS option

C. Setting a new DBID for the newly restored database

D. Restoring the server parameter file (SPFILE) to the new host



QUESTION 37You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10gdatabases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes thefollowing 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.



QUESTION 38Examine the following command for RMAN backup:

RMAN> RUN {ALLOCATE CHANNEL c1 DEVICE TYPE sbt;ALLOCATE CHANNEL c2 DEVICE TYPE sbt;ALLOCATE CHANNEL c3 DEVICE TYPE sbt;BACKUPINCREMENTAL LEVEL = 0(DATAFILE 1,4,5 CHANNEL c1)(DATAFILE 2,3,9 CHANNEL c2)(DATAFILE 6,7,8 CHANNEL c3);SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';}

Which statement is true regarding the approach in the command?


A. The RMAN multiplexing level is 4.

B. It is the use of asynchronous I/O by RMAN.

C. It is a case of parallelization of the backup set.

D. It is an implementation of a multisection backup.



QUESTION 39Which two statements are true about the duplexing of the backups taken by RMAN?

A. It's only supported for the backups performed on the tape

B. It is not supported for backup operations that produce image copies

C. Duplex backups need a parallelism for the device to be equal to number of copies

D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously



QUESTION 40To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?(Choose two.)

A. Multiple change tracking files can be created for a database.

B. The change tracking file must be created after the first level 0 backup.

C. RMAN does not support backup and recovery of the change tracking file.

D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Correct Answer: CDSection: (none)


Explanation


QUESTION 41You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. OnNovember 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespaceexisted 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 thecontrol file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands thatare required to accomplish the task?


A. Option A

B. Option B

C. Option C

D. Option D



QUESTION 42Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?


A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group afterthe operation.

D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for datamanipulation language (DML) operations.



QUESTION 43View the Exhibit to examine the replay settings for replay parameters.

What is the implication for setting the values for replay parameters? (Choose all that apply.)

Exhibit:


A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

Correct Answer: ACDSection: (none)Explanation


QUESTION 44In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigatingthe reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the


lost data of the table without affecting objects in other schemas.

Which method must you use to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery (TSPITR)

D. Incomplete Recovery with system change number (SCN)



QUESTION 45Evaluate the following block of code:

What is the outcome of the above code?

A. It produces an error because a fully qualified host name needs to be specified.

B. It produces an error because the range of ports associated with the hosts has not been specified.

C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.


D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.



QUESTION 46What two are the prerequisites for enabling Flashback Database?

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined

Correct Answer: ABSection: (none)Explanation


QUESTION 47Which statements are true regarding system-partitioned tables? (Choose all that apply.)

A. Only a single partitioning key column can be specified.

B. All DML statements must use partition-extended syntax.

C. The same physical attributes must be specified for each partition.

D. Unique local indexes cannot be created on a system-partitioned table.

E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Correct Answer: DESection: (none)Explanation



QUESTION 48The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactionsthat consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these usersessions and you do not want these sessions to perform long-running operations.

How would you achieve this?

A. Implement a profile for the users.

B. Implement external roles for the users.

C. Set the threshold for the undo tablespace.

D. Implement a Database Resource Manager plan.



QUESTION 49You 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


Explanation/Reference:USERSThis tablespace is used to store permanent user objects and data. Like the TEMP tablespace, every database should have a tablespace for permanent user data


that is assigned to users. Otherwise, user objects will be created in the SYSTEM tablespace, which is not good practice. In the preconfigured database, USERS isassigned the default tablespace, and space for all objects created by non-system users comes from this tablespace. For system users, the default permanenttablespace remains SYSTEM.REF.: Oracle(r) 10g 2 Days DBA, 6-7

QUESTION 50While 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


Explanation/Reference:When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself.* monitor jobs from multiple locations* stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater* kill any Datapump job anytime* see the progress of the import or export operations

REF.: Metalink Note: 262557.1

QUESTION 51Evaluate 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('1-oct-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: BCSection: (none)Explanation


QUESTION 52You 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


Explanation/Reference:Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta010.htm

QUESTION 53Your 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, andrestart 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 theinstance.

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, andrestart 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 theinstance.

Correct Answer: ESection: (none)Explanation

Explanation/Reference:Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm (restoring the server parameter file)

QUESTION 54ENCRYPT_TS is an encrypted tablespace that contains tables with data.

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?


A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is read into memory.

C. The data remains encrypted when it is stored in the redo logs.

D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.



QUESTION 55Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before youstarted the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists inanother tablespace, MASTERTBS.

Which two actions will permit the TSPITR to work? (Choose two.)

A. Taking the MASTERTBS tablespace offline

B. Dropping the relationship between the tables

C. Adding the MASTERTBS tablespace to the recovery set

D. Putting the MASTERTBS tablespace in read-only mode



QUESTION 56In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings inRMAN:


Which statement is true about the outcome?

A. Only one channel is allocated and the backup is created in the flash recovery area

B. Only one channel is allocated and the backup is created in the destination specified for channel

C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA



QUESTION 57You want to track and store all transactional changes to a table over its lifetime.To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.

To accomplish this, you issued the following command:ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.


C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data older than three years is purged from the flashback archive FLA1.



QUESTION 58You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.

From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have beengenerated. What could be the reason for this?

A. The EVEN parameter was not set.

B. The SQL_TRACE parameter is set to FALSE.

C. Enterprise Manager is not used.

D. The STATISTICS_LEVEL parameter is set to BASIC.


E. The TIMED_STATISTICS parameter is set to FALSE.



QUESTION 59Which two statements are true regarding hot patching? (Choose two.)


A. It requires relinking of the Oracle binary.

B. It does not require database instance shutdown.

C. It can detect conflicts between two online patches.

D. It is available for installing all patches on all platforms.

E. It works only in a single database instance environment.


Explanation/Reference:Explanation:Online PatchingRegular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain.so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll backonline patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaroundtime for installing or de-installing Online Patches.

A regular RDBMS patch can require many minutes to install, since it requires instance shutdown, a relink, and instance startup. On the other hand, you can installan online patch in just a few seconds.Online patches are only applicable for Oracle RDBMS and not any other products. Online patches are currently supported on the following Windows and UNIXplatforms for version 11.2.0.1.0 and later:

Linux x86Linux x86_64HP-UX ItaniumSolaris SPARC 64-bitSolaris AMD 64-bitAIX (AIX 6.1 and later)

About Patch Conflicts:

All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch.This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.

QUESTION 60In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attemptto restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need torecover the data file by using the image copy.

Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you


consider for this task?

A. using only the RMAN SWITCH command to set the new location for the data file

B. placing the database in the MOUNT state for the restore and recovery operations.

C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

D. configuring two channels: one for the restore operation and the other for the recovery operation



QUESTION 61Consider 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 backup fails because the TOOLS tablespace is read-only

B. The RMAN skips the backup of the tablespace because backup optimization is enabled

C. The RMAN makes backup because optimization can be enabled only for backups to disk

D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window



QUESTION 62Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: Whatcould have helped you to correlate server sessions with channels?


A. Implement RMAN multiplexing

B. Set the DEBUG ON in the RMAN script

C. Specify the command ID in the RMAN script

D. Use a tag with the RMAN BACKUP command



QUESTION 63Note the following parameter settings: Which setting is NOT allowed?


A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;



QUESTION 64You created a tablespace with the following statement:CREATE BIGFILE TABLESPACE adtbsDATAFILE '/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/Reference:C:\sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> CREATE BIGFILE TABLESPACE adtbsDATAFILE'C:\adtbs.dbf' SIZE 1G;Tablespace created.(A)SQL> ALTER TABLESPACE adtbs RESIZE 2GTablespace altered.(B) and (D)SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:\adtbs.dbf' SIZE 1G;ALTER TABLESPACE adtbs ADD DATAFILE 'C:\adtbs.dbf' SIZE 1GERROR 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 ONERROR at line 1:ORA-02142: missing or invalid ALTER TABLESPACE option

QUESTION 65Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)


E. Recovery Manager (RMAN) backup piece

Correct Answer: BCESection: (none)Explanation


QUESTION 66Identify three key features of Oracle Data Pump (Choose three.)

A. Data Pump can stop a running job and resume it later

B. Data Pump can perform import using database link

C. Data Pump uses absolute path instead of relative path

D. Data Pump uses relative path instead of absolute path

E. Data Pump can perform incremental and cumulative exports

Correct Answer: ABDSection: (none)Explanation


QUESTION 67You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASMmetadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.

Which of these methods would you use to achieve this? (Choose all that apply.)

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure groupconfigurations, and data on the disk group.

B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure groupconfigurations.

C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

Correct Answer: BCD


Section: (none)Explanation

Explanation/Reference:Explanation:PurposeThe md_restore command restores disk groups from a metadata backup file.Syntax and Description

md_restore backup_file [--silent][--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]'][-S sql_script_file] [-G 'diskgroup [,diskgroup...]']backup_file

Reads the metadata information from backup_file.--silentIgnore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.--fullSpecifies to create a disk group and restore metadata.--nodgSpecifies to restore metadata only.--newdg -o old_diskgroup:new_diskgroup]Specifies to create a disk group with a different name when restoring metadata. The -o option is required with--newdg.-S sql_script_fileWrite SQL commands to the specified SQL script file instead of executing the commands.-G diskgroupSelect the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.

QUESTION 68Which statement is true about a Scheduler-generated event?

A. It can be generated when a file arrives on the file system.

B. it indicates state changes that occur within the Scheduler itself.

C. it is raised by an application that is consumed by the Scheduler to start a job.

D. it requires jobs to be defined with an event condition and a queue specification.



Explanation/Reference:Explanation:Consuming Job State Events with your ApplicationTo consume job state events, your application must subscribe to the Scheduler event queueSYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following:

1. Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege.2. Subscribe to the queue using a new or existing agent.3. Run the package procedure DBMS_AQADM.ENABLE_DB_ACCESS as follows:DBMS_AQADM.ENABLE_DB_ACCESS(agent_name, db_username); where agent_name references the agent that you used to subscribe to the events queue,and db_username is the user for whom you want to create a subscription.There is no need to grant dequeue privileges to the user. The dequeue privilege is granted on the Scheduler event queue to PUBLIC.

QUESTION 69Which 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

Correct Answer: BDESection: (none)Explanation

Explanation/Reference:Explanation:Don't really understand the answer so far.Defining Chain StepsAfter 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 70You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to atape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recoverthe target database and make it functional. You consider performing the following steps to accomplish the task:


1. Restore an autobackup of the server parameter file.2. Restore the control file3. Start the target database instance4. Mount the database5. Restore the data files6. Open the database with RESETLOGS option7. Recover the data files8. Set DBID for the target database

Which option illustrates the correct sequence that you must use?

A. 8, 1, 3, 2, 4, 5, 7, 6

B. 1, 8, 3, 4, 2, 5, 7, 6

C. 1, 3, 4, 2, 8, 5, 6, 7

D. 1, 3, 2, 4, 6, 5, 7, 8


Explanation/Reference:Explanation:Recovering the Database After a DisasterThe procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring thedatabase to a new host, then you should also review the considerations described in "Restoring a Database on a New Host".This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database toOracle Secure Backup and have the tapes available. The scenario assumes the following:

Oracle Database is already installed on the new host.You are restoring the database to a new Linux host with the same directory structure as the old host.You have one tape drive containing backups of all the data files and archived redo logs through log 1124, and autobackups of the control file and serverparameter file.You do not use a recovery catalog with the database.

To recover the database on the new host:1. If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.2. Start RMAN and connect to the target database instance.At this stage, no initialization parameter file exists. If you have set ORACLE_SID and ORACLE_HOME, then you can use operating system authentication toconnect as SYSDBA. For example, start RMAN as follows:

% rman


RMAN> CONNECT TARGET/

3. Specify the DBID for the target database with the SET DBID command, as described in "Restoring the Server Parameter File".For example, enter the following command:SET DBID 676549873;4. Run the STARTUP NOMOUNT command.When the server parameter file is not available, RMAN attempts to start the instance with a dummy server parameter file.5. Allocate a channel to the media manager and then restore the server parameter file from autobackup.For example, enter the following command to restore the server parameter file from Oracle Secure Backup:

RUN{ALLOCATE CHANNEL c1 DEVICE TYPE sbt;RESTORE SPFILE FROM AUTOBACKUP;}

6. Restart the instance with the restored server parameter file.STARTUP FORCE NOMOUNT;7. Write a command file to perform the restore and recovery operation, and then execute the command file.The command file should do the following:a. Allocate a channel to the media manager.b. Restore a control file autobackup (see "Performing Recovery with a Backup Control File and No Recovery Catalog").c. Mount the restored control file.d. Catalog any backups not recorded in the repository with the CATALOG command.e. Restore the data files to their original locations. If volume names have changed, then run SETNEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the datafiles, as shown in the following example.f. Recover the data files. RMAN stops recovery when it reaches the log sequence number specified.

RMAN> RUN{# Manually allocate a channel to the media managerALLOCATE CHANNEL t1 DEVICE TYPE sbt;# Restore autobackup of the control file. This example assumes that youhave# accepted the default format for the autobackup name.RESTORE CONTROLFILE FROM AUTOBACKUP;# The set until command is used in case the database# structure has changed in the most recent backups, and you want to# recover to that point in time. In this way RMAN restores the database# to the same structure that the database had at the specified time.


ALTER DATABASE MOUNT;SET UNTIL SEQUENCE 1124 THREAD 1;RESTORE DATABASE;RECOVER DATABASE;}

The following example of the RUN command shows the same scenario except with new file names for the restored data files:

RMAN> RUN{# If you must restore the files to new locations,# use SET NEWNAME commands:SET NEWNAME FOR DATAFILE 1 TO '/dev/vgd_1_0/rlvt5_500M_1';SET NEWNAME FOR DATAFILE 2 TO '/dev/vgd_1_0/rlvt5_500M_2';SET NEWNAME FOR DATAFILE 3 TO '/dev/vgd_1_0/rlvt5_500M_3';ALLOCATE CHANNEL t1 DEVICE TYPE sbt;RESTORE CONTROLFILE FROM AUTOBACKUP;ALTER DATABASE MOUNT;SET UNTIL SEQUENCE 124 THREAD 1;RESTORE DATABASE;SWITCH DATAFILE ALL; # Update control file with new location of data files.RECOVER DATABASE;}

8. If recovery was successful, then open the database and reset the online logs:ALTER DATABASE OPEN RESETLOGS;

QUESTION 71Which three tasks can be performed using a duplicate database? (Choose three.)

A. Testing the backup and recovery procedures

B. Testing the upgrade of an Oracle database to a new release

C. Testing the effect of an application changes on database performance

D. Continuously updating archive log files from the target database to support failover

Correct Answer: ABCSection: (none)Explanation



QUESTION 72Refer to the exhibit.

Examine the Following commands and their output:

View the Exhibit and examine the Flashback Version Query that was executed after the preceding commands.

What could be the possible cause for the query not displaying any row?

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.




QUESTION 73You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMANrepository.

Which condition must be met before you create the VPC?

A. A base catalog exists

B. The recovery catalog is empty

C. The base recovery catalog must be dropped

D. A target database is registered in the recovery catalog



QUESTION 74You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneousduplicate backup of the data files when the RMAN BACKUP command is used.

What must you set using the RMAN CONFIGURE command to achieve this?

A. MAXSETSIZE TO 2;

B. DEVICE TYPE DISK PARALLELISM 2;

C. RETENTION POLICY TO REDUNDANCY 2;

D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;



Explanation/Reference:Explanation:Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)

QUESTION 75Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

A. SORT_AREA_SIZE

B. HASH_AREA_SIZE

C. BITMAP_MERGE_AREA_SIZE

D. CREATE_BITMAP_AREA_SIZE

E. PGA_AGGREGATE_TARGET

Correct Answer: ABCDSection: (none)Explanation


QUESTION 76Which 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 77Examine the following command that is used to duplicate a database on the same host:

RMAN> RUN{ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY;}

Which two statements describe the effect after the database is duplicated successfully? (Choose two)

A. The data files of the read-only tablespaces in the target database are not duplicated


B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database

Correct Answer: ABSection: (none)Explanation


QUESTION 78In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching.

B. It can be installed and uninstalled via OPatch unlike conventional patching.

C. It takes more time to install or uninstall compared with conventional patching.

D. It does not require down time to apply or remove unlike conventional patching.

E. It is not persistent across instance startup and shutdown unlike conventional patching.




QUESTION 79You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the followingstatement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regardingthe mytbs tablespace? (Choose two)

A. It is a smallfile tablespace.

B. It is a bigfile tablespace (BFT).

C. It is a default bigfile tablespace.

D. It is a locally managed tablespace.

E. It is a dictionary-managed tablespace.


Explanation/Reference:Explanation:Specify either SET DEFAULT BIGFILE TABLESPACE or SET DEFAULTSMALLFILETABLESPACE. If you omit this clause, the default is a smallfiletablespace, which is the traditional type of Oracle Database tablespace.Verify also:SELECT tablespace_name, extent_management, bigfileFROM dba_tablespacesWHERE tablespace_name = 'MYTHBS';TABLESPACE_NAME EXTENT_MANAGEMENT BIGFILEMYTHBS LOCAL NO

QUESTION 80View Exhibit1 to examine the CRS11G disk group when all the disks are online.View Exhibit2 to examine the CRS11G disk group when one disk is offline.

Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?


ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):


A. Because the disk group is created with NORMAL redundancy

B. Because the disk repair time attribute is set to a nonzero value

C. Because the mirrored extents cannot be rebalanced across the other three disks

D. Because the other three disks have 60% free space, the disk rebalancing is delayed

Correct Answer: B


Section: (none)Explanation

Explanation/Reference:Explanation:Key points:1. The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.12. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr.Refer to here.Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".

Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought backonline.By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation byspecifying a time interval to repair the disk and bring it back online.

QUESTION 81Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

A. It bypasses the OS file system cache.

B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.

C. It uses the operating system kernel NFS layer for user tasks and network communication modules.

D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

Correct Answer: AESection: (none)Explanation

Explanation/Reference:Explanation:Direct NFS provides faster performance that what can be provided by the operating system's NFS driver as Oracle bypasses the operating system and generatesexactly the requests it needs (no user configuration or tuning required). Data is cached just once in user space, which saves memory (no second copy in kernelspace). Performance is further improved by load balancing across multiple network interfaces (if available).

QUESTION 82Identify 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/Reference:Explanation:Refer to here.Configuring the Recovery Catalog DatabaseWhen you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of theschema. 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 catalogdatabase 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 islost.

QUESTION 83UNDO__RETENTION is set to 1000 and retention is not guaranteed.

You configure the database with a fixed size undo tablespace.

Which is true about undo retention in this configuration?

A. Undo expires after 1000 seconds and is deleted.

B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

C. Inactive undo is retained for at least 1000 seconds if free undo space is available.

D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSAUX tablespace to provide read consistency.



QUESTION 84You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:


SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP=>'group1', COMMENT => 'New Group'); This command errors out displaying the following message:ERROR at line 1:ORA-29371: pending area is not activeORA-06512: at "SYS.DBMS_RMIN", line 115ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1What action would you take to overcome this error?

A. activate the Pending Area before creating the consumer group

B. create the Pending Area before creating the consumer group

C. increase the size of the database buffer cache to accommodate the Pending Area

D. increase the size of the shared pool to accommodate the Pending Area

E. increase the size of the large pool to accommodate the Pending Area



QUESTION 85Which three file types are managed by Data Pump jobs?

A. out files

B. log files

C. alert files

D. SQL files

E. error files

F. dump files

Correct Answer: BDFSection: (none)Explanation


QUESTION 86


During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.How would this environment variable setting affect the installation?

A. The installation terminates with an error.

B. The installation proceeds with the default value without warnings and errors.

C. The installation proceeds with the default value but it would not be an OFA-compliant database.

D. The installation proceeds with the default value but a message would be generated in the alert log file.



QUESTION 87Examine the following RMAN script:

RMAN> run {debug on;allocate channel c1 type disk;backup datafile 5;}

Which statement describes the purpose of the script?

A. The data file is checked for physical corruption and backed up if found clean.

B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed



oracle.prepaway.1z0-034.v2018-11-28.by.daniel€¦ · you are using the control file to maintain...

Documents