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

相似题目

• Which statement is true about Oracle Net Listener?（）

  A . It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections. B . A single listener can service only one database instance and multiple remote client connections. C . Service registration with the listener is performed by the process monitor (PMON) process of each database instance. D . The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

  查看最佳答案

• Which background process coordinates the rebalance activity for disk groups？（）

  A .  ORBn B .  OSMB C .  RBAL D .  ASM

  查看最佳答案

• Which statement is true about the Manageability Monitor （MMON） background process（）

  A . It transfers statistics from memory to disk at regular intervals. B . It coordinates the rebalance activity for disk groups when ASM is used. C . It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance. D . It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

  查看最佳答案

• Which four are valid Oracle constraint types? （）

  A . CASCADE B . UNIQUE C . NONUNIQUE D . CHECK E . PRIMARY KEY F . CONSTANT G . NOT NULL

  查看最佳答案

• Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）

  A .  If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local & global transactions B .  Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMS C .  Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic Server D .  If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactio

  查看最佳答案

• Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）

  A .  ASMB B .  PMON C .  RBAL D .  SMON

  查看最佳答案

• ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）

  A . CKPT DBWn LGWR PMON SMON B . ARCn CKPT DBWn LGWR SMON C . CJQ0 CKPT DBWn LGWR SMON D . DBWn LGWR PMON RECO SMON E . CKPT DBWn LMON PMON SMON

  查看最佳答案

• Which two statements are true about Oracle ActiveCache ？（）

  A .  it supports very large data-sets such as the result-sets from large search queries to be held in memory B .  it provides a set of management tools that enables automation of configuration C .  it provides enhanced visibility across the entire application infrastructure D .  it significantly increases the performance of Web-based applications with no code change

  查看最佳答案

• Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

  A .  DBWn B .  RECO C .  RVWR D .  LGWR

  查看最佳答案

• Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）

  A .  It creates jobs without considering the priorities associated with them. B .  It translates tasks into jobs for execution by the scheduler. C .  It determines the list of jobs that must be created for each maintenance window. D .  It is spawned by the MMON background process at the start of the maintenance window. E .  It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

  查看最佳答案

• 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

  查看最佳答案

• Which two statements about the background process of thedatabase writerare true（） 

  A . It is possible to have multiple database writers in an Oracle instance. B . It writes dirty buffers， if any， to data files whenever a checkpoint occurs. C . It writes dirty buffers， if any， to data files whenever a transaction commits. D . It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.

  查看最佳答案

• 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

  查看最佳答案

• Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）

  A . CKPT B . SMON C . LGWR D . DBWn E . ARC

  查看最佳答案

• Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ？（）

  A .  Oracle WebLogic Server B .  Oracle Coherence C .  Oracle Database D .  Oracle Real Time Operations Control

  查看最佳答案

• Which background process reads the redo log buffer and writes it to a file？（）

  A . ARCn B . DBWn C . CKPT D . LGWR E . PMON F . SMON

  查看最佳答案

• Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）

  A . ASMB B . PMON C . RBAL D . SMON

  查看最佳答案

• Which two statements about the background process of the database writer are true（）

  A . It is possible to have multiple database writers in an Oracle instance. B . It writes dirty buffers， if any， to data files whenever a checkpoint occurs. C . It writes dirty buffers， if any， to data files whenever a transaction commits. D . It writes dirty buffers， if any， to data files before the log writer （LGWR） write

  查看最佳答案

• You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

  A .  RBAL B .  CKPT C .  SMON D .  PMON E .  MMON F .  CTWR G .  DBWR

  查看最佳答案

• 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 file

  查看最佳答案

• Which pattern of comparison do you find in the following outlines? Person A 1) family background 2) educational background 3) working experience Person B 1) family background 2) educational background 3) working experience

  查看最佳答案

• Which of the following is NOT true according the related background in A Lesson in Living?

  查看最佳答案

• Which pattern of comparison do you find in the following outlines?Person A1) family background2) educational background3) working experiencePerson B1) family background2) educational background3) working experience

  查看最佳答案

• Which of the following best describes the effect of Irving ‘sPresbyterian background on his life？ 查看材料

  A.It fostered his love for the theater. B.It developed his skill in business. C.It prompted his interest in law. D.It had almost no effect on his life.

  查看最佳答案