List all copies of the book title “Lord of the Rings” that are available for borrowing.

What will be an ideal response?


SELECT copyNo
FROM BookCopy bc, Book b
WHERE bc.ISBN = b.ISBN AND bc.available = ‘Y’ AND title = ‘Lord of the Rings’;

Computer Science & Information Technology

You might also like to view...

Which of the following is NOT a major part of an autonomous access point?

A. antenna B. wired network interface C. bridging software D. wireless switch

Computer Science & Information Technology

Ethan is working with desktop video. Ethan uses a ____ as a prototype for testing his DVD.

A. DVR B. video clip C. DVD image D. codec

Computer Science & Information Technology

The physical numeric address functions at a sublayer of the Data Link layer in the OSI network reference model, called the ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Scanning your computer for viruses is typically done by:

A) the registry B) malware C) virus checker software D) an executable file

Computer Science & Information Technology