Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a
given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the
same table?

Which of the following is a characteristic of a schema?

Which of the following database objects can be used to raise an error if a table is updated?

A view is created with the following statement:
CREATE VIEW v1
AS SELECT col1, col2, col3
FROM t1
WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?

Which of the following constraint types can be used to ensure the value of an INTEGER column
references only positive values?

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?

Which of the following CANNOT be used to restrict specific values from being inserted into a
column in a particular table?

Given the following table definition:
EMPLOYEES
———————-
EMPID INTEGER
NAME CHAR(20)
SALARY DECIMAL(10,2)
If the following SQL statement is executed:
CREATE UNIQUE INDEX empid_ui ON employees (empid)
Which two of the following statements are true?

If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY,
make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT,
model VARCHAR(25),
makeid SMALLINT,
CONSTRAINT const1 FOREIGN KEY (makeid)
REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows:
MAKE
MAKEID MAKE

—— ——–
1 Ford
2 Chevrolet
3 Toyota
MODEL
MODELID MODEL MAKEID
——- ——- ——–
1 Mustang 1
2 Escort 1
3 Malibu 2
4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?

Given the statement:
CREATE TABLE tablea (col1 INTEGER NOT NULL,
CONSTRAINT const1 CHECK (col1 in (100, 200, 300))
Which of the following can be inserted into TABLEA?