black

1z0-043

登录

多项选择题

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes?()

A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS

相关考题

单项选择题 You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’);  This command errorsout displaying the following message:  ERROR at line 1:  ORA-01031: insufficient privileges  ORA-06512: at "SYS.DBMS_RMIN", line 115  ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1  What action would you take to overcome this error?()

多项选择题 WhichtwostatementsarecorrectregardingtheOracleFlashbackDropfeature?()

单项选择题 Youlostatemporaryfilethatbelongstothedefaulttemporarytablespaceinyourdatabase.Fromtheoptionsprovided,whichapproachwouldyoutaketosolvetheproblem?()

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号:湘ICP备14005140号-5

经营许可证号:湘B2-20140064