The SQL command ________ defines a logical table from one or more tables or views.
A) create table
B) alter table
C) create view
D) create relationship

Question

Quizplus · Accepted Answer

The SQL command "create view" is used to define a logical table that can be created from one or more existing tables or views. This logical table can then be queried like any other table, but it does not store any data itself. This can be useful for organizing complex queries, creating virtual tables, and providing security by limiting access to certain columns or rows. The other options, "create table" and "alter table," both involve creating or modifying physical tables, while "create relationship" is not a valid SQL command.

The SQL Command ________ Defines a Logical Table from One