单选题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. Wh

题目
单选题
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.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)

2.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.

3. 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

4.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.

更多“单选题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. Wh”相关问题

  • 第1题：

    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

  • 第2题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying the username and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

    正确答案:C

  • 第3题：

    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）

    • A、All sessions of the HR user only
    • B、All sessions of the HR user and the SYS user
    • C、The session of the HR user that executed the commands
    • D、All the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第4题：

    A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

    • A、Data Pump
    • B、Oracle Net Manager
    • C、Oracle Enterprise Manager
    • D、Oracle Universal Installer （OUI）
    • E、Database Configuration Assistant （DBCA）

    正确答案:B,C

  • 第5题：

    Which two 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 online redo log files.

    正确答案:B,C

  • 第6题：

    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） writes

    正确答案:A,B

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    View the Exhibit and identify the component marked with a question mark. （）
    A

    Checkpoint （CKPT）

    B

    Process Monitor （PMON）

    C

    Archiver Processes （ARCn）

    D

    Recoverer Process （RECO）

    E

    Memory Manager process （MMAN）


    正确答案： C
    解析： 检查点‖是一种数据结构，用于定义数据库的重做线程中的系统更改号(SCN)。 检查点被记录在控制文件和每个数据文件头中。它们是恢复操作的关键元素。 出现检查点时，Oracle DB 必须更新所有数据文件的头，以记录该检查点的详细信息。这是由CKPT进程完成的。CKPT 进程不会将块写入磁盘；该工作都是由DBWn执行。文件头中记录的SCN 可保证将该SCN 之前对数据库块进行的所有更改写入到磁盘中。Oracle Enterprise Manager 中的SYSTEM_STATISTICS监视器将显示统计信息DBWR 检查点，由其指示已完成的检查点请求的数目。

  • 第9题：

    单选题
    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： C,B
    解析： 暂无解析

  • 第11题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying the username and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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？（）
    A

    Uses undo data for roll forward

    B

    Uses Flashback Log for recovery

    C

    Uses online redo logs to roll back

    D

    Uses undo data to roll back the transaction

    E

    Uses Recovery Manager （RMAN） to roll back

    F

    Uses the System Monitor （SMON） background process to perform instance recovery


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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.

    正确答案:A

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

    正确答案:C

  • 第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（）

    • 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

  • 第19题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    多选题
    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） writes


    正确答案： A,D
    解析： 暂无解析

  • 第21题：

    单选题
    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)


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： D
    解析： 系统监视器进程(SMON) 在实例启动时执行恢复（如果需要）。SMON 还负责清除不再使用的临时段。如果在实例恢复过程中由于文件读取或脱机错误跳过任何已终止的事务处理，则SMON 将在表空间或文件重新联机时恢复这些事务处理。SMON 定期检查以查看是否需要该进程。其它进程在检测到需要SMON 时也可以调用它。

  • 第23题：

    单选题
    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）


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： D
    解析： 进程监视器进程(PMON) 在用户进程失败时执行进程恢复。PMON 负责清除数据库缓冲区高速缓存以及释放该用户进程使用的资源。例如，它重置活动事务处理表的状态，释放锁，并且从活动进程列表中删除该进程ID。PMON定期检查分派程序和服务器进程的状态，并重新启动任何已停止运行（但并非Oracle DB 故意终止）的分派程序和服务器进程。PMON 还将有关实例和分派程序进程的信息注册到网络监听程序。与SMON 一样，PMON 定期检查以查看是否需要执行；如果其它进程检测到需要该进程，也可以调用它。

相关内容