[单项选择] Examine 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 corrupted -The 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 RESETLOGS option
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option

[单项选择] Examine 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 corrupted - The 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 RESETLOGS option.
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

[单项选择] 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 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

[多项选择] Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SZIE
F. DB_KEEP_CACHE_SIZE

[单项选择] Examine 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  RESETLOGS option.
C.  Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
D.  Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

[单项选择] Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

[单项选择]Which of the following database objects is considered executable using SQL?（）
A. View
B. Table
C. Routine
D. Package

[单项选择]Which of the following can be used to kill a running process?（）
A. Control Panel
B. Computer Management
C. Task Manager
D. Add/Remove Programs

[单项选择]Which of the following database objects can be used to raise an error if a table is updated?（）
A. Package
B. Trigger
C. Stored Procedure
D. Informational Constraint

[单项选择]On which of the following database objects may the SELECT privilege be controlled?（）
A. Sequence
B. Schema
C. Group
D. View

[多项选择] Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）
A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be monitored.

[单项选择] Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）
A. The optimizer used a dynamic plan for the query.
B. The optimizer chose different plans because automatic dynamic sampling was enabled.
C. The optimizer used re-optimization cardinality feedback for the query.
D. The optimizer chose different plan because extended statistics were created for the columns used.

[多项选择] Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

[单项选择]Which of the following is the BEST case scenario for power fault tolerance within a server?（）
A. Redundant power supplies with one power supply connected and one power supply as a hot spare.
B. Redundant power supplies with each connected to a separate power circuit.
C. Redundant power supplies connected via a Y-cable.
D. Redundant power supplies with each connected to the same power circuit.

[多项选择] Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）
A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

[单项选择] Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）
A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing

[单项选择] Examine the following excerpt from the show ip ospf database asbr -summary command on router R1 (RID 1.1.1.1). Which answer can be verified as definitely true based on this output?（） LS Type: Summary Links (AS Boundary Router) Link State ID: 9.9.9.9 (AS Boundary Router address) Advertising Router: 3.3.3.3 LS Seq Number: 8000000D Checksum: 0xE43A Length: 28 Network Mask: /0 TOS: 0 Metric: 100
A. The output describes the contents of a Type 5 LSA
B. 3.3.3.3 identifies a ro uter as being the router performing redistribution
C. R1's metric for its best route to reach the router with RID 9.9.9.9 is 100
D. The router with RID 3.3.3.3's metric for its best route to reach the router with RID 9.9.9.9 is 100

[单项选择] Examine the following excerpt from the show ip eigrp topology 10.2.2.0/24 command on router R1.Which answer can be verified as definitely true based on this output?（） External data: Originating router is 10.1.1.1 AS number of route is 1 External protocol is OSPF, external metric is 64 Administrator tag is 0 (0x00000000)
A. R1 is the router that redistributed the route
B. R1's metric to reach subnet 10.2.2.0/24 is 64
C. The route was redistributed on a router that has a router ospf 1 command configured
D. R1 is redistributing a route to prefix 1 0.2.2.0/24 into OSPF

[单项选择]Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?（）
A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption