单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space

题目

单选题

What is the maximum size that can be specified when creating an XML column in a DB2 table?（）

No size is specified

The buffer pool size

The page size for the table space

The extent size for the table space

更多“单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space”相关问题

第1题

Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A、The minimum memory size for the database buffer cache is set to 100 mb.B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

点击查看答案
第2题

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）A、ALTER TABLE commercials MODIFY (description CHAR2(2000));B、ALTER TABLE commercials CHANGE (description CHAR2(2000));C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));E、You cannot increase the size of a column if the table has rows.

点击查看答案
第3题

You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A、DROP TABLE B、ALTER TABLE C、RESIZE D、COALESCE

点击查看答案
第4题

You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）A、 column sizesB、 column data typesC、 PCTFREED、 projected number of rowE、 PCTUSED

点击查看答案
第5题

When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A、Size of typical transactions B、Concurrent transactions C、Size of rows in table most frequently changed D、Number of anticipated disk sorts

点击查看答案
第6题

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter

点击查看答案
第7题

Consider the following statement： SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2> ownname => ‘OE’， - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， - 4> method opt => ‘for all columns size AUTO’）； What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

点击查看答案

单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space

题目

更多“单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容