Latest Questions & Answers

Q: Modify the query used in Problem 29 to produce the summary shown

Modify the query used in Problem 29 to produce the summary shown in Figure P7.30. FIGURE P7.30 Customer Purchase Summary

Q: Write an example of a database request.

Write an example of a database request.

Q: What is the difference between the COUNT aggregate function and the SUM

What is the difference between the COUNT aggregate function and the SUM aggregate function?

Q: Explain why the two following commands produce different results. SELECT

Explain why the two following commands produce different results. SELECT DISTINCT COUNT (V_CODE) FROM PRODUCT; SELECT COUNT (DISTINCT V_CODE) FROM PRODUCT;

Q: Explain the difference between an ORDER BY clause and a GROUP BY

Explain the difference between an ORDER BY clause and a GROUP BY clause.

Q: Rewrite the following WHERE clause without the use of the IN special

Rewrite the following WHERE clause without the use of the IN special operator. WHERE V_STATE IN (‘TN’, ‘FL’, ‘GA’)

Q: What are “referential constraint actions”?

What are “referential constraint actions”?

Q: What is the difference between a column constraint and a table constraint

What is the difference between a column constraint and a table constraint?

Q: Write the SQL code to change the job code to 501 for

Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then reset the job code to its origi...

Q: Write the SQL code that will save the changes made to the

Write the SQL code that will save the changes made to the EMP_1 table. ATTRIBUTE (FIELD) NAME DATA DECLARATION  EMP_NUM CHAR(3)  EMP_LNAME VARCHAR(15)  EMP_FNAME VARCHAR(15)  EMP_INITIAL...