You are the database administrator for your company and manage all the SQL Server 2008 databases of thecompany.
A production database named Prod1 contains all the product and sales data for your company.
The Prod_details table contains detailed data for all of the products manufactured by your company and is frequentlyaccessed by the employees of the company.
Most of the employees’ queries include the Prod_id column of the Prod_details table in the WHERE clause.
You create an online index on the Prod_id column by using the following statement:
CREATE INDEX Prod_id_indx
ON Prod_details (Prod_id) WITH (ONLINE = ON);
You must understand the restrictions that apply to an online index. Which statements are true for online indexes? (Choose all that apply.)