CS406 MCQs

CS406 (Weeks 1 to 6) based on the syllabus content:

Week 1: Course Introduction

Q1. What is the primary goal of this course?

1. To understand programming languages
2. To create traditional websites
3. To develop and manage database-driven web applications
4. To master SEO techniques

Answer: C) To develop and manage database-driven web applications

Q2. Which of the following is a primary text for this course?

1. "Database-Driven Web Sites" by Jesse Feiler
2. "Learn Python the Hard Way" by Zed Shaw
3. "SQL for Beginners" by Matt Doyle
4. "Modern Database Systems" by Loren Baker

Answer: A) "Database-Driven Web Sites" by Jesse Feiler

Q3. Which layer is NOT part of a database-driven web application?

1. Application logic layer
2. Database layer
3. Network infrastructure layer
4. Browser layer

Answer: C) Network infrastructure layer

Q4. What is the role of a database schema?

1. Defines database structure and relationships
2. Stores the physical data of the database
3. Optimizes database performance
4. Establishes user authentication

Answer: A) Defines database structure and relationships

Q5. What is the primary difference between a traditional and database-driven website?

1. Database-driven websites interact dynamically with user data
2. Traditional websites require databases for static data
3. Traditional websites are built using JavaScript only
4. Database-driven websites have no user interaction

Answer: A) Database-driven websites interact dynamically with user data

Q6. Who is considered the inventor of the World Wide Web?

1. Alan Turing
2. Tim Berners-Lee
3. John von Neumann
4. Steve Jobs

Answer: B) Tim Berners-Lee

Q7. Which protocol does the World Wide Web primarily use?

1. FTP
2. HTTP
3. SMTP
4. POP3

Answer: B) HTTP

Q8. What is the main advantage of database-driven websites?

1. Low development cost
2. Easy scalability and maintenance
3. Static content delivery
4. High SEO ranking

Answer: B) Easy scalability and maintenance

Q9. What is the external level in data abstraction?

1. Physical data storage
2. User-specific views of the database
3. Entire database structure
4. Database connection logic

Answer: B) User-specific views of the database

Q10. What type of software is a DBMS?

1. Operating system
2. Database optimization tool
3. Software for managing databases
4. Web server application

Answer: C) Software for managing databases

Week 2: Web Application vs. Website

Q1. What is a characteristic of a website?

1. Focus on static content delivery
2. Requires user authentication
3. Allows dynamic data manipulation
4. Performs high-level processing

Answer: A) Focus on static content delivery

Q2. How does a web application differ from a website?

1. Websites perform automated tasks
2. Web applications allow user interactions with data
3. Websites require complex processing
4. Web applications are marketing-focused

Answer: B) Web applications allow user interactions with data

Q3. Which of the following is NOT a feature of a website?

1. Data presentation
2. User authentication
3. Simplified navigation
4. Brand communication

Answer: B) User authentication

Q4. Web applications are also referred to as:

1. Static websites
2. Web portals
3. Offline tools
4. Presentation layers

Answer: B) Web portals

Q5. What is a key feature of websites compared to web applications?

1. Marketing-focused design
2. High server load
3. Task automation
4. Data analytics

Answer: A) Marketing-focused design

Q6. Which of the following statements about web applications is true?

1. They are primarily used for branding
2. They generally require authentication
3. They lack data manipulation capabilities