Create a separate table with the same structure as the Booking table to hold archive records. Using the INSERT statement, copy the records from the Booking table to the archive table relating to bookings before 1st January 2013. Delete all bookings before 1st January 2013 from the Booking table.

What will be an ideal response?


CREATE TABLE BookingOld( hotelNo CHAR(4) NOT NULL,
guestNo CHAR(4) NOT NULL,
dateFrom DATETIME NOT NULL,
dateTo DATETIME NULL,
roomNo VARCHAR(4) NOT NULL);
INSERT INTO BookingOld
(SELECT * FROM Booking
WHERE dateTo < DATE’2013-01-01’);
DELETE FROM Booking
WHERE dateTo < DATE’2013-01-01’;

Computer Science & Information Technology

You might also like to view...

After applying a slide master use ___________ view to verify that the new font attributes are applied to the text on all of the slides in your presentation.

A. Normal B. Slide Sorter C. Slide Preview D. Slide Show

Computer Science & Information Technology

The Document Inspector identifies personal information or hidden data with a(n):

A) animated icon. B) red flag. C) exclamation point. D) check mark.

Computer Science & Information Technology

A VPN is used by a corporate employee who wants to securely access corporate resources from home

Indicate whether the statement is true or false

Computer Science & Information Technology

A combination of two or more keyboard keys, used to perform a task that would otherwise require a mouse.

What will be an ideal response?

Computer Science & Information Technology