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

6 rows selected.
```

Computer Science & Information Technology

You might also like to view...

____ are defects in application and system software that can be exploited by a threat.

A. Threats B. Vulnerabilities C. Risks D. Patches

Computer Science & Information Technology

In VBA, a(n) ________ is a group of instructions that is a subset of a program

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

Computer Science & Information Technology

The following figures define the typical operating parameters of a processor.



If the clock rate could be reduced by 15%, it would require only 2 cycles to perform a register load. Would that be a good idea?

Computer Science & Information Technology

Constructors are methods.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology