QUESTION NO: 1
If you are already connected to a database, what does running the following statement do?
Db2 CONNECT
If you are already connected to a database, what does running the following statement do?
Db2 CONNECT
Correct Answer: C
Vote an answer
QUESTION NO: 2
Which of the following authorities is sufficient for connecting to a database?
Which of the following authorities is sufficient for connecting to a database?
Correct Answer: A
Vote an answer
QUESTION NO: 3
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Correct Answer: C
Vote an answer
QUESTION NO: 4
Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES ('John,100);
COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME='John';
After a few seconds, application 2 executes the following query:
SELECT AMOUNT FROM TAB1 WHERE NAME='John'
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?
Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES ('John,100);
COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME='John';
After a few seconds, application 2 executes the following query:
SELECT AMOUNT FROM TAB1 WHERE NAME='John'
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?
Correct Answer: D
Vote an answer
QUESTION NO: 5
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;
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;
Correct Answer: B
Vote an answer
QUESTION NO: 6
Which of the following is fundamental to BLU acceleration?
Which of the following is fundamental to BLU acceleration?
Correct Answer: A
Vote an answer
QUESTION NO: 7
The creator of an index or an index specification automatically receives which privilege on the index?
The creator of an index or an index specification automatically receives which privilege on the index?
Correct Answer: A
Vote an answer