When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF、

试卷相关题目

• 1When an application using a temporary table terminates or disconnects from the databaseunexpectedly, what happens to the temporary table and any data stored in it、

  A.The data in the table is deleted and the table persists.

  B.The data in the table is deleted and the table is implicitly dropped.

  C.The temporary table is converted to a base table and the data is delete

  D.D. The temporary table is converted to a base table and the data is persistent.

  开始考试点击查看答案
• 2A table named STATES was created as follows:  CREATE TABLE states  (state_cd     CHAR(2) NOT NULL,   state_desc   CHAR(20)); CREATE UNIQUE INDEX indx1 ON states (state_cd); What will happen、

  A.An error will be returned and the operation will fail.

  B.A warning will be returned and the unique index INDX1 will become the index for the primary key.

  C.The primary key will be successfully added and the unique index INDX1 will be dropped and recreatedas the primary key index.

  D.The primary key will be successfully added, the unique index INDX1 will be dropped, and a new indexwill be created for the primary key.

  开始考试点击查看答案
• 3Which statement regarding triggers is true、

  A.Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

  B.Triggers cannot be modified, they must be dropped and recreated with new definitions.

  C.Adding a trigger to a table that already has rows in it will cause triggered actions to be fire

  D.D. Triggers can only be fired one time per statement irrespective of the number of rows affected.

  开始考试点击查看答案
• 4Which statement is true about an index that is used to support a UNIQUE constraint、

  A.It must not contain more than one column.

  B.It cannot be used in a referential constraint.

  C.It must be defined with the UNIQUE attribute.

  D.It must be defined as UNIQUE WHERE NOT NULL.

  开始考试点击查看答案
• 5Which privilege is required to invoke a user defined function、

  A.CALL

  B.USAGE

  C.EXECUTE

  D.REFERENCES

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

  A.A trigger is designed to return specific types of values and contains executable code.

  B.A trigger is designed to return specific types of values but contains no executable code.

  C.A trigger performs actions to capture details about an activity like a join operation against multiple tables.

  D.A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a tabl

  开始考试点击查看答案
• 7Which two statements are true about foreign key constraints、 (Choose two.)

  A.The foreign key constraint columns must be supported by an index.

  B.The foreign key constraint columns must be defined as NOT NULL.

  C.The number and data types of foreign key constraint columns must match the parent key.

  D.The columns of one foreign key constraint cannot be used in another foreign key constraint.

  E.To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.

  开始考试点击查看答案
• 8What 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.

  开始考试点击查看答案
• 9By 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

  开始考试点击查看答案
• 10Which 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.

  开始考试点击查看答案