DB2

38 Minutes

19 Questions

This test is designed to assess a candidate's knowledge of the basics of technology and DB2. It will cover topics such as database design, SQL commands, data manipulation, and other related topics. The test will also include questions on the fundamentals of DB2, including installation, configuration, and administration. The goal is to evaluate the candidate's ability to understand and apply the concepts of technology and DB2 in a practical setting.

Example Question:

Multiple-Choice

In the below listed queries, the appropriate Indexes exist to support the tables created with the previous CREATE TABLE
Which of the following operations can cause the enforcement of a constraint defined on PAYROLL?
CREATE TABLE EMPLOYEE (EMPID INT NOT NULL PRIMARY KEY, EMP_FNAME CHAR(30), EMP_LNAME CHAR(30))
CREATE TABLE PAYROLL (EMPID INTEGER, WEEK_NUM INTEGER, PAYCHECK DECIMAL(6,2),
CONSTRAINT FKCONST FOREIGN KEY(EMPI REFERENCES EMPLOYEE (EMPI ON DELETE SET NULL);