Question: Q-1) A trigger is associated with the Action(s): a) INSERT b) All of the above c) Delete d) Update Q-2) Table data is stored in

Q-1) A trigger is associated with the Action(s): a) INSERT b) All of the above c) Delete d) Update Q-2) Table data is stored in data pages that have a fixed size of a) 2 MB d) 8 KB b) 1 MB c) 512 KB Q-3) Which of the following is not a typical trigger action? d) All of the mentioned a) Insert b) Delete c) Select Q-4) Data page contains a book mark to tell where to find data related to the a) Nonclustered index d) Indexes b) User Views c) Schema Q-5) Rebuilding a clustered Index will c) Free Empty Spaces d) Rearrange the data Physically in the database a) None of the above. b) Add book Marks to the Data pages. Part III - Direct questions [20 points) Q-1) Why users add BACKUP tasks into a job. (5 Points]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
