Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedure
B. Develop and debug a user-defined data type
C. Develop and debug a user-defined function
D. Develop and run XML queries
A declared temporary table is used for which of the following purposes?
A. Backup purposes
B. Storing intermediate results
C. Staging area for load operations
D. Sharing result data sets between applications
An Alias can be an alternate name for which DB2 object?
A. Sequence
B. Trigger
C. Schema
D. View
Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add data to table
CURRENT_EMPLOYEES?
A. INSERT INTOcurrent_employees (empid) VALUES (10)
B. INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)
C. INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20
D. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
Which two of the following are optional and do not have to be specified when creating a table?
A. Table name
B. Column name
C. Default constraint
D. Column data type
E. NOT NULL constraint
Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?
A. Index
B. Check constraint
C. Referential constraint
D. Default constraint
Given the following statements:
CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;
Which of the following INSERT statements will execute successfully?
A. INSERT INTO view1 VALUES (50,abc)
B. INSERT INTO view1VALUES(100, abc)
C. INSERT INTO view1VALUES(50, 'abc')
D. INSERT INTO view1VALUES(100, 'abc')
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 table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which of the following is the best isolation level to use for this application?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?
A. CREATE TABLEemp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL,
edlevel CHAR(1),
PRIMARY KEY emp_pk (empno),
FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck
VALUES (edlevel IN ('C','H','N')),
);
B. CREATE TABLEemp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno),
CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );
C. CREATE TABLEemp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL,
edlevel CHAR(1) CHECK IN ('C','H','N')),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept)
);
D. CREATE TABLEemp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno),
CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );
