1. A cookie that lasts only until the browser is closed is called a ________ cookie. session persistent temporary timed 2. In the MVC architecture, the user interface is presented in the _____________ layer. Model View Controller MVC 3. Nodes with the same parent element are called ______ elements. sibling similar dual tuple 4. The following SQL query: SELECT count(*) FROM people WHERE id > 500; selects all items from the people table where the id attribute is greater than 500 selects all items from the people table where the id attribute selects the total number of items in the people table where the id attribute is greater than 500 selects the total number of items in the people table where the id attribute is greater than or equal to 500 5. A ______ key must be unique in any SQL table. singular general foreign compound 6. Which of the following will match the pattern LIKE "%a_bugs%life_" in a SQL WHERE clause? abugslife bacbugslife! yyabugslife!! thisisaabugsincrediblelifeisay 7. Asynchronous calls __________. require a web page to reload are executed concurrently are executed in order generally slower than synchronous requests 8. SQL is a ________. relational database non-relational database language for creating database queries and manipulating data language for manipulating the DOM 9. The ______ HTTP method is used to create new data on a server. GET POST DELETE PUT 10. Each table column in a relational detabase represents a different ________. data attribute primary key record result set 11. There is a(n) ________ relationship between a primary key and its corresponding foreign key. one-to-one one-to-many many-to-one inverse 12. An if..else statement is a _______ structure. sequence selection reptition decision 13. The following SQL query: SELECT * FROM TableName; generates an error. selects all rows from the table TableName. selects all columns from the table TableName. selects all rows and columns from the table TableName. 14. INNER JOIN in MySQL is used to: merge data from different tables integrate MySQL into PHP order the resulting query resolve qualified names in a query