Which INSERT statement is NOT correct?
Given the following table:
USERS
————————–ID INTEGER NOT NULL
NAME CHAR(20) NOT NULL
PASSWORD VARCHAR(30)
Which INSERT statement is NOT correct?
Which of the following statements is incorrect?
Which of the following statements is incorrect?
Which of the following is NOT a valid authentication type that can be used by DB2?
Which of the following is NOT a valid authentication type that can be used by DB2?
Which of the following is true about the table below?
Which of the following is true about the table below?
CREATE TABLE EMPLOYEE (
ID INTEGER NOT NULL,
NAME VARCHAR(30) NOT NULL,
EXTENSION INTEGER NOT NULL,
MANAGER VARCHAR(30) NOT NULL
PRIMARY KEY (ID));
TERMINATE;
ID NAME EXTENSION MANAGER
1 John S 53412 Y
2 Susan P 54123 N
3 Jennifer L 51234 N
What will be the result of the command?
Consider the following. As the user MYUSER, you issue the following command:
CREATE ALIAS A1 for T1
What will be the result of the command?
Which of the following is the correct syntax for using the XMLTRANSFORM SQL/XML function?
Which of the following is the correct syntax for using the XMLTRANSFORM SQL/XML function?
Which of the following statements would produce the given query result:
Consider a table TAB1 having the following values:
TAB1
—————–COL1 COL2
—- —-A 10
B 20
C 30
A 10
D 40
C 20
Consider the result of a given query:
COL1
—-A
B
C
D
Which of the following statements would produce the given query result:
The link between a column or set of columns in one table that refers to the set of column in another table is?
The link between a column or set of columns in one table that refers to the set of column in
another table is?
Which of the following commands produces a backup image from a database?
Which of the following commands produces a backup image from a database?
Which of the following statements CANNOT be issued against indexes?
Which of the following statements CANNOT be issued against indexes?