black

1z0-043

单项选择题

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

A. DROP TABLESPACE temp1；
B. DROP TABLESPACE temp1 INCLUDING CONTENTS；
C. DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
D. DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

相关考题

单项选择题 YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasthreeonlineredologgroups，andeachgroupcontainsthreeonlineredologmembers.Theonlineredologmembersarestoredacrossthreeharddisks，E，F，andG，respectively.HarddiskGcrashedwhiletheLGWRbackgroundprocesswaswritingredoinformationtotheonlineredologfiles.Whateffectwillthiscrashhaveonthedatabase？（）

单项选择题 Atdatabasestartup，youdiscoverthatoneofthediskscontaininganindextablespacehasbeenlostduetoamediafailure.Abackupofthelostindextablespaceisnotavailable.Youhaveallthenecessaryscriptstorecreatetheindexes.Youneedtore-createtheindexesinanewindextablespace.Whichactionmustyouperformbeforere-creatingtheindexes？（）

单项选择题 Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）

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

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064