Find faculty members whose name start with C.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT *
2 FROM faculty
3 WHERE Name LIKE 'C%';
FACULTYID NAME ROOMID PHO DEPTID
---------- --------------- ---------- --- ----------
555 Chang 17 587 5
333 Collins 17 599 3
```
You might also like to view...
In an MS-DOS COPY command, if no file name is specified for the destination file, the __________ is used.
a. default file name b. You must specify both source and a destination file names. c. The command is rejected by MS-DOS. d. source file name
Which of the following could become a member of the Internet2?
A) CNN B) Amazon C) Facebook D) Library of Congress
Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries. Ali retrieves a list of the authors whose names start with the letters "Jef." He wants to filter this result by including names that have only 5 letters. Which of the following should Ali use to retrieve the names that follow both criteria?
A. ?="Jef**" B. ?>="Jef.." C. ?Like "Jef??" D. ?In ("Jef","$$")
"Arial, helvetica, sans-serif" is a widely used sans-serif font ____.
A. property B. family C. set D. stack