black

1Z0-052

单项选择题

Given below is a list of scenarios： 
1）A user terminates his session abnormally. 
2）The connection between the server and the client application terminates because of a network failure. 
3）A schema is accidentally dropped. 
4）The tablespace is accidentally dropped from the database. 
5）The hard disk gets corrupted and the data files in the disk are lost. 
6）The database instance abnormally shuts down because of power failure. 
Which scenarios require DBA intervention to perform recovery（）

A.4 and 5
B.1，3，and 6
C.4，5，and 6
D.3，4，and 5
E.1，2，and 6

相关考题

多项选择题 InwhichofthescenarioswilltheDBAperformrecovery（）

单项选择题 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？ （）

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号：湘ICP备2020024380号-3