ExamDumpster

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.

Question 1Choose 2

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

Question 2Choose one

Which method for restricting data access relies on security labels and security policies to control what data a user can access?

Question 3Choose one

Which of the following set operators can be used to find all rows that are common in 2 queries?

Question 4Choose one

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;

Question 5Choose one

Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

Question 6Choose one

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)

Question 7Choose one

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

Question 8Choose 2

Which of the following statements about triggers are TRUE? (Choose two.)

Question 9Choose one

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?

Question 10Choose one

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.

Create account