×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
A user executes the following statements:
СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement? DROP ALIAS a1;
СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement? DROP ALIAS a1;
2.
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
3.
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
4.
Which of the following statements about stored procedures is TRUE?
5.
Which edition of DB2 LUW has been discontinued in v11.1?
6.
Which of the following is TRUE about indexes on column organized tables?
7.
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
8.
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?
9.
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?
10.
Which operation typically requires a Share (S) lock?