Academic Curator
search
Integrate Database Exam
Time Left: 00:00

Integrate Database with a Website Exam

Instruction: Select the correct answer for each of the 25 questions based on the course document.

1. Which type of web page has its contents generated each time it is accessed?




2. Which layer of a web database application is responsible for handling the layout and display of HTML documents?




3. In which layer do most of the application's business rules and functionality reside?




4. Which component provides the link between the application logic layer and the DBMS?




5. HTTP is described as what type of protocol because each connection is closed once the server provides a response?




6. What are the two types of client-side solutions for web database gateways?




7. Which aspect of a web server refers to the time it is online and operational?




8. Which term describes making existing servers more powerful (vertical) or adding more servers (horizontal)?




9. Which web server software is also known as a "Windows web server"?




10. Which popular open-source web server is known for efficiency and handling huge volumes of traffic via reverse proxy?




11. Which type of server provides the runtime environment for enterprise applications and interactive content?




12. What language is used for accessing and processing data contained in relational databases?




13. What is the most important benefit of using template-driven packages like PHP?




14. What does the acronym DDL stand for in the context of SQL?




15. Which SQL sublanguage includes the INSERT, UPDATE, and DELETE statements?




16. Which SQL sublanguage is primarily used for retrieving data based on specific criteria?




17. Which two methods are commonly used to send HTML form data to a server?




18. Which SQL statement is used to modify existing records in a table?




19. Which SQL statement is used to remove records from a table?




20. In PHP, which function must be used to execute multiple SQL statements at once?




21. Which software package provides a local web server, PHP, and MySQL for development purposes?




22. In an UPDATE statement, which keyword is used to list the columns you want to modify?




23. What is the "bridge" that handles the difference between stateful databases and stateless HTTP called?




24. Which early standard was used to check and transfer data from the server to the database application?




25. Which text-based browser was popular in the early days of the Web?