Find all information regarding classrooms (RoomType = ‘C’).
Use the Indo–US College database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP2.LST file)
```
SQL> SELECT *
2 FROM location
3 WHERE RoomType =
4 (SELECT RoomType
5 FROm Room
6 WHERE RoomDesc = 'Classroom');
ROOMID BUILDIN ROO CAPACITY R
---------- ------- --- ---------- -
15 Nehru 301 50 C
16 Nehru 309 45 C
22 NEHRU 311 50 C
```
You might also like to view...
Analyze the following code:
ArrayList
a. The last line in the code causes a runtime error because there is no element at index 3 in the array list. b. The last line in the code has a compile error because there is no element at index 3 in the array list. c. If you replace the last line by list.add(3, "Hong Kong"), the code will compile and run fine. d. If you replace the last line by list.add(4, "Hong Kong"), the code will compile and run fine.
A threat agent is software installed on a computer that monitors for potential threats to the computer.
Answer the following statement true (T) or false (F)