Which tool allows users to connect to a DB2 database using a wizard?
A. Control Center
B. IBM Data Studio
C. Universal Connection Expert
D. DB2 Connection Pool Manager
When is an INTENT EXCLUSIVE (IX) lock required?
A. When a transaction intends to read or change data.
B. When a transaction intends to change but not read data.
C. When a transaction intends to read but not change data.
D. When a transaction intends to change the system catalog.
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 order to revoke SECADM authority from user USER1 and assign it to someone else?
A. DBADM
B. DBCTRL
C. SECADM
D. DBMAINT
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.
Which two statements are true about foreign key constraints? (Choose two.)
A. The foreign key constraint columns must be supported by an index.
B. The foreign key constraint columns must be defined as NOT NULL.
C. The number and data types of foreign key constraint columns must match the parent key.
D. The columns of one foreign key constraint cannot be used in another foreign key constraint.
E. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.
Which statement about large object (LOB) locators is true?
A. A LOB locator is a data type that is used to store LOB data in binary files.
B. A LOB locator is a data type that is used to store LOB data in a database.
C. A LOB locator represents a value for a LOB resource that is stored in a database.
D. A LOB locator represents a value for a LOB resource that is stored in a binary file.
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 statement will produce the desired results?
A. SELECT name, COUNT(*) AS transactionsFROM sales
B. SELECT name, COUNT(DISTINCT name) AS transactionsFROM sales
C. SELECT name, COUNT(*) AS transactionsFROM salesGROUP BY name
D. SELECT DISTINCT name, COUNT(*) AS transactionsFROM salesGROUP BY transactions
Which type of stored procedure is not associated with an external application program?
A. A Java stored procedure.
B. A REXX stored procedure.
C. A native SQL stored procedure.
D. An external SQL stored procedure.
Which statement about UPDATE processing is FALSE?
A. The UPDATE statement logs the before and after value of every column it modifies.
B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.
C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.
Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?
A. Base Table
B. Temporal Table
C. Transition Table
D. Temporary Table
