databases Online Quiz - 111
|Description: databases Online Quiz - 111|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
What is true of using group functions on columns that contain NULL Values
You cannot modify data in a view if it contains: Group functions such as SUM, MIN, MAX, AVG, … A GROUP BY clause. The DISTINCT keyword. Columns defined by expressions (i.e, SAL * 12). The ROWNUM pseudo column.
Which table should you query to determine when your procedure was last compiled?
Which of the following syntax is correct for creating a proc
Which of the following SQL statements is correct?
What is a stored procedure?