专业技术初级资格程序员基础知识DB2

试卷预览

• 111A table named DEPARTMENT contains the following data:  DEPTNO     DEPTNAME          MGRNO      ADMRDEPT -----      --------          -----      -------- A01        PLANNING          000020     A00 B02        BRANCH OFFICE 1   -          E01 C22        BRANCH OFFICE 2   -          E01 D22        BRANCH OFFICE 3   -          E01 E22        BRANCH OFFICE 4   -          E01 If a user attempts to execute the following statement UPDATE employee SET workdept=   (SELECT deptno FROM department WHERE admrdept LIKE 'E%') WHERE workdept IS NULL; What will happen、

  A.The statement will fail because a subquery cannot be used in an UPDATE statement.

  B.The statement will fail because the result set produced by the subquery will contain more than one row.

  C.The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

  D.The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

  开始考试练习点击查看答案
• 112Which statement about UPDATE processing is FALSE、

  A.The UPDATE statement logs the before and after value of every column it modifies.

  B.A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

  C.When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modifie

  D.D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

  开始考试练习点击查看答案
• 113Given the following statements:  CREATE TABLE employee(empid INTEGER,info XML); INSERT INTO employee VALUES(1, '<employeesinfo>    <name>Joe Smith</name>    <department name="DB2">     <team>Development</team>    </department>  </employeeinfo>'); If the following XQuery statement is executed:  XQUERY  for $info in deb2-fn:xmlcolumn('EMPLOYEE.INFO')/employeeinfo  return $info/name What will be the result、

  A.Joe Smith

  B.Joe Smith

  C.Joe Smith>DB2

  D.Joe Smith

  开始考试练习点击查看答案
• 114A 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(*);

  开始考试练习点击查看答案
• 115When 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.

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

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

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

  开始考试练习点击查看答案
• 119Which statement regarding referential integrity constraints is true、

  A.Multiple primary keys can be defined for a table.

  B.A foreign key can reference multiple primary keys.

  C.A primary key can be referenced by only one foreign key.

  D.Primary keys and foreign keys are used to define relationships.

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

  开始考试练习点击查看答案