Which two actions should you perform to modify the Transact-SQL statement?

You use a SQL Server 2005 database that contains a table named Customers. The Customers table contains the following columns.

You create a view named v_Customer by using the following Transact-SQL statement. CREATE VIEW v_CustomerASSELECT CustomerID, CompanyName, FirstName, LastName, PictureFROM Customers You want to create an index on the v_Customer view. Prior to creating the index, you need to modify the Transact-SQL statement. exhibit Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You use a SQL Server 2005 database that contains a table named Customers. The Customers table contains the following columns.

You create a view named v_Customer by using the following Transact-SQL statement. CREATE VIEW v_CustomerASSELECT CustomerID, CompanyName, FirstName, LastName, PictureFROM Customers You want to create an index on the v_Customer view. Prior to creating the index, you need to modify the Transact-SQL statement.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A.
Change the Picture column to an image data type.

B.
Include the schema name with the table name.

C.
Include the WITH SCHEMABINDING clause.

D.
Select all columns by using the * notation.

Show Hint

← Previous question

Next question →