Question: Part II - MOQ (10 points) Q-1) A trigger is associated with the Action(s): a) INSERT b) All of the above c) Delete d) Update
Part II - MOQ (10 points) 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 c) 512 KB b) 1 MB d) 8 KB Q-3) Which of the following is not a typical trigger action? a) Insert c) Select b) Delete d) All of the mentioned Q-4) Data page contains a book mark to tell where to find data related to the a) Nonclustered index c) Schema b) User Views d) Indexes Q-5) Rebuilding a clustered Index will b) Add book Marks to the Data pages. c) Free Empty Spaces d) Rearrange the data Physically in the a) None of the above. database Part III - Direct questions [20 points]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
