IBM(000-730)章節(jié)練習(xí)(2019.01.21)

來源：考試資料網(wǎng)

1 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?（）

點(diǎn)擊查看答案

2 A UDT is a data type which:（）

點(diǎn)擊查看答案

3 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?（）

點(diǎn)擊查看答案

4 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?（）

點(diǎn)擊查看答案

5 Which of the following is true of an index used to support a UNIQUE constraint?（）

點(diǎn)擊查看答案

6 Which of the following is a typical data warehouse query?（）

點(diǎn)擊查看答案

7 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（）

點(diǎn)擊查看答案

8 Which of the following are types of routine objects?（）

點(diǎn)擊查看答案

9 Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL
CLERK 3
If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）

點(diǎn)擊查看答案

10 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?（）

點(diǎn)擊查看答案