Display courses and prerequisites. If there is no prerequisite, display ‘none’ else display ‘one’.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT CourseId, NVL2(PreReq, 'None', 'One')
2 FROM course;
COURSE NVL2
------ ----
EN100 One
LA123 None
CIS253 One
CIS265 None
MA150 One
AC101 One
```
You might also like to view...
Naming an array’s variable, stating its type and specifying the number of dimensions in the array is called ______ the array.
Fill in the blank(s) with the appropriate word(s).
Which of the following is not a common name for one of the three phases that a program often can be split into using pseudocode?
a. Termination phase b. Initialization phase c. Processing phase d. Action phase
Which statement is false?
a. Java does not guarantee which item will be found first when a binarySearch is performed on a List containing multiple elements equivalent to the search key. b. If the search key is found, method binarySearch returns the List index (position relative to 1) of the element containing the search key. c. The binary search algorithm is fast. d. Method binarySearch takes a List as the first argument.
The Group button is found in the Arrange group on the Picture Tools ________ tab
Fill in the blank(s) with correct word