1. The SQL statement "delete from Branch;" will remove 5 records from the table.
2. Input data from the client to the application.
3. Refer to page 3. The clientNo column can be a candidate key in the Viewing table.
4. The following SQL statement can be run without an error: "select fname, Iname from Staff UNION select Iname from Client."
5. The value of a foreign key can be NULL.
6. Update Branch set hotelno='xyOl' where hotename='Latham';
7. SQL query "drop from Hotel where hotelno=dc01;" will remove hotel Latham from the table.
8. The SQL statement "SELECT 1!=NULL" will return NULL.
Part II. Please write answers in A, B, C, D, E. 2 points each
11. In our project I, computer eve.kean.edu is to provide what kind of functions?
A) Browser to view the data
B) Web server
C) Database server
12. Database administrator's main job is usually responsible for:
A) Physical database design
B) Design web pages
C) Writing application programs
D) Overall management of data resources
13. Which SQL command can add a new column to an existing table?
A) SELECT
B) DROP
C) ALTER
D) GRANT
14. Which UNIX command can create a folder?
A) cd
B) rm
C) mkdir
If there are 100 records in the table, which PHP MySQL function should be in a loop to read every row?
15. A) mysqli_select_db
B) mysqli_connect
C) mysqli_query
D) mysqli_fetch_array
16. Refer to page 3, how many rows will be generated from the below SQL query?
Select count(*) from Branch b right join Staff s on b.branchno=s.branchno;
A) 2
B) 3
Which answer won't be included in the output of the following SQL query?
17. Select fname from Staff where salary > select min(salary from Staff);
A) David
B) Susan
C) Mary
D) John
E) Ann
What is the output of the query?
18. Select count(*) from Branch b, Hotel h where h.city=b.city and b.city=T
A) 0
B) 1
C) 3
D) 6
E) 10
What is the output of the following query?
19. Select count(distinct(city from Hotel where hotelno in select hotelno from Room where type=double);
A) 1
B) 2
C) 3
D) 4
E) 5
F) 6
How many rows and columns will this SQL output?
Select * from Branch natural join Staff;
20. A) 5 rows, 4 cols
B) 6 rows, 8 cols
C) 6 rows, 11 cols
D) 6 rows, 12 cols
E) 11 rows and 12 columns
Part III. Please refer to tables on page 3 for the following questions. 4 points
Write a SQL query to promote David Ford to Manager and change his salary to $18,000.
SOL:
Write the output of the query at the right side.
Result:
6 pt, 0.2/each)
1. city hotelno l cit
SOL: Ibranchno select branchno, b.city, hotelno, h.city from Branch b left join Hotel h on h.city=b.city
