多项选择题
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（）
单项选择题 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？ （）
单项选择题 View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings，respectively. Why are advisors not available for the shared pool and the buffer cache()