摘要：
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 r 阅读全文
摘要：
Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes 阅读全文
摘要：
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USE 阅读全文
摘要：
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled 阅读全文
摘要：
You are using the following command to clear the log file group:ALTER DATABASE CLEAR LOGFILE GROUP 2;In which case would the command be successful?A. 阅读全文
摘要：
You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, a 阅读全文
摘要：
QUESTION 238 In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDE 阅读全文
摘要：
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are w 阅读全文
摘要：
The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. The 阅读全文
摘要：
You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the follo 阅读全文