摘要：
Oracle 删除数据文件 阅读全文
摘要：
Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of differ 阅读全文
摘要：
Which three statements are true about the stages of database startup? (Choose three.) A. Data files and redo log files can be renamed at the MOUNT sta 阅读全文
摘要：
Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of con 阅读全文
摘要：
You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct reg 阅读全文
摘要：
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on 阅读全文
摘要：
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this 阅读全文
摘要：
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 synch 阅读全文
摘要：
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 阅读全文
摘要：
In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. Y 阅读全文
摘要：
Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this 阅读全文