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

In the instance of the PROD database， the checkpoint （CKPT） 

题目
单选题
In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）
A

The modified blocks would be written to the data files.

B

The modified blocks would be written to the temp files.

C

The modified blocks would be written to the control file.

D

The modified blocks would be written to the redo log files.

E

The modified blocks would be written to the archived redo log files.

F

The modified blocks would be retained in the database buffer cache.

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

第1题：

ViewtheExhibitandidentifythecomponentmarkedwithaquestionmark.()

A.Checkpoint（CKPT）

B.ProcessMonitor（PMON）

C.ArchiverProcesses（ARCn）

D.RecovererProcess（RECO）

E.MemoryManagerprocess（MMAN）


参考答案：A

第2题：

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

  • A、On startup， SMON coordinates instance recovery.
  • B、On startup， CKPT coordinates instance recovery.
  • C、On startup， use RMAN to perform instance recovery.
  • D、Uncommitted changes will be rolled back after the database is opened.
  • E、On startup， perform media recovery and then instance recovery.
  • F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

正确答案:A,D

第3题：

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 process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)


参考答案：B

第4题：

What two are the prerequisites for enabling Flashback Database？（） 

  • A、 The database must be in ARCHIVELOG mode
  • B、 The database must be in MOUNT EXCLUSIVE mode
  • C、 The database must be opened in RESTRICTED mode
  • D、 The database instance must be started in the NOMOUNT state
  • E、 The database instance must have the keep buffer pool defined

正确答案:A,B

第5题：

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

  • A、The instance would hang.
  • B、The instance needs to be shut down.
  • C、The instance would be in the open state.
  • D、The instance would abort in such cases.
  • E、The instance would be in the open and invalid state.
  • F、The instance would in the open state， but all the background processes will be restarted.

正确答案:D

第6题：

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， 5
  • B、System Monitor （SMON）： 1， 6
  • C、Process Monitor （PMON）： 4， 6， 7
  • D、Database Writer （DBWR）： 1， 3， 4

正确答案:B

第7题：

Which  statements are true about checkpointing（）

  • A、The checkpoint frequency decreases with the smaller redo log file size.
  • B、It ensures that all committed data is written to the data files during normal shutdown.
  • C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
  • D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files

正确答案:B,C

第8题：

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.


参考答案：A

第9题：

What purpose would you achieve by enabling the block change tracking feature？（）

  • A、 Eliminate the necessity for backups.
  • B、 Perform optimized image copy backups.
  • C、 Perform optimized incremental backups.
  • D、 Enable checkpoint （CKPT） to perform checkpointing at every block change.
  • E、 Enable database writer （DBWn） to write changed blocks to data files faster.

正确答案:C

第10题：

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，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

正确答案:C

更多相关问题
相关内容