To generate a standard report of a relational database, which of the following SQL commands would be used?
A)Select report
B)Select view
C)Create report
D)Create view

Question

Quizplus · Accepted Answer

To generate a standard report of a relational database, we would use the CREATE VIEW SQL command to create a virtual table that contains the necessary data for the report. We could then use this view as the data source for the report. The other options, SELECT REPORT and CREATE REPORT, are not valid SQL commands. SELECT VIEW is a valid SQL command, but it is not used to generate reports.

To Generate a Standard Report of a Relational Database, Which