MS SQL Server - 42 - View (Create Alter Remove) MCQ

42 – View (Create Alter Remove) MCQ

Best of luck!

1 / 25

1. What is a view in SQL Server?

A table used for primary key constraints

A table that cannot have indexes

A physical table that contains aggregated data

A virtual table that is not stored physically

2 / 25

2. In SQL Server, what is the primary purpose of creating a view?

To store data separately from the base table

To improve query simplicity and security

To enforce data constraints

To create a backup of the table

3 / 25

3. Which SQL statement is used to create a view in SQL Server?

CREATE INDEX IX_ViewName ON ViewName (ColumnName)

CREATE TABLE TableName AS SELECT * FROM ViewName

CREATE VIEW ViewName FROM TableName

CREATE VIEW ViewName AS SELECT * FROM TableName

4 / 25

4. In SQL Server, can you modify the data stored in a view?

Only if the view is materialized.

No, views are read-only.

Only if the view is indexed.

Yes, views are updatable.

5 / 25

5. Which of the following statements about indexed views in SQL Server is true?

Indexed views are not used for query optimization.

Indexed views cannot be created on base tables with primary keys.

Indexed views are always physically stored on disk.

Indexed views can improve query performance for certain types of queries.

6 / 25

6. In SQL Server, which SQL statement is used to alter the definition of an existing view?

EDIT VIEW ViewName FROM TableName

MODIFY VIEW ViewName AS SELECT * FROM TableName

ALTER VIEW ViewName AS SELECT * FROM TableName

ALTER TABLE TableName AS SELECT * FROM ViewName

7 / 25

7. What is the purpose of the WITH CHECK OPTION clause when creating or altering a view?

It enforces data constraints on the base table.

It restricts the rows that can be modified through the view.

It allows data modification operations on the view.

It defines the columns included in the view.

8 / 25

8. In SQL Server, what happens when you use the DROP VIEW statement?

It deletes the data and the view definition.

It deletes the base table.

It deletes the view definition but retains the data in the view.

It deletes the view definition but retains the data.

9 / 25

9. In SQL Server, which SQL statement is used to remove an existing view from the database?

REMOVE VIEW ViewName

DELETE VIEW ViewName

DROP VIEW ViewName

ALTER TABLE ViewName DROP

10 / 25

10. What is the primary advantage of using views in SQL Server?

They store data separately from the base table.

They simplify complex queries by providing a virtual table.

They improve data integrity.

They enforce primary key constraints.

11 / 25

11. In SQL Server, can you create an index directly on a view?

Yes, but only if the view is read-only.

No, views cannot have indexes.

Yes, all views can have indexes.

Yes, but only if the view is materialized.

12 / 25

12. What is the purpose of the SCHEMABINDING clause when creating a view in SQL Server?

It enforces a specific schema for the base table.

It defines the columns included in the view.

It prevents changes to the base table structure.

It specifies the view name.

13 / 25

13. In SQL Server, what is the primary purpose of the NOCHECK clause when altering a view?

It defines the columns included in the view.

It disables the WITH CHECK OPTION constraint for the view.

It enforces data constraints on the base table.

It allows data modification operations on the view.

14 / 25

14. In SQL Server, what is the purpose of the ENCRYPTION clause when creating a view?

It encrypts the view definition.

It encrypts the data in the view.

It specifies the encryption algorithm for the view.

It prevents unauthorized access to the view.

15 / 25

15. In SQL Server, can you create a view that combines data from multiple tables?

Only if the tables have primary keys.

No, views can only reference a single table.

Yes, views can combine data from multiple tables.

Only if the tables have the same schema.

16 / 25

16. In SQL Server, what is the primary purpose of the NOEXPAND hint when querying an indexed view?

It disables the use of indexed views in query optimization.

It enforces data constraints.

It defines the columns included in the view.

It forces the expansion of indexed views.

17 / 25

17. Which of the following statements about views in SQL Server is true?

Views always contain a copy of the base table's data.

Views can have triggers.

Views are always updatable.

Views can have primary key constraints.

18 / 25

18. In SQL Server, what is the primary purpose of using the SCHEMABINDING option when creating a view?

To improve query performance.

To prevent changes to the base table that would affect the view.

To specify the schema of the base table.

To encrypt the view definition.

19 / 25

19. Which of the following is an example of a valid view definition in SQL Server?

CREATE VIEW MyView (Column1, Column2) AS SELECT * FROM MyTable;

CREATE VIEW MyView FROM MyTable WHERE Column1 = 1;

CREATE TABLE MyTable AS SELECT * FROM MyView;

CREATE VIEW MyView AS SELECT * FROM MyTable WHERE Column1 = 1;

20 / 25

20. What is the primary purpose of using the ENCRYPTION option when creating a view in SQL Server?

To encrypt the data in the view.

To encrypt the view definition.

To improve query performance.

To specify the encryption key for the view.

21 / 25

21. In SQL Server, can you create an index on a view that uses the TOP clause in its definition?

Yes, indexed views can include the TOP clause.

No, indexed views cannot use the TOP clause.

Only if the view is encrypted.

Only if the view is materialized.

22 / 25

22. What is the primary advantage of using the WITH CHECK OPTION clause when creating a view in SQL Server?

It ensures that only rows that satisfy the view's filter condition can be inserted or updated through the view.

It allows you to create materialized views.

It encrypts the view's definition.

It simplifies query performance optimization.

23 / 25

23. In SQL Server, which SQL statement is used to modify the definition of an existing view?

ALTER TABLE TableName AS SELECT * FROM ViewName

MODIFY VIEW ViewName AS SELECT * FROM TableName

ALTER VIEW ViewName AS SELECT * FROM TableName

EDIT VIEW ViewName FROM TableName

24 / 25

24. In SQL Server, what is the primary purpose of using the CHECK OPTION clause when creating a view?

To specify the schema of the base table.

To enforce data constraints on the view.

To prevent changes to the base table that would affect the view.

To improve query performance.

25 / 25

25. In SQL Server, can you create a view that contains calculations or expressions?

No, views can only contain raw table data.

Only if the view is indexed.

Yes, views can include calculations and expressions.

Only if the calculations are performed in a stored procedure.

Your score is

MS SQL Server – 42 – View (Create Alter Remove) MCQ