000-610 - DB2 10.1 Fundamentals

Go back to IBM

Example Questions

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid? Which database object provides an alternative way of describing data that exists in one or more base tables? If no isolation level is specified, what is the default isolation level used? Which statement about bitemporal tables is valid? Which operation normally does NOT require an exclusive lock? What is the purpose of the Query Tuner? Which statement is true regarding constraints? Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.) Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates? What is the primary function of an Online Transaction Processing (OLTP) workload? Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE? Which command will delete all rows from a table without generating log records? If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database? Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1? Which command is used to back out a subset of database changes that have been made within a unit of work? Which two DB2 objects can a view be derived from? (Choose two.) What isolation level prevents dirty reads, nonrepeatable reads, and phantoms? Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ? Which statement about application-period temporal tables is true? What is the minimum product required for DB2 connectivity across all platforms? By default, a column defined as a TIMESTAMP includes which attributes? Which DB2 object is used to provide a logical grouping of other database objects? Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to? 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 employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended university Which SQL statement will accomplish this? If a user has been granted SYSCTRL authority, which activities can they perform? What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts? When a COMMIT statement is executed, what happens? 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 action needs to be performed in order to complete the definition of an application-period temporal table? Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction? 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 waiting for application APP_A to finish making updates, what isolation level must application APP_B use? 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 are INSTEAD OF triggers used for? What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as? 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. Which authority/privilege must user USER1 be granted in order to re-create the package? Which of the following privileges allow a user to update the comment on a sequence? Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency? 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 earns a salary of less than $35,000.00 per year? What is the purpose of a role? What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view? 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? Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE? Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data? Which DB2 object can be used to improve the execution performance of qualified SELECT statements? Which statement about INSERT operations is true? Which product replaced the Control Center used in versions prior to DB2 v10? Which object is used to cache table and index data as it is read from disk? In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in? 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 your goal? When is an INTENT EXCLUSIVE (IX) lock required?