To create a view that shows the average grade and enrollment count for each course, which command is used by the DBA?

• A. CREATE VIEW CourseGrades AS ...
• B. INSERT INTO CourseGrades AS ...
• C. DROP VIEW CourseGrades AS ...
• D. SELECT CourseGrades AS ...

Answer: (A)

Using the CREATE VIEW command is essential when the goal is to formulate a view that summarizes specific data—in this case, the average grade and enrollment count for each course. A view acts as a virtual table that represents the result of a query stored in the database. It allows users to retrieve data in a structured format without requiring them to write complex queries each time.

The syntax for creating a view typically includes the SELECT statement that defines how the data is aggregated, which aligns perfectly with the requirements of this task. By specifying the necessary fields, like the average grade and the enrollment count, the DBA creates a reusable, consistent representation of the data that can be queried like a regular table.

In contrast, the other options do not fulfill the purpose of creating a view. INSERT INTO would attempt to add records to a table rather than define a structure for displaying computed information. DROP VIEW is used to eliminate an existing view from the database, which is irrelevant when one is seeking to establish a new view. The SELECT statement by itself would merely fetch data from a view or table without the definition of a new view. Thus, the CREATE VIEW command effectively encapsulates the objective of summarizing course data in a reusable format.