网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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)
考题
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.
考题
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.
考题
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
考题
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.
考题
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
考题
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.
考题
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.
考题
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 onlyB、All sessions of the HR user and the SYS userC、The session of the HR user that executed the commandsD、All the sessions for which the database users have access privilege to the PERSONS table
考题
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)
考题
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 PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer （OUI）E、Database Configuration Assistant （DBCA）
考题
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，5B、System Monitor Process （SMON）：1，4，5C、Process Monitor Process （PMON）：4，5，6D、Database Writer Process （DBWn）：1，3，4
考题
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.
考题
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.
考题
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
考题
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， 5B、System Monitor Process （SMON）： 1， 4， 5C、Process Monitor Process （PMON）： 4， 5， 6D、Database Writer Process （DBWn）： 1， 3， 4
考题
单选题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.
考题
单选题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.
考题
单选题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）
考题
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
单选题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 onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
考题
单选题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)
考题
多选题Which statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
考题
单选题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
考题
单选题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.
考题
单选题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）
考题
单选题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 forwardB
Uses Flashback Log for recoveryC
Uses online redo logs to roll backD
Uses undo data to roll back the transactionE
Uses Recovery Manager （RMAN） to roll backF
Uses the System Monitor （SMON） background process to perform instance recovery
考题
单选题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，5B
System Monitor Process （SMON）：1，4，5C
Process Monitor Process （PMON）：4，5，6D
Database Writer Process （DBWn）：1，3，4
热门标签
最新试卷
