Which of the following describes the resulting behavior?
If the following SQL statements are executed in the order shown:
CREATE TABLE orders
(order_num INTEGER NOT NULL,
buyer_name VARCHAR(35),
amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?
which two of the following DB2 objects?
An alias can be an alternate name for which two of the following DB2 objects?
Which of the following events will NOT cause a trigger to be activated?
Which of the following events will NOT cause a trigger to be activated?
which of the following is NOT an accurate statement?
If a view named V1 is created in such a way that it references every column in a table named
EMPLOYEE except a column named SALARY, which of the following is NOT an accurate
statement?
Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?
Which of the following would NOT provide access to data stored in table TABLE1 using the name
T1?
Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
Which of the following DB2 objects can be referenced by an INSERT statement to generate values
for a column?
What value will be returned by the query?
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10
User USER1 successfully executes the following statements in the order shown:
VALUES NEXT VALUE FOR my_seq INTO :hvar;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the order shown:
ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?
Which of the following INSERT statements will fail to execute?
Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?
How many new records will be written to the database?
Given the following statements:
CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));
CREATE TABLE t1audit (user VARCHAR(20), date DATE, action
VARCHAR(20));
CREATE TRIGGER trig1 AFTER INSERT ON t1
FOR EACH ROW
MODE DB2SQL
INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,
‘Insert’);
If user USER1 executes the following statements:
INSERT INTO t1 VALUES (1, ‘abc’);
INSERT INTO t1 (c1) VALUES (2);
UPDATE t1 SET c2 = ‘ghi’ WHERE c1 = 1;
How many new records will be written to the database?
Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?