网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）
A
Archiver Process （ARCn）： 1， 2， 5
B
System Monitor Process （SMON）： 1， 4， 5
C
Process Monitor Process （PMON）： 4， 5， 6
D
Database Writer Process （DBWn）： 1， 3， 4
参考答案
参考解析
解析：
暂无解析
更多 “单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A Archiver Process （ARCn）： 1， 2， 5B System Monitor Process （SMON）： 1， 4， 5C Process Monitor Process （PMON）： 4， 5， 6D Database Writer Process （DBWn）： 1， 3， 4” 相关考题
考题
单选题You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database（）A
4 and 6B
2，3，4，and 6C
1，2，4，5，and 6D
1，2，3，4，5，and 6
考题
单选题The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects. Which statement is true in this scenario（）A
The statistics collection continues until all objects are processed.B
The job is terminated and the statistics collected are restored to a time before the job started.C
This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D
The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.
考题
单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）A
Multiplex all database filesB
Configure the Flash Recovery Area.C
Configure the database instance for ARCHIVELOG mode.D
Configure the FAST_START_MTTR_TARGET initialization parameter.
考题
单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A
Archiver Process （ARCn）： 1， 2， 5B
System Monitor Process （SMON）： 1， 4， 5C
Process Monitor Process （PMON）： 4， 5， 6D
Database Writer Process （DBWn）： 1， 3， 4
考题
单选题Observe the information in the columns： 1： The SGA a. Text and parsed forms of all SQL statements 2： The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved 3： User-session data c. Security and resource usage information 4：The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents（）A
1-c，2-b，3-d，4-aB
1-c，2-b，3-c，4-aC
1-a，2-b，3-c，4-dD
1-a，2-b，3-d，4-c
考题
单选题The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）A
Inactive and current redo log files are required to accomplish recovery.B
Online and archived redo log files are required to accomplish instance recovery.C
All redo log entries after the last checkpoint are applied from redo log files to data files.D
All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
考题
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）A
The XML scriptB
The PL/SQL scriptC
The DBMS_SCHEDULER packageD
Enterprise Manager to schedule the backup
热门标签
最新试卷