多項選擇題

In which of the scenarios will the DBA perform recovery（）

A.The alert log file is corrupted.
B.A tablespace is accidentally dropped.
C.One of the redo log members is corrupted.
D.A database user terminates the session abnormally.
E.The hard disk on which the data file is stored is corrupted.

你可能感興趣的試題

單項選擇題

View the Exhibit and examine the parameters.

User A executes the following command to update the TRANS table： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；
Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table：
SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；
What would happen in this scenario（）

A.The ALTER TABLE command modifies the column successfully.
B.The DDL operation gets higher priority and transaction for user a is rolled back.
C.The ALTER TABLE command waits indefinitely until user a ends the transaction.
D.The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

單項選擇題

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？（）

A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

In which of the scenarios will the DBA perform recovery（）

你可能感興趣的試題

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance. What would be your next step to improve performance？ （）

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？（）