以下创建表空间的语句会在执行哪一行时失败? 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. 所有语句都会执行成功

题目
以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT LOCAL 4 FREELISTS 5 5 NOLOGGING()

A. 1

B. 2

C. 3

D. 4

E. 5

F. 所有语句都会执行成功

相似考题

1.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

2.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

3.Youhavecreatedalocallymanagedtablespacebyissuingthefollowingcommand：CREATETABLESPACEdata1DATAFILE’data1_file1.dbf’SIZE10MAUTOEXTENDONMAXSIZEUNLIMITED；FortheDATA1tablespace，youhavesetthewarninglevelalertlimitto70percent.Inwhichsituationwillawarninglevelalertbegenerated？（）A.when700KBisusedB.when700KBisleftasfreespaceC.when7MBisusedD.when7MBisleftasfreespaceE.noalertwillbegeneratedbecauseanautoextensibledatafileisincludedinthetablespace

4.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

更多“以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT LOCAL 4 FREELISTS 5 5 NOLOGGING() ”相关问题

  • 第1题：

    YourdatabaseisinARCHIVELOGmode.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethe

    database.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：

    RMAN>RESTOREDATABASE；

    RMAN>RECOVERDATABASE；

    AftersuccessfullyexecutingtheseRMANcommands，youissuethefollowingstatementusingSQL*Plus：

    SQL>ALTERDATABASEOPEN；

    Youreceivethefollowingerrorswhenattemptingtoopenthedatabase：

    ORA-01157：cannotidentify/lockdatafile10seeDBWRtracefile

    ORA-01110：datafile10：’D：\USERS.DBF’

    Whatisthecauseoftheseerrors？（）


    参考答案：C

  • 第2题：

    以下创建表空间的语句会在执行哪一行时失败? 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. 所有语句都会执行成功


    参考答案C

  • 第3题：

    以下不能创建字典的Python语句是

    A．dict1={}

    B．dict2={2:6}

    C．dict3={[1,2,3]:"users"}

    D．dict4={(1,2,3):"users"}


    C

  • 第4题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／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.


    参考答案：C

  • 第5题：

    以下不能创建字典的 Python语句是（)

    A．dict1={}

    B．dict={2: 6)

    C．dict3={[1,2,3]:"users"}

    D．dict4={(1,2, 3): "users")


    C

相关内容