违法和不良信息举报 联系客服
免费注册 登录

单选题Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A PMONB SMONC CKPTD LGWRE ARCn

题目
单选题
Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）
A

PMON

B

SMON

C

CKPT

D

LGWR

E

ARCn

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Oracle Instance由哪两个部分组成?()

A. Shared pool和Server process

B. Shared pool和Background process

C. SGA和user process

D. PGA和user process

E. SGA和Background process


参考答案：E

第2题：

Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）

  • A、PMON
  • B、SMON
  • C、LGWR
  • D、CKRT

正确答案:A

第3题：

As shown in the diagram, in－memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()

A. CKPT

B. SMON

C. MMON

D. DBWR


参考答案：C

第4题：

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

正确答案:A,B,C

第5题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第6题：

Oracle Server由哪两个部分组成?()

A. INSTANCE和DATABASE

B. SGA和PGA

C. SGA和DATABASE

D. Server process和Background process

E. SGA和Background process


参考答案：A

第7题：

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

  • A、the alert log file
  • B、the core dump files
  • C、the change tracking file
  • D、the user session trace files
  • E、the database audit trail files
  • F、the background process trace files

正确答案:A,F

第8题：

WhichOraclebackgroundprocessfreesSGAresourcesthatwereallocatedtoauserprocessthatfailed?()

A.PMON

B.SMON

C.CKPT

D.LGWR

E.ARCn


参考答案：A

第9题：

Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）

  • A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
  • B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
  • C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
  • D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

正确答案:A

第10题：

Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）

  • A、PMON
  • B、SMON
  • C、CKPT
  • D、LGWR
  • E、ARCn

正确答案:A

更多相关问题
相关内容