Which object is a stored procedure defined into?
A. Table
B. Schema
C. Package
D. Database
Which two activities indicate the need for a data warehouse? (Choose two.)
A. Confirm product inventory.
B. Monitor product availability.
C. Summarize sales by region.
D. Identify patterns for products sold in the last five years.
E. Associate one or more products with a purchase order.
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
A. Share (S)
B. Update (U)
C. Exclusive (X)
D. Intent Exclusive (IX)
Which statement about INSERT operations is true?
A. The INSERT statement is used to insert rows into a table, view, or table function.
B. Inserted values must satisfy the conditions of any check constraints defined on the table.
C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.
D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.
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?
A. Locked
B. Waiting
C. Pending
D. Unconnected
Which product replaced the Control Center used in versions prior to DB2 v10?
A. IBM Data Studio
B. IBM Administrator
C. IBM Data Manager
D. IBM Command Center
Which statement about roll back operations is correct?
A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.
B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.
C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.
D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT salary FROM employee WHERE salary > 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT * FROM employee WHERE salary GREATER THAN 100000
An SQL function named DEPT_INFO was created as follows:
What is the correct way to use this function in a query?
A. SELECT dept_info(dept_id, dept_name)
B. SELECT dept_id, dept_name FROM dept_info()
C. SELECT TABLE dept_id, dept_name FROM dept_info()
D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results
When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?
A. The SYSIBM schema.
B. The SYSFUN schema.
C. A schema with the name of the UDF.
D. A schema with the userid of the UDF definer.
