×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which of the following is a valid DB2 data type?
2.
Which of the following DB2 data types does NOT have a fixed length?
3.
Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
4.
Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
5.
Which of the following DB2 data types can NOT be used to create an identity column?
6.
Which two of the following are optional and do not have to be specified when creating a table?
7.
Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?
8.
Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
9.
If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?
10.
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?