To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.?
A. ALTER TABLE...DELETE
B. TRUNCATE ROWS
C. TRUNCATE TABLE
D. DELETE...FROM
Answer: C. TRUNCATE TABLE
You might also like to view...
train protection system automatically applies the brakes of a train if the speed limit for a segment of track is exceeded or if the train enters a track segment that is currently signalled with a red light (i.e. the segment should not be entered). Details are shown in Figure 20.19. Identify the stimuli that must be processed by the on-board train control system and the associated responses to these stimuli.
What will be an ideal response?
Write a method named displayList() that has one parameter of type Vector and has a return value of void. The method uses an iterator to display the contents of the Vector.
What will be an ideal response?
Assume that the client agreed to all your recommendations, but the improved version will not be available for six months. In the interim, the client wants you to write step-by-step guidelines to help users navigate the existing interface. Select a user interface feature that definitely needs improvement, and write a brief set of tips and user-friendly suggestions.
What will be an ideal response?
If the rulers do not display on your Word 2016 screen, click the ________ tab, and select the Ruler check box in the Show group
A) Insert B) Layout C) Design D) View