C2090-610 Exam Questions

What are two valid objects that can be created in DB2? (Choose two.)

Which type of temporal table can be used to store only time-sensitive data?

When an index is created for a table, where is the metadata for that index stored?

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

Which authority or privilege is granted by the DB2 Database Manager configuration file?

Which two of the following authorities allow a user to create a new database?

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?

Which of the following will allow user USER1 to change the comment associated with a table named TABLE1?

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

Which statement about INSERT operations is true?

Which statement about application-period temporal tables is true?

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

If a user has been granted SYSCTRL authority, which activities can they perform?

What is the purpose of a role?

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict ac...

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in ord...

A table named EMPLOYEE was created as follows: Which action will prevent unauthorized users from accessing SSN data?

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

Which privilege is required to invoke a user defined function?

Which statement is true about an index that is used to support a UNIQUE constraint?

Which statement regarding triggers is true?

A table named STATES was created as follows: What will happen?

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

Which statement about triggers is true?

Which two statements are true about foreign key constraints? (Choose two.)

What is the primary purpose of a view?

By default, a column defined as a TIMESTAMP includes which attributes?

Which is NOT a valid reason for creating an index?

Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?

Which statement is true regarding constraints?

By default, where is the data stored for a column defined with an XML data type?

Which statement about BEFORE triggers is FALSE?

What is used in conjunction with a foreign key to define a relationship between two tables?

Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

Given the following statement: GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION; Which statement is correct?

Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

When is a mask used to limit access to data in a table?

What privilege is required to create a view on a table that you are not the owner of?

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Whic...

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?

Which of the following privileges allow a user to update the comment on a sequence?

Which statement is valid about the Row and Column Access Control (RCAC) feature?

Which type of table should you use if you want to define specific time periods when data is valid?

Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?

Which object can be enabled for compression?

What is the minimum product required for DB2 connectivity across all platforms?