IBM(000-730)章节练习(2019.01.21)

单项选择题
Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）
A.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
B.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))
C.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
D.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
单项选择题
A UDT is a data type which:（）
A.must contain unique values.
B.cannot be CAST to other data types.
C.is created using the CREATE DISTINCT command.
D.contains a value that was automatically calculated from values in other columns.
单项选择题
Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）
A.Applications A and B will cause a deadlock situation
B.Application B will read the previous version of the row
C.Application B will read the row and see uncommitted changes made by application A
D.Application B will be placed in a lock-wait state until application A releases its lock
单项选择题
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）
A.DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B.When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C.When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
D.When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
单项选择题
Which of the following is true of an index used to support a UNIQUE constraint?（）
A.It must have the UNIQUE attribute.
B.It cannot be created explicitly by the user.
C.It must have the UNIQUE and CLUSTER attributes.
D.It must have the UNIQUE WHERE NOT NULL attribute.
单项选择题
Which of the following is a typical data warehouse query?（）
A.What is this customers address?
B.Does this customer have any unpaid bills?
C.What is the balance in this customers account?
D.What are the total sales for each of the last 6 months?
单项选择题
How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）
A.CALL getratews11('USA','CANADA')
B.CALL expenses.getratews11('USA','CANADA')
C.SELECT getratews11('USA','CANADA') FROM expenses
D.SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
单项选择题
Which of the following are types of routine objects?（）
A.Package and function
B.Function and userexit
C.Procedure and package
D.Function and procedure
单项选择题
Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）
A.0
B.1
C.3
D.6
单项选择题
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
A.A check constraint on the EMPLOYEE table
B.A unique constraint on the EMPLOYEE table WORKDEPT column
C.A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D.A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table