You use a table that stores movie information in your database.
The table has the following schema:
CREATE TABLE Movies(
MovieID nchar(4) NOT NULL,
Title nvarchar(25) NOT NULL,
MovieDescription nvarchar(50) NULL,
Rating smallint NOT NULL CONSTRAINT Check_Rating CHECK (Rating between 1 AND 7),
CONSTRAINT [PK_Movies] PRIMARY KEY CLUSTERED ([MovieID] ASC))
GO
You plan to insert a new record for a movie that will be released by using the following information:
Column Data
MovieID M999
Title Movie to be released
MovieDescription This movie is yet to be released
Rating 0
You need to ensure that the following requirements are met:
•Only this movie record gets a Rating of 0.
•Other movie records that will be inserted in the future must get a Rating of 1 through 7.
Which three Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
Build List and Reorder:
