网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT DICTIONARY 4 FREELISTS 5 5 NOLOGGING()
A. 1
B. 2
C. 3
D. 4
E. 5
F. 所有语句都会执行成功
参考答案
更多 “ 以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT DICTIONARY 4 FREELISTS 5 5 NOLOGGING() A. 1B. 2C. 3D. 4E. 5F. 所有语句都会执行成功 ” 相关考题
考题
You executed the following command:RMAN RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
考题
ToreferenceexistingASMfiles，youneedtouseafullyqualifiedASMfilename.YourdevelopmentdatabasehasadiskgroupnamedDG2A，thedatabasenameisDEV19，andtheASMfilethatyouwanttoreferenceisadatafilefortheUSERS02tablespace.WhichofthefollowingisavalidASMfilenameforthisASMfile？（）A.dev19/+DG2A/datafile/users02.701.2B.+DG2A/dev19/datafile/users02.701.2C.+DG2A/dev19/users02/datafile.701.2D.+DG2A·701.2E.+DG2A/datafile/dev19.users.02.701.2
考题
ExaminethecommandsexecutedinaDBAsession：SQLCREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQLALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
考题
Youhavecreatedalocallymanagedtablespacebyissuingthefollowingcommand：CREATETABLESPACEdata1DATAFILE’data1_file1.dbf’SIZE10MAUTOEXTENDONMAXSIZEUNLIMITED；FortheDATA1tablespace，youhavesetthewarninglevelalertlimitto70percent.Inwhichsituationwillawarninglevelalertbegenerated？（）A.when700KBisusedB.when700KBisleftasfreespaceC.when7MBisusedD.when7MBisleftasfreespaceE.noalertwillbegeneratedbecauseanautoextensibledatafileisincludedinthetablespace
考题
YourdatabaseisinARCHIVELOGmode.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethedatabase.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：RMANRESTOREDATABASE；RMANRECOVERDATABASE；AftersuccessfullyexecutingtheseRMANcommands，youissuethefollowingstatementusingSQL*Plus：SQLALTERDATABASEOPEN；Youreceivethefollowingerrorswhenattemptingtoopenthedatabase：ORA-01157：cannotidentify/lockdatafile10seeDBWRtracefileORA-01110：datafile10：’D：\USERS.DBF’Whatisthecauseoftheseerrors？（）
考题
Youexecutedthefollowingcommand:RMANRECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()
A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.
考题
以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT LOCAL 4 FREELISTS 5 5 NOLOGGING()
A. 1B. 2C. 3D. 4E. 5F. 所有语句都会执行成功
考题
以下不能创建一个字典的语句是:
A.dict = {}B.dict = {(4,5,6):'dictionary'}C.dict= {4：6}D.dict = {[4,5,6]:'dictionary'}
考题
以下创建字典的语句中，会引发异常的是A．d = {}B．d = {(4,5,6):'dictionary'}C．d = {4:6}D．d = {[4,5,6]:'dictionary'}
热门标签
最新试卷