Multiple choice technology databases

EasyYatra is a travel booking company that has a web site available for customers to view and book their vacations online. You have been hired to look after the back-end SQL Server that is used to store customer and booking information. You are creating a table called Booking to keep track of vacations booked by customers. This table will contain a computed column called Total that is derived from other columns in the table. You want to be able to create an index on this Total column to increase performance when any queries are executed using this column. To do this, you want to physically store the computed column in the table. How can this be done?

  1. Mark the computed column as PERSISTED.

  2. Define the computed column as NULL.

  3. Specify the collation for the column using COLLATE Physical.

  4. Do nothing. Computed columns are stored in the table by default.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

By marking a computed column as PERSISTED, SQL Server physically stores the computed values in the table and updates them when dependent columns change, allowing you to create indexes on it.

Keep practicing — related questions