单项选择题
A. creating a table in your schema and you exceed your allocated space quota on the tablespace
B. executing a long query that involves a sort operation and the statement runs out of temporary space
C. loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D. creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
多项选择题 You have the following online redo log configuration: Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()
单项选择题 YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?()
单项选择题 You issued the following statement to monitor the usage of the index: SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE; Which view will you query to ensure that the index is being monitored?()