You can select a range by using the Name Box
Indicate whether the statement is true or false
TRUE
You might also like to view...
For each of the following queries, state whether the query is valid and for the valid ones should how each of the queries would be mapped onto a query on the underling base tables.
Consider the following view defined on the Hotel schema: CREATE VIEW HotelBookingCount (hotelNo, bookingCount) AS SELECT h.hotelNo, COUNT(*) FROM Hotel h, Room r, Booking b WHERE h.hotelNo = r.hotelNo AND r.roomNo ? b.roomNo GROUP BY h.hotelNo; (a) SELECT * FROM HotelBookingCount; (b) SELECT hotelNo FROM HotelBookingCount WHERE hotelNo = ‘H001’; (c) SELECT MIN(bookingCount) FROM HotelBookingCount; (d) SELECT COUNT(*) FROM HotelBookingCount; (e) SELECT hotelNo FROM HotelBookingCount WHERE bookingCount > 1000; (f) SELECT hotelNo FROM HotelBookingCount ORDER BY bookingCount;
The Disk Defragmenter uses the color ________ to highlight unmovable files on your disk
Fill in the blank(s) with correct word
Before running a delete query, what should you do?
A) View the results in Design view. B) Manually go through the table and delete the information, then use the delete query to verify all information is removed. C) Preview the datasheet to verify that the records are those that you intend to delete. D) Create the table, you can always delete it if the information is wrong.
By default, the Normal style inserts a vertical space equal to ____ line(s) between each line of text.
A. 1 B. 1.15 C. 2 D. 2.15