A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
B. Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command
C. Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command
D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
第1题
A.backupset
B.imagecopy
C.incrementalbackup
D.Nonetheuserreceivesanerrorindicatingthatthebackuptypemustbespecified.
第2题
A.passwordfile
B.onlineredologfiles
C.thecurrentcontrolfile
D.archivedredologfiles
E.thecurrentserverparameterfile
F.allthedatafilesbelongingtotheUSERStablespace
G.datafilesbelongingtotheUSERStablespaceandallthedefaulttablespaces
第3题
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
第4题
RecoveryManager(RMAN)toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers?()
A.backupofofflinetablespaces
B.backupofreadonlytablespaces
C.backupofsystemcriticaltablespaces
D.backupofonline,locallymanagedtablespaces
E.backupofread/writedictionarymanagedtablespaces
第5题
YouhavelostallyourSYSTEMtablespacedatafiles(system_01.dbfandsystem_02.dbf)ndthedatabasehascrashed.
Whatwouldbetheappropriateorderofoperationstocorrectthesituation?()
a.Mountthedatabasewiththestartupmountcommand.
b.TaketheSYSTEMdatafileofflinewiththealterdatabasecommand.
c.RestoretheSYSTEM_01.dbfdatafilefrombackupmediawiththerequiredarchivedredologs.
d.RestoreallSYSTEMtablespace-relateddatafilesfrombackupmedia.
e.IssuetherecovertablespaceSYSTEMcommand.
f.IssuetherecoverdatafileSYSTEM_01.dbfcommand.
g.Openthedatabasewiththealterdatabaseopencommand.
h.Openthedatabasewiththealterdatabaseopenresetlogscommand.
第6题
A.datafile
B.passwordfile
C.archivelogfile
D.temporaryfile
E.onlineredologfile
F.thecurrentcontrolfile
G.thetnsnames.orafile
H.currentserverparameterfile
第7题
A.True
B.Not true
C.An exception is thrown at runtime.
D.Compilation fails because of an error at line 12.
E.Compilation fails because of an error at line 19.
第8题
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQLs for tuning
第9题
shasbeenlost.Whatstepswouldyoufollowtorecoverthatcontrolfile?()
a.Shutdownthedatabase.
b.Restoreacontrol-filecopyfrombackupmedia.
c.Usethecreatecontrolfilecommandtocreateanewcontrolfile.
d.Copythebackupcontrolfileintoplace.
e.Createanewcopyofthecontrolfilefromoneofthesurvivingcontrolfiles.
f.Recoverthedatabaseusingtherecoverdatabaseusingbackupcontrolfilecommand.
g.Startupthedatabase.
第10题
A.Databasedatafiles
B.Controlfiles
C.Archivedredologs
D.Onlineredologs
E.Flashbacklogs
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!