Which statement regarding referential integrity constraints is true、

试卷相关题目

• 1Which type of table is best suited for recording results from application data manipulation that is not required to be persistent、

  A.Base Table

  B.Temporal Table

  C.Transition Table

  D.Temporary Table

  开始考试点击查看答案
• 2Which statement about foreign keys is true、

  A.A table can have only one foreign key.

  B.Foreign keys can only be defined when a table is created.

  C.A foreign key can be defined on a column or a set of columns in a table.

  D.C. A foreign key can be defined on a column or a set of columns in a tabl

  E.D. Foreign keys are enforced only during the execution of INSERT statements.

  开始考试点击查看答案
• 3What is a function of a table check constraint、

  A.To provide a method of avoiding duplicate entries for a column.

  B.To provide a method of ensuring a column's values are within a specific range.

  C.To ensure that XML columns are properly populated in an associated XML table space.

  D.To enforce relationships between tables by checking the existence of rows in one table against another.

  开始考试点击查看答案
• 4When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF、

  A.The SYSIBM schema.

  B.The SYSFUN schema.

  C.A schema with the name of the UDF.

  D.A schema with the userid of the UDF definer.

  开始考试点击查看答案
• 5A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME.Which SQL statement will return the number of states in each region, ordered by number of states、

  A.SELECT state_cd, COUNT(*) FROM states ORDER BY COUNT(*);

  B.SELECT state_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY state_cd;

  C.SELECT region_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY COUNT(*);

  D.SELECT region_cd, COUNT(*) FROM states GROUP BY region_cd ORDER BY COUNT(*);

  开始考试点击查看答案
• 6Which database object provides an alternative way of describing data that exists in one or more base tables、

  A.Alias

  B.View

  C.Index

  D.Sequence

  开始考试点击查看答案
• 7The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of thefollowing、

  A.Define a view on one or more tables or views.

  B.Revalidate all invalid objects that are referenced on a view's fullselect.

  C.Ensure that any inserted or updated rows conform to the definition of the view.

  D.Define a view that only consists of columns that have check constraints defined.

  开始考试点击查看答案
• 8Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced、

  A.Check

  B.Unique

  C.Referential

  D.Informational

  开始考试点击查看答案
• 9Which event will NOT cause a trigger to be fired、

  A.Execution of an INSERT statement.

  B.Execution of LOAD REPLACE operation.

  C.Execution of an INSERT operation of a MERGE statement.

  D.Execution of an UPDATE operation of a MERGE statement.

  开始考试点击查看答案
• 10What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEXstatement、

  A.To override the limit on index key columns.

  B.To further enforce the uniqueness of index values.

  C.To combine two or more indexes to create a single unique index.

  D.To improve performance of some queries by allowing index-only access.

  开始考试点击查看答案