Basic Databases MCQs – T4Tutorials.com

What is a database?
- A) A collection of web pages
- B) A collection of data organized in a manner that allows access, retrieval, and use of that data
- C) A type of software for video editing
- D) A programming language
- Answer: B) A collection of data organized in a manner that allows access, retrieval, and use of that data
Which of the following is a type of database management system (DBMS)?
- A) Oracle
- B) Microsoft Excel
- C) Adobe Photoshop
- D) Mozilla Firefox
- Answer: A) Oracle
Which language is commonly used for querying and managing databases?
- A) HTML
- B) SQL
- C) Python
- D) Java
- Answer: B) SQL
What does SQL stand for?
- A) Simple Query Language
- B) Structured Query Language
- C) Sequential Query Language
- D) Standard Query Language
- Answer: B) Structured Query Language
Which of the following is an example of a relational database management system (RDBMS)?
- A) MongoDB
- B) MySQL
- C) Redis
- D) Cassandra
- Answer: B) MySQL

What is a primary key in a database?
- A) A key used to open the database
- B) A unique identifier for a record in a table
- C) A duplicate value in a table
- D) A tool for encrypting the database
- Answer: B) A unique identifier for a record in a table

What is a foreign key?
- A) A key that is not from the same country
- B) A key that uniquely identifies records in a different table
- C) A key used to encrypt data
- D) A primary key used in a sub-table
- Answer: B) A key that uniquely identifies records in a different table
What is a table in a database?
- A) A physical table where computers are placed
- B) A collection of related data entries organized in rows and columns
- C) A graphical representation of data
- D) A software used for data analysis
- Answer: B) A collection of related data entries organized in rows and columns
What does CRUD stand for in database operations?
- A) Create, Read, Update, Delete
- B) Create, Replace, Update, Delete
- C) Compile, Run, Update, Delete
- D) Create, Read, Undo, Delete
- Answer: A) Create, Read, Update, Delete
What is normalization in database design?
- A) The process of storing data in multiple locations
- B) The process of organizing data to minimize redundancy
- C) The process of encrypting data
- D) The process of backing up data
- Answer: B) The process of organizing data to minimize redundancy

What is a join operation in SQL?
- A) A command to create a new table
- B) A query to combine rows from two or more tables based on a related column
- C) A command to delete a table
- D) A query to sort data in ascending order
- Answer: B) A query to combine rows from two or more tables based on a related column
Which SQL clause is used to filter records in a result set?
- A) WHERE
- B) SELECT
- C) GROUP BY
- D) ORDER BY
- Answer: A) WHERE
What is an index in a database?
- A) A type of table
- B) A data structure that improves the speed of data retrieval operations
- C) A method for encrypting data
- D) A command for deleting data
- Answer: B) A data structure that improves the speed of data retrieval operations
What is a stored procedure?
- A) A precompiled set of one or more SQL statements stored in the database
- B) A procedure to store files in the database
- C) A command to back up the database
- D) A method to delete data
- Answer: A) A precompiled set of one or more SQL statements stored in the database
What is the purpose of the GROUP BY clause in SQL?
- A) To filter records
- B) To sort records
- C) To aggregate data based on one or more columns
- D) To update records
- Answer: C) To aggregate data based on one or more columns

Basic Databases MCQs
By: Prof. Dr. Fazal Rehman Shamil | Last updated: July 20, 2024