Which statement regarding referential integrity constraints is true? A. Multiple primary keys can be defined for a table. B. A foreign key can reference multiple primary keys. C. A primary key can be referenced by only one foreign key. D.…
What is a function of a table check constraint? A. To provide a method of avoiding duplicate entries for a column. B. To provide a method of ensuring a column’s values are within a specific range. C. To ensure that…
Which statement about foreign keys is true? A. A table can have only one foreign key. B. Foreign keys can only be defined when a table is created. C. A foreign key can be defined on a column or a…
A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states? A. SELECT state_cd, COUNT(*)FROM statesORDER BY COUNT(*); B. SELECT state_cd, COUNT(*)FROM…
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…
Given the following statements: What will be the result? A. Joe Smith B. <name>Joe Smith</name> C. <name>Joe Smith></name><name>DB2</name> D. <employeeinfo><name>Joe Smith</name></employeeinfo>
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…
Which statement about system-period temporal tables is true? A. They store user-based period information. B. They do not have a separate history table. C. They can be queried without a time period specification. D. They manage data based on time…
A table named DEPARTMENT contains the following data: What will happen? A. The statement will fail because a subquery cannot be used in an UPDATE statement. B. The statement will fail because the result set produced by the subquery will…
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 in ascending order by average departmental salary? A. SELECT workdept, AVG(salary)FROM employeeORDER BY…