-
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens?()
A . log writer
B . archival
C . process monitor
D . system monitor
E . change tracking writer
F . database writer
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A . statistics recommendations
B . SQL Profile recommendations
C . Index-related recommendations
D . restructuring of SQL recommendatio
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()
A . modify the HASH_AREA_SIZE initialization parameter
B . modify the PGA_AGGREGATE_TARGET initialization parameter
C . modify the WORK_AREASIZE_POLICY initialization parameter
D . increase the value of the SGA_TARGET initialization parameter
E . increase the value of the SGA_MAX_SIZE initialization parameter
F . increase the value of the SORT_AREA_SIZE initialization parameter
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
A . The sessions are able to perform only queries.
B . The sessions are not affected and continue to function normally.
C . The sessions are terminated and the active transactions are rolled back.
D . The sessions are not allowed to perform any operations till the listener is started.
-
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?()
A . They are able to perform only queries.
B . They are not affected and continue to function normally.
C . They are terminated and the active transactions are rolled back.
D . They are not allowed to perform any operations until the listener LISTENER is started
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?()
A . Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B . Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C . Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D . Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
-
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
A . archival
B . log writer
C . database writer
D . system monitor
E . process monitor
F . change tracking writer
-
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
A . Oracle Net Manager
B . Listener Control utility
C . Database Configuration Assistant
D . Oracle Net Configuration Assistant
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
A . The sessions are able to perform only queries.
B . The sessions are not affected and continue to function normally.
C . The sessions are terminated and the active transactions are rolled back.
D . The sessions are not allowed to perform any operations till the listener is started
-
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
A . None. The database will switch over to the stand-by archive-log destination directory.
B . A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
C . The database will shut down, and will not restart until you correct the out-of-space situation.
D . The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
E . Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A . statistics recommendations
B . SQL profile recommendations
C . index-related recommendations
D . restructuring of SQL recommendatio
-
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
A . Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B . Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C . Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D . Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A . statistics recommendations
B . SQL profile recommendations
C . index-related recommendations
D . restructuring of SQL recommendatio
-
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
A . None. The database will switch over to the stand-by archive-log destination directory.
B . A warning message will be written to the alert log of the database,but no adverse impacts to the database will be experienced.
C . The database will shut down,and will not restart until you correct the out-of-space situation.
D . The database will continue to try to write to the archive-log destination directory for one hour. After one hour,the database will shut down normally.
E . Once Oracle has cycled through all online redo logs,it will stop processing any DML or DDL until the out-of-space condition is corrected.
-
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
A . You can perform open database backups.
B . You can perform closed database backups.
C . You cannot perform schema-level logical backups.
D . You can perform the backup of only the SYSTEM tablespace when the database is open.
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A . statistics recommendations
B . SQL Profile recommendations
C . Index-related recommendations
D . restructuring of SQL recommendatio
-
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A . Oracle Net Manager
B . Listener Control utility
C . Database Configuration Assistant
D . Oracle Net Configuration Assistant
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file,current SPFILE file,data files,and archived redo log
-
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()
A . The command restores only the missing control file.
B . The command restores all the control files.
C . The command fails because the database is running.
D . This is the correct way to address this problem.
E . This is not the correct way to address this problem.
-
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
A . User process
B . Server process
C . System Monitor (SMON)
D . Process Monitor (PMON)
E . Checkpoint process (CKPT)
-
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations