网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）
- A、ARCn
- B、CKPT
- C、DBWn
- D、LGWR
- E、PMON
- F、SMON
参考答案
更多 “While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A、ARCnB、CKPTC、DBWnD、LGWRE、PMONF、SMON” 相关考题
考题
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 processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A. ASMBB. PMONC. RBALD.SMON
考题
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?()
A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerB. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerC. BACKUP DATABASE while connected to the PDB1 containerD. BACKUP DATABASE while connected to the boot containerE. BACKUP PLUGGABLE database PDB1 while connected to PDB2
考题
Whileconnectedtothedatabase,auseronaPCreceivesafatalerrorandthemachinereboots.Whichbackgroundprocesscleansupthefailedconnection?()
A.ARCnB.CKPTC.DBWnD.LGWRE.PMONF.SMON
考题
Whichbackgroundprocessreadstheredologbufferandwritesittoafile?()
A.ARCnB.DBWnC.CKPTD.LGWRE.PMONF.SMON
考题
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A、 RBALB、 CKPTC、 SMOND、 PMONE、 MMONF、 CTWRG、 DBWR
考题
What is the new Oracle Shared Server?（）A、An improved version of multithreaded server configuration. B、A connection pooling configuration where several clients are connected to the same server process. C、Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. D、A configuration of Real Application Cluster where the client connection is routed to the least busy instance.
考题
Note the functionalities of various background processes： 1：Perform recovery at instance startup. SMON 2：Free the resources used by a user process when it fails. PMON 3：Cleanup the database buffer cache when a process fails. PMON 4：Dynamically register database services with listeners. PMON 5：Monitor sessions for idle session timeout. PMON 6：Cleanup unused temporary segments. SMON 7：Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process（）A、Checkpoint （CKPT）： 1， 2， 5B、System Monitor （SMON）： 1， 6C、Process Monitor （PMON）： 4， 6， 7D、Database Writer （DBWR）： 1， 3， 4
考题
Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A、PMONB、SMONC、CKPTD、LGWRE、ARCn
考题
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 processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
考题
Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A、 ASMBB、 PMONC、 RBALD、 SMON
考题
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?（）A、DBW0 B、LGWR C、ARCH D、SMON E、PMON
考题
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（）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
考题
Which background process reads the redo log buffer and writes it to a file？（）A、ARCnB、DBWnC、CKPTD、LGWRE、PMONF、SMON
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON
考题
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
考题
单选题While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A
ARCnB
CKPTC
DBWnD
LGWRE
PMONF
SMON
考题
单选题Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A
PMONB
SMONC
CKPTD
LGWRE
ARCn
考题
单选题Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A
ASMBB
PMONC
RBALD
SMON
考题
单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）A
mediaB
instanceC
statementD
user process
考题
单选题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 processB
Server processC
System Monitor (SMON)D
Process Monitor (PMON)E
Checkpoint process (CKPT)
考题
单选题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A
RBALB
CKPTC
SMOND
PMONE
MMONF
CTWRG
DBWR
考题
单选题Note the functionalities of various background processes： 1：Perform recovery at instance startup. SMON 2：Free the resources used by a user process when it fails. PMON 3：Cleanup the database buffer cache when a process fails. PMON 4：Dynamically register database services with listeners. PMON 5：Monitor sessions for idle session timeout. PMON 6：Cleanup unused temporary segments. SMON 7：Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process（）A
Checkpoint （CKPT）： 1， 2， 5B
System Monitor （SMON）： 1， 6C
Process Monitor （PMON）： 4， 6， 7D
Database Writer （DBWR）： 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
考题
多选题Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）ABACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerBBACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerCBACKUP DATABASE while connected to the PDB1 containerDBACKUP DATABASE while connected to the boot containerEBACKUP PLUGGABLE database PDB1 while connected to PDB2
考题
单选题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 processB
Server processC
System Monitor （SMON）D
Process Monitor （PMON）E
Checkpoint process （CKPT）
考题
单选题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（）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
热门标签
最新试卷