×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
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?
2.
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?
3.
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?
4.
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?
5.
Which of the following is a characteristic of a schema?
6.
Which of the following database objects can be used to raise an error if a table is updated?
7.
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?
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?
8.
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?
9.
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?
10.
Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?