单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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.
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
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.
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.
Which statement is true about the forwarding table?（）A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination
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.
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 tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.
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.
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.
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
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.
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.
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.
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.
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
单选题Which statement is true about the forwarding table?（）AThe forwarding table is stored in the control plane only.BThe forwarding table is stored in the control plane and in the forwarding plane.CThe forwarding table contains both active and inactive routes.DThe forwarding table can contain only a single next hop per destination.
单选题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?（）AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.
单选题You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）AThe BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.BThe ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.CThe ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.DOnly the BZIP2 compression algorithm can be used to make compressed backups to disk.
单选题Which statement is true about the forwarding table?（）AThe forwarding table is stored in the control plane onlyBThe forwarding table is stored in the control plane and in the forewarding planeCThe forwarding table contains both active and inactive routesDThe forwarding table can contain only sigle next hop per destination
单选题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.
单选题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.
单选题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?（）AROW compression should be utilized for the EmployeeData table.BThe Profile column should be stored by utilizing filestream storage， and the NTFS file system Compression should be utilized.CPAGE LEVEL compression should be utilized for the EmployeeData table.DThe Profile column should be implemented as a CLR user-defined type.
单选题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.
单选题Which statement is true regarding synonyms?（）ASynonyms can be created only for a table BSynonyms are used to reference only those tables that are owned by another user CA public synonym and a private synonym can exist with the same name for the same table DThe DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
单选题Which statement about the enabling of table compression in Oracle Database 11g is true?（）ACompression can be enabled at the table, tablespace, or partition level for direct loads only.BCompression can be enabled only at the table level for both direct loads and conventional DML.CCompression can be enabled at the table, tablespace, or partition level for conventional DML only.DCompression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
单选题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？（）AYou should use row compression BYou should use page compression CYou should use backup compression DYou should use windows NTFS file system compression
单选题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.