Which statement about the enabling of table compression in Oracle Database 11g is true?()A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct

题目
Which statement about the enabling of table compression in Oracle Database 11g is true?()

A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.

B. Compression can be enabled only at the table level for both direct loads and conventional DML.

C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

相似考题

1.You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.

2.YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSQL1andtheotherisSQL2.YouhavepermissionstocreateastoredprocedureonSQL1tosupportyourapplication.However，onSQL2youonlyhavepermissionstoselectdata.YouwritethestoredprocedureonSQL1.ThestoredprocedureaccessesSQL2byusingtheOPENQUERYTransact-SQLstatement.However,thequeryfailswhenexecuted.Youneedtotroubleshootthecauseoftheerror.Whatshouldyoudo？（）A.Jointhetwoserversbyusingthefour-partsyntaxofserver.database.schema.table.B.ReferenceSQL2byusinganalias.C.AddSQL2asaremoteservertoSQL1.D.AddSQL2asalinkedservertoSQL1.

3.Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()A.run{openscriptbackup_database；runscriptbackup_database}B.run{engagescriptbackup_database；}C.run{runscriptbackup_database；}D.Run{executescriptbackup_database；}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.

4.The VoIP gateway can perform the digitization, () and encapsulation required, and it controls the setup of VoIP calls between the calling device and the called deviceA.amplificationB.depressionC.radiationD.compression

更多“Which statement about the enabling of table compression in Oracle Database 11g is true?() ”相关问题

  • 第1题：

    Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQL>startupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）

    A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.

    B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.

    C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.

    D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.

    E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.


    参考答案：C

  • 第2题：

    ORACLE初始化参数文件的默认路径是:()

    A.对于UNIX，在$ORACLE_HOME/dbs

    B.对于UNIX，在$ORACLE_HOME/dbs/admin

    C.对于Linux，在%ORACLE_HOME%\database

    D.对于Windows，在%ORACLE_HOME%\dbs

    E.对于Windows，在%ORACLE_HOME%\database\admin


    参考答案：A

  • 第3题：

    如果想要配置Oracle以使用校验和来验证数据块,将初始化参数()设置为TRUE。

    A.DB_BLOCK

    B.DB_EXTENT_CHECKSUM

    C.DB_BLOCK_CHECKSUM

    D.DB_SEQENT_CHECKSUM


    参考答案：C

  • 第4题：

    Oracle中如何设置audittrail审计，正确的说法是：（）

    A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”

    B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计

    C、Oracle不支持对audittrail的审计

    D、在设置audittrail审计前，要保证已经打开Oracle的审计机制


    答案：ABD

  • 第5题：

    当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。

    A.DB_FILES

    B.DB_DATAFILES

    C.DATABASE_FILES

    D.LOG_FILES


    参考答案：A

  • 第6题：

    Niagara Falls is a great tourist attraction，drawing millions of visitors every year.

    A:holding
    B:attracting
    C:making
    D:enabling

    答案：B
    解析：
    本句话的意思是：“尼亚加拉大瀑布是著名的旅游胜地，每年吸引上百万的游客。”draw和 attract意思相同，表示吸引、诱惑，例如：Summer attracts visitors to the countryside．在夏季，乡村游很吸引游客。hold：保留、抓住，例如：Hold to my hand while we cross the street．我们过马路时，你要抓住我的手。make：使得，例如：More practice will make you speak with greater fluency．多练习就可以使你的口语更流利。enable：使能够，例如：The hot sunenables the grapes to reach optimum ripeness．炙热的阳光使葡萄能够达到最佳的成熟状态。

相关内容