Which event will NOT cause a trigger to be fired? A. Execution of an INSERT statement. B. Execution of LOAD REPLACE operation. C. Execution of an INSERT operation of a MERGE statement. D. Execution of an UPDATE operation of a…
Which database object provides an alternative way of describing data that exists in one or more base tables? A. Alias B. View C. Index D. Sequence
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.…
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
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…
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 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…
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…
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 SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE? A. SELECT * FROM employeeWHERE salary < 100000 B. SELECT salary FROM employeeWHERE salary > 100000 C. SELECT salary FROM…