.

▎Web Development and Database Administration MCQs

1. What does SQL stand for?

• A) Structured Query Language

• B) Simple Query Language

• C) Standard Query Language

• D) Sequential Query Language

2. Which of the following is a relational database management system?

• A) MongoDB

• B) MySQL

• C) Reid’s

• D) Cassandra

3. Which SQL command is used to remove a table from a database?

• A) DELETE

• B) DROP

• C) REMOVE
• D) TRUNCATE

4. What is the purpose of the ‘JOIN’ clause in SQL?

• A) To combine rows from two or more tables

• B) To update data in a table

• C) To delete data from a table

• D) To create a new table

5. In which of the following scenarios would you use a NoSQL database?

• A) When you need complex transactions

• B) When handling large volumes of unstructured data

• C) When using SQL queries

• D) When data integrity is critical

6. Which of the following is NOT a type of SQL JOIN?

• A) INNER JOIN

• B) OUTER JOIN

• C) CROSS JOIN

• D) LEFT JOIN

7. What does CRUD stand for in database management?

• A) Create, Read, Update, Delete

• B) Create, Retrieve, Update, Delete

• C) Create, Read, Upload, Delete

• D) Create, Read, Update, Download

8. Which command is used to add new records to a table?

• A) ADD

• B) INSERT INTO

• C) UPDATE

• D) CREATE

9. What is normalization in databases?

• A) The process of organizing data to reduce redundancy

• B) The process of backing up data

• C) The process of encrypting data

• D) The process of querying data

10. Which of the following is a common web server software?

• A) MySQL

• B) Apache HTTP Server

• C) MongoDB

• D) Reid’s

11. What is the default port number for MySQL?

• A) 3306

• B) 5432

• C) 8080

• D) 1521

12. Which of the following languages is primarily used for styling web
pages?

• A) HTML

• B) JavaScript

• C) CSS

• D) PHP

13. What does the acronym API stand for?

• A) Application Programming Interface

• B) Application Program Interface

• C) Application Protocol Interface

• D) Application Programming Interaction

14. Which SQL function is used to count the number of rows in a

table?
• A) COUNT()

• B) SUM()

• C) TOTAL()

• D) NUM()

15. What is the primary purpose of an index in a database?

• A) To increase data redundancy

• B) To speed up query performance

• C) To ensure data integrity

• D) To store large amounts of data

16. Which type of database model uses documents to store data?

• A) Relational model

• B) Document model

• C) Graph model

• D) Key-value model

17. Which of the following is NOT a type of NoSQL database?

• A) Document store

• B) Column family store

• C) Object-relational store
• D) Key-value store

18. What does the term ‘foreign key’ refer to in a database?

• A) A key that is used to encrypt data

• B) A key that links two tables together

• C) A key that uniquely identifies a record within its own table

• D) A key that has no relation to other tables

19. Which of the following is an example of a front-end framework?

• A) Node.js

• B) Express.js

• C) React.js

• D) Django

20. What does ‘ACID’ stand for in database transactions?

• A) Atomicity, Consistency, Isolation, Durability

• B) Atomicity, Consistency, Integrity, Durability

• C) Accuracy, Consistency, Isolation, Durability

• D) Atomicity, Control, Isolation, Durability

21. Which SQL statement is used to modify existing records in a

table?

• A) MODIFY

• B) UPDATE

• C) CHANGE

• D) ALTER

22. What is the purpose of the ‘WHERE’ clause in SQL?

• A) To define the structure of a table

• B) To filter records based on specified conditions

• C) To join multiple tables together

• D) To sort records in ascending order

23. Which HTML tag is used to define an internal style sheet?

• A) <style>

• B) <css>

• C) <script>

• D) <link>

24. In which scenario would you typically use a stored procedure?

• A) For simple queries that run infrequently

• B) For complex business logic that requires multiple SQL statements

• C) For retrieving static HTML content

• D) For creating new tables

25. What does JSON stand for?

• A) JavaScript Object Notation

• B) Java Standard Object Notation

• C) JavaScript Object Name

• D) Java Standard Object Name

26. Which of the following is an example of a back-end programming

language?

• A) HTML

• B) CSS

• C) JavaScript

• D) Python

27. What does the term ‘data integrity’ refer to?

• A) The accuracy and consistency of data over its lifecycle

• B) The speed at which data can be accessed and processed

• C) The amount of storage space allocated for data

• D) The method used to back up data

28. Which SQL clause is used to sort results returned by a query?

• A) ORDER BY

• B) SORT BY

• C) GROUP BY

• D) FILTER BY

29. What is the purpose of using transactions in databases?

• A) To ensure that all operations are completed successfully or none at all

• B) To speed up query performance

• C) To create backups of the database

• D) To handle user permissions

 30. Which command is used to create a new database in SQL?

• A) NEW DATABASE

• B) CREATE DATABASE

• C) ADD DATABASE

• D) MAKE DATABASE

31. What does the term ‘scalability’ mean in the context of

databases?

• A) The ability to maintain data integrity

• B) The ability to handle growing amounts of work or an expanding

database

• C) The ability to back up data efficiently

• D) The ability to encrypt sensitive information

32. Which of the following describes a primary key in a database?

• A) It can contain duplicate values.

• B) It uniquely identifies each record in a table.

• C) It can be null.

• D) It is optional for each table.

33. What does ‘ORM’ stand for in web development?

• A) Object-Relational Mapping

• B) Online Resource Management

• C) Open Resource Model

• D) Object Representation Model

34. Which SQL statement is used to retrieve data from a database?

• A) GET

• B) SELECT

• C) FETCH
• D) RETRIEVE

35. What is the main function of a web server?

• A) To store databases

• B) To serve web pages to clients

• C) To manage user authentication

• D) To create web applications

36. Which protocol is commonly used for transferring files over the
internet?

• A) HTTP

• B) FTP

• C) SMTP

• D) SNMP
 37. What is the purpose of using indexes in databases?

• A) To increase redundancy

• B) To improve query performance

• C) To secure sensitive data

• D) To store images and files

38. In web development, what does ‘responsive design’ refer to?

• A) Designing websites that are secure

• B) Designing websites that adjust to different screen sizes

• C) Designing websites that load quickly

• D) Designing websites that use minimal code

39. What is the purpose of the ‘GROUP BY’ clause in SQL?

• A) To filter records based on conditions

• B) To combine rows that have the same values in specified columns

• C) To sort records in descending order

• D) To create new tables from existing ones

40. Which of the following is NOT a characteristic of relational

databases?
– A) Data organized in tables
– B) Support for complex queries
– C) Use of foreign keys
– D) Data stored as key-value pairs

41. Which language is primarily used for scripting on web pages?

A)** HTML

B)** CSS

C)** JavaScript

D)** PHP

42. What does ‘demoralization’ mean in database design?

A)** Reducing redundancy by splitting tables

B)** Combining tables to improve performance

C)** Encrypting sensitive information

D)** Backing up data

43. Which command would you use to change an existing column in

a table?

A)** CHANGE COLUMN

B)** MODIFY COLUMN

 C)** ALTER TABLE

D)** UPDATE COLUMN

44. What type of relationship exists when one record in a table

relates to many records in another table?

A)** One-to-One

B)** One-to-Many

C)** Many-to-One

D)** Many-to-Many

45. Which technology allows web applications to communicate with

databases asynchronously?

A)** AJAX

B)** HTML5

C)** CSS3

D)** XML

46. What does ‘data warehousing’ refer to?

A)** Storing data for immediate use

B)** Collecting and managing large amounts of historical data for

analysis

C)** Backing up data regularly

D)** Encrypting sensitive information for security purposes

 47. In which scenario would you typically use a view in SQL?

A)** For storing raw data

B)** For simplifying complex queries and presenting them as virtual

tables

C)** For backing up tables

D)** For enforcing data integrity rules

48. Which tool can be used for version control in web development
projects?

A)** GitHub

B)** MySQL Workbench

C)** Apache Tomcat

D)** Visual Studio Code

49. What does ‘load balancing’ mean in web architecture?

A)** Distributing network traffic across multiple servers to ensure

reliability and performance

B)** Storing backups on multiple devices for security purposes

C)** Encrypting sensitive information during transmission

D)** Reducing file sizes for faster loading times

50. What does ‘cloud computing’ refer to in modern web

development?

A)** Using local servers only for hosting applications

B)** Storing and accessing data and applications over the internet instead
of local servers

C)** Developing applications without any internet connection

D)** Creating static websites only