单选题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 direc

题目
单选题
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 issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()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.

2.Which two statements are true about InnoDB auto－increment locking?()A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock

3.Which statement is true about the forwarding table?（）A、The forwarding table is stored in the control plane only.B、The forwarding table is stored in the control plane and in the forwarding plane.C、The forwarding table contains both active and inactive routes.D、The forwarding table can contain only a single next hop per destination.

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

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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 direc”相关问题

  • 第1题：

    Which statement is true about the routing table?（）

    • A、The routing table exists in the control plane only.
    • B、The routing table exists in the control plane and in the forwarding plane.
    • C、The routing table contains both active and inactive routes.
    • D、The routing table is stored on compact flash.

    正确答案:A

  • 第2题：

    Which two statements regarding compressed backups in Recovery Manager （RMAN） are true？（）

    • A、 Backup compression is disabled by default.
    • B、 Backup compression can be used with both backup sets and image copies.
    • C、 Backup compression cannot be enabled using the CONFIGURE command.
    • D、 Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
    • E、 Backup compression applies to only backup sets.
    • F、 Backup compression applies to only image copies.

    正确答案:A,E

  • 第3题：

    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

    • A、 Drop the table.
    • B、 Partition the table.
    • C、 Truncate the table.
    • D、 Add a column to the table.
    • E、 Rename a column in the table.

    正确答案:D

  • 第4题：

    Which two statements are true about InnoDB auto-increment locking?（）

    • A、The auto-increment lock can be a table-level lock
    • B、InnoDB never uses table-level locks
    • C、Some settings for innodb_autoinc_lock_mode can help reduce locking
    • D、InnoDB always protects auto-increment updates with a table-level lock

    正确答案:A,C

  • 第5题：

    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.

    正确答案:D

  • 第6题：

    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）

    • A、Use NTFS file system compression on the volume.
    • B、Use row-level compression on the document table.
    • C、Use varbinary(MAX) data type with FILESTREAM storage.
    • D、Enable row-level compression on all columns that use the vardecimal() data type.

    正确答案:A,C

  • 第7题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only.

    B

    The forwarding table is stored in the control plane and in the forwarding plane.

    C

    The forwarding table contains both active and inactive routes.

    D

    The forwarding table can contain only a single next hop per destination.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）
    A

    The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.

    B

    The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.

    C

    The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.

    D

    Only the BZIP2 compression algorithm can be used to make compressed backups to disk.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security,troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A database is included by the instance, and a table named EmployeeData is contained by the database. There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column. The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column. Which action will you perform?（）
    A

    ROW compression should be utilized for the EmployeeData table.

    B

    The Profile column should be stored by utilizing filestream storage， and the NTFS file system Compression should be utilized.

    C

    PAGE LEVEL compression should be utilized for the EmployeeData table.

    D

    The Profile column should be implemented as a CLR user-defined type.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You want to use RMAN to create compressed backups.  Which statement is true about the compression algorithms that RMAN can use？（）
    A

     The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.

    B

     The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.

    C

     The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.

    D

     Only the BZIP2 compression algorithm can be used to make compressed backups to disk.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    Which statement is true about the forwarding table?（）

    • A、The forwarding table is stored in the control plane only
    • B、The forwarding table is stored in the control plane and in the forewarding plane
    • C、The forwarding table contains both active and inactive routes
    • D、The forwarding table can contain only sigle next hop per destination

    正确答案:B

  • 第14题：

    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

    • A、Drop the table.
    • B、Partition the table
    • C、Truncate the table.
    • D、Add a column to the table.
    • E、Rename a column in the table.

    正确答案:D

  • 第15题：

    You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）

    • A、The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
    • B、The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
    • C、The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
    • D、Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

    正确答案:A

  • 第16题：

    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）

    • A、It cannot be done in parallel.
    • B、It can be done at the table level or partition level.
    • C、It does not require additional storage because the operation is done online.
    • D、Local and global indexes are maintained automatically during the operation.

    正确答案:B

  • 第17题：

    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security,troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A database is included by the instance, and a table named EmployeeData is contained by the database. There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column. The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column. Which action will you perform?（）

    • A、ROW compression should be utilized for the EmployeeData table.
    • B、The Profile column should be stored by utilizing filestream storage， and the NTFS file system Compression should be utilized.
    • C、PAGE LEVEL compression should be utilized for the EmployeeData table.
    • D、The Profile column should be implemented as a CLR user-defined type.

    正确答案:B

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

    • A、You should use row compression 
    • B、You should use page compression 
    • C、You should use backup compression 
    • D、You should use windows NTFS file system compression

    正确答案:B

  • 第19题：

    单选题
    Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
    A

    Oracle Data Pump.

    B

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

    C

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

    D

    Online Table Redefinition.

    E

    Edition-Based Table Redefinition.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only

    B

    The forwarding table is stored in the control plane and in the forewarding plane

    C

    The forwarding table contains both active and inactive routes

    D

    The forwarding table can contain only sigle next hop per destination


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）
    A

     Drop the table.

    B

     Partition the table.

    C

     Truncate the table.

    D

     Add a column to the table.

    E

     Rename a column in the table.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）
    A

     It cannot be done in parallel.

    B

     It can be done at the table level or partition level.

    C

     It does not require additional storage because the operation is done online.

    D

     Local and global indexes are maintained automatically during the operation.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）
    A

    You should use row compression 

    B

    You should use page compression 

    C

    You should use backup compression 

    D

    You should use windows NTFS file system compression


    正确答案： B
    解析： 暂无解析

相关内容