单项选择题
A.You cannot create global range partitioned indexes on the table.
B.The optimizer will not execute partition wise joins on the table’s partitions.
C.You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL.
D.Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.
单项选择题 Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i?()
单项选择题 Examine this syntax which allocates channels during a parallel image copy: RMAN> CONFIGURE DEVICE TYPE disk parallelism 4: 2> COPY 3> datafile 1 TO ‘/BACKUP/datafile1.dbf’, 4> datafile 2 TO ‘/BACKUP/datafile2.dbf’, 5> datafile 3 TO ‘/BACKUP/datafile3.dbf; RMAN>COPY 2> datafile 4 TO ‘/BACKUP/datafile4.dbf’; How many channels are used?()
单项选择题 YouarereadytoimplementRMANinthebackupandrecoverstrategyforyourcompany.WhichsystemprivilegemusttheRMANuserhavetobeabletoconnectandexecuteRMANcommandsonatargetdatabase?()