Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Question No: 101
SQLgt; SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
SQLgt; ALTER TABLE altb SHRINK SPACE COMPACT;
SQLgt; SELECT blocks FROM user_segments WHERE segment_name=*ALTB*; BLOCKS
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?
because the table did not contain migrated or chained rows
because the row IDs remain the same for all rows during the shrink operation
because the progress of the shrink operation is not saved in the bitmap blocks of the table
because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation
Question No: 102
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?
Mount the database
Open the database in NORMAL mode
Open the database in RESTRICTED mode
Open the database with the RESETLOGS option
Answer: A Explanation:
After restoring the control file, it is time to load the restored control file onto the database instance, to issue STARTUP MOUNT command to load it.
Question No: 103
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?
You must shut down the database instance to perform the backups.
You must configure the flash recovery area (fast recovery area) for the database.
You can perform complete database backups without closing the database.
All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.
Question No: 104
Identify two correct statements about the Active Session History (ASH) data.
A part of SGA memory is used to store ASH data as rolling buffer.
The ASH data can be analyzed between any two small time intervals.
All ASH data in memory are flushed to disk by MMON in every 3 seconds.
All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
Question No: 105
Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).
You can use RMAN stored scripts.
Recovery is faster if data is stored in catalog in addition to the control file.
You can store backup information of all registered databases in one place.
Database backups are automatically deleted when they are older than the specified time period.
Question No: 106
View the Exhibit and examine the steps that you executed to create a database resource plan.
Subsequently, you execute the following procedure which results in an error: SQLgt; EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?
The pending area is automatically submitted after the plan creation
The procedure must be executed before creating the resources plan directive
The SYS_GROUP resource consumer group is not included in the resource plan directive
The OTHER_GROUPS resources consumer group is not included in the resource plan directive
Question No: 107
Identify three key features of Oracle Data Pump (Choose three.)
Data Pump can stop a running job and resume it later
Data Pump can perform import using database link
Data Pump uses absolute path instead of relative path
Data Pump uses relative path instead of absolute path
Data Pump can perform incremental and cumulative exports
Question No: 108
You 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 ASM metadata 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.)
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 group configurations, and data on the disk group.
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 group configurations.
Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
Answer: B,C,D Explanation: Purpose
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description
md_restore backup_file [-silent]
[-full|-nodg|-newdg -o #39;old_diskgroup:new_diskgroup [,…]#39;] [-S sql_script_file] [-G #39;diskgroup [,diskgroup…]#39;]
Reads the metadata information from backup_file.
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.
Specifies to create a disk group and restore metadata.
Specifies 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
Write SQL commands to the specified SQL script file instead of executing the commands.
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.
Question No: 109
Which statement is true about a Scheduler-generated event?
It can be generated when a file arrives on the file system.
it indicates state changes that occur within the Scheduler itself.
it is raised by an application that is consumed by the Scheduler to start a job.
it requires jobs to be defined with an event condition and a queue specification.
Answer: D Explanation:
Consuming Job State Events with your Application
To consume job state events, your application must subscribe to the Scheduler event queue
SYS.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:
Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege.
Subscribe to the queue using a new or existing agent.
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 No: 110
Which three elements can a job chain process involve? (Choose three)
a lightweight job
Answer: B,D,E Explanation:
Don#39;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