Checkpoint (CKPT): 1, 2, 5
System Monitor (SMON): 1, 6
Process Monitor (PMON): 4, 6, 7
Database Writer (DBWR): 1, 3, 4
第1题:
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?()
第2题:
During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?()
第3题:
Note the following functionalities of various background processes: 1:Record the checkpoint information in data file headers. CKPT 2:Perform recovery at instance startup. SMON 3:Cleanup unused temporary segments. SMON 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()
第4题:
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第5题:
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?()
第6题:
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()
第7题:
System monitor (SMON)
Process monitor (PMON)
Memory manager process (MMAN)
Manageability Monitor process (MMON)
第8题:
ASMB
PMON
RBAL
SMON
第9题:
It transfers statistics from memory to disk at regular intervals.
It coordinates the rebalance activity for disk groups when ASM is used.
It communicates with the Automatic Storage Management (ASM) instance on behalf of the database Instance.
It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
第10题:
Archiver Process (ARCn): 1, 2, 5
System Monitor Process (SMON): 1, 4, 5
Process Monitor Process (PMON): 4, 5, 6
Database Writer Process (DBWn): 1, 3, 4
第11题:
Uses undo data for roll forward
Uses Flashback Log for recovery
Uses online redo logs to roll back
Uses undo data to roll back the transaction
Uses Recovery Manager (RMAN) to roll back
Uses the System Monitor (SMON) background process to perform instance recovery
第12题:
System monitor (SMON)
Process monitor (PMON)
Memory manager process (MMAN)
Manageability Monitor process (MMON)
第13题:
Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
第14题:
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第15题:
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()
第16题:
You work as a database administrator for Certkiller .com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
第17题:
Which statement is true about the Manageability Monitor (MMON) background process()
第18题:
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()
第19题:
uses undo data for roll forward
uses Flashback Log for recovery
uses online redo logs to roll back
uses undo data to roll back the transaction
uses Recovery Manager (RMAN) to roll back
uses the System Monitor (SMON) background process to perform instance recovery
第20题:
Archiver Process (ARCn): 1, 2, 5
System Monitor Process (SMON): 1, 4, 5
Process Monitor Process (PMON): 4, 5, 6
Database Writer Process (DBWn): 1, 3, 4
第21题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第22题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第23题:
Archiver Process (ARCn):1, 2,5
System Monitor Process (SMON):1,4,5
Process Monitor Process (PMON):4,5,6
Database Writer Process (DBWn):1,3,4