找考题网-背景图
多项选择题

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）

A.SYNC or ASYNC to identify the network transmission mode. 
B.LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. 
C.AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. 
D.PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

<上一题 目录 下一题>
热门试题

单项选择题Whichisarestrictiononalistpartitionedtable？（）

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？（）

A.Rebuild the index using the online option. 
B.Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
C.Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
D.Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

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

A.0
B.1
C.3
D.4

单项选择题YouarereadytoimplementRMANinthebackupandrecoverstrategyforyourcompany.WhichsystemprivilegemusttheRMANuserhavetobeabletoconnectandexecuteRMANcommandsonatargetdatabase？（）

A.SYSDBA
B.SYSOPER
C.No system privileges are required for the RMAN user.
D.Only SYS user can connect and execute RMAN commands on a target database.

单项选择题Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication？（）

A.RECOVERY_PARALLELISM
B.FAST_START_MTTR_TARGET
C.LOG_CHECKPOINT_INTERVAL
D.FAST_START_PARALLEL_ROLLBACK