摘要：
You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be o 阅读全文
posted @ 2017-12-05 16:43
巴啦啦大魔王
阅读(87)
评论(0)
推荐(0)
摘要：
To make audit information more productive, the DBA executes the following command before starting an audit operation:SQL> ALTER SYSTEM SET AUDIT_TRAIL 阅读全文
posted @ 2017-12-05 16:39
巴啦啦大魔王
阅读(80)
评论(0)
推荐(0)
摘要：
You execute the following command to audit database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of 阅读全文
posted @ 2017-12-05 16:30
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the 阅读全文
posted @ 2017-12-05 15:51
巴啦啦大魔王
阅读(102)
评论(0)
推荐(0)
摘要：
A user, who is authenticated externally, logs in to a remote machine and connects to the databaseinstance. What action would you take to ensure that a 阅读全文
posted @ 2017-12-05 15:16
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
Some non-DBA users in your database have been granted ANY TABLE system privileges and theyare able to access data dictionary base tables. You decide t 阅读全文
posted @ 2017-12-05 15:12
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use th 阅读全文
posted @ 2017-12-05 15:04
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A.It is the time period after which the undo data b 阅读全文
posted @ 2017-12-05 14:58
巴啦啦大魔王
阅读(73)
评论(0)
推荐(0)
摘要：
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?A. When the data file of the undo tablespace is autoexten 阅读全文
posted @ 2017-12-05 14:48
巴啦啦大魔王
阅读(105)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users 阅读全文
posted @ 2017-12-05 14:41
巴啦啦大魔王
阅读(79)
评论(0)
推荐(0)
浙公网安备 33010602011771号