Need help ASAP
OL and E-R questions are based on the current data on page 3. rt I. Please write answer in true or false. (2 points each) Pa 2. 3. The SQL statement "insert into Branch values('xyzl','main',: Union' null);" can be executed without error The SQL statement "delete from Branch" will remove 5 records from the table. A SQL injection is a security concern; it is an attack that consists of an insertion of a SQL query through the input data from the client to the application. Refer to page 3, the clientNo column can be a candidate key in the Viewing table. A cookie in web applications is a small file that the server embeds on the user's browser (client computer) The following SQL statement can be run without an error select fname, Iname from Staft UNION select Iname from Client: 7. 8. The value of a foreign key can be NULL Based on current data on page 3, we can run the following statement without running other SQL statements. update Branch set hotelno 'xy01' where hotename- 'Latham SQL query "drop from Hotel where hotelno-'de0l';" ill remove hotel "Latham" from the table. The SQL statement "SELECT 1! NULL; will return NULL 9. 10. art II. Please write answers in A, B, C, D, E. (2 points each) In our project 1, computer eve.kean.edu is to provide what kind of functions? Database administrator's main job is usually responsible for A). Browser to view the data B). web server C).database server 12. B). design web pages D). overall management of data resources. A). physical database design. C). writing application programs A). SELECT B). rm Which SQL command can add a new column to an existing table? Which UNIX command can create a folder? If there are 100 records in the table, which PHP MySOL function should be in a loop to read every row? 13. B). DROP C). ALTER D). GRANT 14 C). pwd D). mkdir A). ed 15 A) . mysqli select db B). mysqli connect C) mysqli query D. mysqli fetch array Refer to page 3, how many rows will be generated from below SQL select count.) from Bra A). 2 nch b right join Staff s on b.branchno-s.branchno; B). 3 C).4D). 5 E). 6 F). 8 .Which answer won't he included in the output of the following SOL query select fname from Staff where salary>(select min(salary) from Staff); A). David B). Susan C). Mary D). John E). Ann 17 18 What is the output of query select count) from Branch b, Hotel h where h.city-b.city and b.city- A).0 B). 1 C).3 D). 6 E). 10 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 19 What is the output of the following query 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 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 SQL: 20. How many rows and columns will this SQL output? "select from Branch natural join Stafm art Result: (6 pt, 0.2/each) l branchno 1 cityhotelno I cit (6 points) Write the output of the query at the right side . select branchno, b.city, hotelno, h.city from Branch b left join Hotel h on h.city-b.city
