Which tool allows users to connect to a DB2 database using a wizard?
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?
Which statement about roll back operations is correct?
When a COMMIT statement is executed, what happens?
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
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 namedEMPLOYEE?
