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

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

第3题：

第4题：

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

第5题：

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.

第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

第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

第8题：

第9题：

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.

第10题：

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)