Litware Price Groups: In the first T-SQL example, which keyword completes the CREATE statement to define the object?

Litware Price Groups: In the first T-SQL example, which keyword completes the CREATE statement to define the object?

• A. VIEW
• B. TABLE
• C. PROCEDURE
• D. FUNCTION

Answer: (A)

The statement is defining a view. In T-SQL, the keyword that follows CREATE determines what kind of database object you’re creating. CREATE VIEW defines a virtual table based on a query, stored as a named object, but it doesn’t hold data itself. This is ideal for presenting a specific, reusable query result (like Litware Price Groups) without duplicating data. In contrast, CREATE TABLE would create a base physical table that stores data, CREATE PROCEDURE defines a stored procedure, and CREATE FUNCTION defines a user-defined function. So the first T-SQL example uses CREATE VIEW to define a view.

The statement is defining a view. In T-SQL, the keyword that follows CREATE determines what kind of database object you’re creating. CREATE VIEW defines a virtual table based on a query, stored as a named object, but it doesn’t hold data itself. This is ideal for presenting a specific, reusable query result (like Litware Price Groups) without duplicating data.

In contrast, CREATE TABLE would create a base physical table that stores data, CREATE PROCEDURE defines a stored procedure, and CREATE FUNCTION defines a user-defined function. So the first T-SQL example uses CREATE VIEW to define a view.