Free C2090-616 sample questions
Try these free C2090-616 sample questions on DB2 11.1, each with an answer and an explanation. They cover SQL, privileges and authorities, and locking and isolation levels. Use them to see which DB2 basics you should study again.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
Which method for restricting data access relies on security labels and security policies to control what data a user can access?
Which of the following set operators can be used to find all rows that are common in 2 queries?
A user executes the following statements: CREATE TABLE t1 (d INT, c2 INT); CREATE ALIAS a1 FORtl; What will be the result if the user executes the following statement? DROP ALIAS a1;
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
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)
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
Which of the following statements about triggers are TRUE? (Choose two.)
Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?
Which of the following DB2 objects can be used to provide a simplified, logical representation of data from one or more tables, but does not itself permanently store data? graph TD subgraph Database T1[Table: EMPLOYEES] T2[Table: DEPARTMENTS] V1{View: EMP_DEPT_VIEW} end T1 -- join --> V1 T2 -- join --> V1 User[User] -->|SELECT * FROM| V1
10 more free samples are waiting
Create a free account to unlock the whole C2090-616 sample bank, or get full access to all 316 practice questions in the simulator.