分类：
2010-08-27 09:43:34
最新的考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的试题，全部附有正确答案。在考试认证厂商对考题做出变化时，题库都将在第一时间内得到更新。最终保证覆盖率在96%以上，确保考生能一次通过考试！
部分题库分享如下：
1.Who is allowed to add columns to a table? (Select two.)
A. the SUPER.SUPER
B. the owner of the table
C. the owner ¯ s gr op super
D. the owner of the schema
E. users that have been granted access
Answer: A, D
2.Using the following DDL command: CREATE TABLE new_table LIKE old_table
What can be specified for new_table? (Select two.)
A. Format 1 or Format 2
B. indexes from old_table
C. headings from old_table
D. organization and primary key
E. extent sizes and maximum extents
Answer: C, E
3.A column definition includes DOB DATE HEADING ®Bi rt h Dat ¡¯. What is t he headi ng out put f SELECT MAX(DOB)?
A. MAX(dob)
B. Birth Date
C. EXPR(dob)
D. EXPR
Answer: D
4.Which statements are true about AUDITCOMPRESS? (Select two.)
A. The audit contains only altered columns.
B. It has no effect on transaction throughput. C. It is part of the system¯ s T MF confi gur ati on
D. It contributes to higher transaction throughput.
E. Compression is performed by the audit disk process.
Answer: A, D
5.When a table has the primary key defined as DROPPABLE, which statements are true? (Select two.)
A. A SYSKEY is generated for the table. B. The STORE BY clause must be used.
C. A DROPPABLE key can only be ascending.
D. The primary key is used as the clustering key.
E. A seperate unique index is build for the primary key.
Answer: A, E
6.Which command reports the average free space in data blocks?
A. FUP INFO =table, slack
B. FUP INFO =table, stat, analyze
C. FUP INFO table mucatalog.myschema.mytable stat
D. FUP INFO table mucatalog.myschema.mytable detail
Answer: C
7.In SQL/MX syntax, for which database element is an explicit assigned character set supported?
A. row
B. table
C. column
D. constraint
Answer: C
8.How do you access the current data on the SQL/MP view $data.mycat.myview from mxci? (Select two.)
A. SELECT * FROM $data.mycat.myview;
B. CREATE VIEW cat.sch.myview AS SELECT ordernum, order_qty FROM $data.mycat.myview;
SELECT*FROM cat.sch.myview;
C. CREATE SQLMP ALIAS cat.sch.myview $data.mycat.myview; SELECT * FROM cat.sch.myview
D. CREATE TABLE cat.sch.myview LIKE &data.mycat.myview; INSERT INTO cat.sch.myview SELECT * FROM $data.mycat.myview; SELECT * FROM cat.sch.myview;
Answer: A, C
9.Which statements are true about the location of the system catalog tables of the system \MYSYS? (Select two.)
A. The subvolume of the catalog tables is MYSYS.
B. The subvolume of the catalog tables is always ZSD0.
C. The volume of the catalog tables is always $SYSTEM.
D. The subvolume of the catalog tables is always ZSQLMX.
E. The volume of the catalog tables can be found in $SYSTEM.ZSQLMX.MXANCHOR.
Answer: B, E
10.What is the correct definition of a column?
A. C1 VARCHAR (100) DEFAULT ®HAMBUR
B. C1 VARCHAR (100) NULL DEFAULT NULL
C. C1 VARCHAR (100) DEFAULT ° SANTA CLAR
D. C1 VARCHAR (100) NULL DEFAULT ®HAMBUR
Answer: A
以上只是题库的部分考题，如需下载更多的题库，可登陆！
