C2090-610 Exam Questions

What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve...

Which DB2 object is used to provide a logical grouping of other database objects?

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL sta...

Which statement about roll back operations is correct?

Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?

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

If a table named MY_TAB contains 100 rows and the following statement is executed: How many rows will be updated?

An SQL function named DEPT_INFO was created as follows: What is the correct way to use this function in a query?

Which type of stored procedure is not associated with an external application program?

Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set...

Which statement about system-period temporal tables is true?

What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?

Which operation normally does NOT require an exclusive lock?

Which command is used to back out a subset of database changes that have been made within a unit of work?

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows: How can this function be used to convert average temperature (AVG_TEMP) data sto...

If a table named MY_TAB contains 100 rows and the following statement is executed: What will happen?

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produc...

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

Which command will delete all rows from a table without generating log records?

Which isolation level offers the greatest protection of data but provides the least amount of concurrency?

What factor influences lock escalation?

Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?

Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiti...

Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria: - The employee's hire date (HIREDATE) is before 1999 and the e...

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and...

If the following result set is desired: Which SQL statement must be executed?

What is the purpose of the Query Tuner?

Which two activities indicate the need for a data warehouse? (Choose two.)

What is the primary function of an Online Transaction Processing (OLTP) workload?

Which two of the following privileges is required in order to use a package?

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?

Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

Which product replaced the Control Center used in versions prior to DB2 v10?

Which DB2 product is NOT suitable for very large data warehouse applications?

Which platform supports DB2 pureScale environments?

A table named DEPARTMENT contains the following data: What will happen?

Which statement about UPDATE processing is FALSE?

Given the following statements: What will be the result?

Which of the following are NOT stored in the system catalog tables?