5. Display names of faculty members who work in department 1 or 2. Use IN operator in your query.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT *
2 FROM faculty
3 WHERE DeptId IN (1, 2);
FACULTYID NAME ROOMID PHO DEPTID
---------- --------------- ---------- --- ----------
111 Jones 11 525 1
222 Williams 20 533 2
123 Mobley 11 529 1
235 Vajpayee 12 577 2
```
You might also like to view...
A Cascading Style Sheet (CSS) consists of sets of formatting rules that create ____________________.
Fill in the blank(s) with the appropriate word(s).
After the review process a document has been completed, the original author can choose to accept or reject each change
Indicate whether the statement is true or false
Which type of control is considered a compensating control?
A. segregation of duties B. access control C. supervision D. accounting records
A technician is being tasked to centralize the management of the switches and segment the switches by broadcast domains. The company is currently all on VLAN1 using a single private IP address range with a 24 bit mask. The supervisor wants VLAN 100 to be the management subnet and all switches to share the VLAN information. Which of the following options would work BEST to accomplish these requirements?
A. Use VLSM on the IP address range, with STP and 802.1q on the inter switch connections with native VLAN 100 B. Use VLSM on the IP address range with VTP and 802.1x on all inter switch connections with native VLAN 100 C. Use VLSM on VLAN1, with VTP and 802.1w on the inter switch connections with native VLAN 100 D. Use VLSM on the IP address range with VTP and 802.1q on the inter switch connections with native VLAN 100