You need to disable all triggers on the EMPLOYEES table. Which command accomplishes this?
A. ALTER TRIGGERS ON TABLE employees DISABLE;
B. None of these commands; you cannot disable multiple triggers on a table in one command.
C. ALTER TABLE employees DISABLE ALL TRIGGERS;
D. ALTER employees DISABLE ALL TRIGGERS;
Answer: C. ALTER TABLE employees DISABLE ALL TRIGGERS;
You might also like to view...
Shannon needs WordArt in her document to be 3" wide and 2" tall. She should do which of the following
A) Resize the WordArt to exact dimensions. B) Resize the WordArt to an approximate size. C) Resize the WordArt by dragging the sizing handle
Consider a deadlock detection scheme for a single server. Describe precisely when edges are added to and removed from the wait-for-graph.
Illustrate your answer with respect to the following transactions T, U and V at the server.
When U releases its write lock on ai, both T and V are waiting to obtain write locks on it. Does your scheme work correctly if T (first come) is granted the lock before V? If your answer is ‘No’, then modify your description.