By default, where is the data stored for a column defined with an XML data type、

试卷相关题目

• 1Which statement is true regarding constraints、

  A.A table can only have one unique key constraint.

  B.A table can have multiple primary key constraints.

  C.Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforce

  D.D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

  开始考试点击查看答案
• 2Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value、

  A.Unique constraint

  B.Primary key constraint

  C.Informational constraint

  D.Column default constraint

  开始考试点击查看答案
• 3Which is NOT a valid reason for creating an index、

  A.To allow queries to run more efficiently.

  B.To enforce constraints such as uniqueness on index keys.

  C.To order the columns of a table in ascending or descending sequence according to values in a row.

  D.To order the rows of a table in ascending or descending sequence according to the values in a column.

  开始考试点击查看答案
• 4By default, a column defined as a TIMESTAMP includes which attributes、

  A.No fractional digits or time zone.

  B.6 fractional digits and no time zone.

  C.12 fractional digits plus a time zone.

  D.12 fractional digits and no time zon

  开始考试点击查看答案
• 5What is the primary purpose of a view、

  A.To enable uniqueness.

  B.To ensure data clustering.

  C.To combine data from multiple tables.

  D.To optimize queries ran against multiple tables.

  开始考试点击查看答案
• 6Which statement about BEFORE triggers is FALSE、

  A.A BEFORE trigger can be used to perform validation of input data.

  B.A BEFORE trigger can be used to automatically generate values for newly inserted rows.

  C.A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

  D.A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

  开始考试点击查看答案
• 7What is used in conjunction with a foreign key to define a relationship between two tables、

  A.Primary key

  B.Partitioning key

  C.Check constraint

  D.Unique constraint

  开始考试点击查看答案
• 8Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement、

  A.Change the data type of the sequence.

  B.Reset the sequence to its starting value.

  C.Establish new minimum or maximum values.

  D.Change the increment between future values.

  开始考试点击查看答案
• 9Given the following statement:GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;Which statement is correct、

  A.USER1 can only remove the SALES table.

  B.USER1 can only remove records from the SALES table.

  C.USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.

  D.USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

  开始考试点击查看答案
• 10Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to、

  A.Authentication

  B.Authorities and privileges

  C.Label-based access control

  D.Row and column access control

  开始考试点击查看答案