C2090-616 Online Practice Questions and Answers
What of the following is TRUE about triggers?
A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
B. Triggers can be used to perform data manipulation operations against complex views
C. Triggers can only be used to execute logic before or after appropriate SQL statements
D. Only one trigger for a particular event and activation time can be created for a particular table
Which of the following is TRUE about indexes on column organized tables?
A. No indexes are allowed
B. Indexes are only allowed on numeric columns
C. Indexes are automatically created to enforce unique constraints
D. An index is only allowed on the synopsis table supporting a column organized table
What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)
A. Row
B. Table
C. Scalar
D. External
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;
A. This statement will succeed and DB2 INST3 will still be able to create in the database.
B. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database.
C. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time.
D. This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles.
Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)
A. No other applications can access the table
B. Only uncommitted read (UR) applications can access the table
C. The lock owner and other applications can read, but not update, the locked table
D. The lock owner can both read and update datA. Other applications can read the table
E. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on
F. the table is dropped
Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?
A. Cloudant
B. DB2 on Cloud
C. dashDB for analytics
D. dashDB for transactions
Which method for restricting data access relies on security labels and security policies to control what data a user can access?
A. Authentication
B. Authorities and privileges
C. Label-based access control
D. Row and column access control
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;
A. The alias A1 will be dropped
B. The table T1 will be dropped
C. Both T1 and A1 will be dropped
D. Nothing, the statement will result in an error
Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT=`NPS'
A. YEARSBETWEEN
B. BINARY and VARBINARY data types
C. Double-dot notation to specify a database object
D. OFFSET x ROWS FETCH FIRST y ROWS ONLY
E. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)