Free Databases MCQs with Answers
210 Databases MCQs from Computer Science and IT, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.
Databases cover tables, records, fields, keys and relationships, together with database management systems and relational database design. The subject includes primary and foreign keys, normalization, SQL commands such as SELECT, INSERT, UPDATE and DELETE, queries, forms and reports, while distinguishing a database from a spreadsheet used for simple tabular data.
Last updated
210 questions · page 1 of 11
- A. Stores the largest value in the table
- B. Uniquely identifies each record in a table
- C. Links two databases together
- D. Encrypts the contents of a table
Explanation: A primary key uniquely identifies every record in a table and cannot contain duplicate or null values.
Correct answer: Uniquely identifies each record in a table- A. Attributes
- B. Index
- C. Entity
- D. Relation
Explanation: A column represents an attribute, such as StudentName or DateOfBirth, while a row represents one entity or record.
Correct answer: Attributes- A. Intension
- B. Extension
- C. Back up
- D. Application
Explanation: An extension is the collection of records stored in a database at a particular time, also called the database state or instance.
Correct answer: Extension- A. File
- B. Recordset
- C. Database
- D. document
Explanation: A database is an organized collection of related data designed for efficient access, retrieval and use.
Correct answer: Database- A. Straight Query Langauge
- B. Structured Query Langauge
- C. Structured Query Laison
- D. Structured Query Linear
Explanation: SQL means Structured Query Language, the standard language used to define, query and manipulate relational databases.
Correct answer: Structured Query Langauge- A. Presentation
- B. Documentation
- C. Calculation
- D. Data Base
Explanation: MS Access is a relational database management program used to create tables, queries, forms, and reports.
Correct answer: Data Base- A. Data definition language
- B. Data manipulation language
- C. Data control language
- D. All of the above
Explanation: SQL includes data definition commands such as CREATE, data manipulation commands such as SELECT and UPDATE, and data control commands such…
Correct answer: All of the above- A. Database management system
- B. Database maintaince system
- C. Database maintaince and storage
- D. Database management Sound
Explanation: DBMS stands for Database Management System, software that creates, stores, organizes, and controls access to databases.
Correct answer: Database management system- A. Operating System File
- B. Transaction file
- C. Software File
- D. Master file
Explanation: A master file holds relatively permanent information, such as customer or account records, and is updated using transaction data.
Correct answer: Master file- A. Programmer
- B. Software tester
- C. System Analyst
- D. Database Administrator
Explanation: A Database Administrator (DBA) is a IT professional who is responsible for the design, implementation, maintenance, and security of…
Correct answer: Database Administrator- A. Report
- B. Query
- C. Table
- D. Form
Explanation: Report is correct. A report is a database object that is specifically designed to format, calculate, summarize, and present data from a…
Correct answer: Report- A. Fast Data Retrieval
- B. Security
- C. Efficient Storage
- D. All of these
Explanation: While each of the other options (Fast Data Retrieval, Security, and Efficient Storage) is an important factor to consider when choosing a…
Correct answer: All of these- A. Secondary key
- B. Foreign key
- C. Primary key
- D. All of these
Explanation: An index can be created on any of the following:• Primary key: A primary key uniquely identifies a row in a table.
Correct answer: All of these- A. Composite Primary Key
- B. Foreign Key
- C. Multi-value Key
- D. Compound Key
Explanation: A composite primary key is a primary key that consists of two or more attributes that uniquely identify a row in a table
Correct answer: Composite Primary Key- A. All of these
- B. Foreign key
- C. Primary key
- D. Alternate key
Explanation: • Foreign Key: A foreign key is a column or set of columns in one table that references the primary key of another table.
Correct answer: All of these- A. End user
- B. Data administrator
- C. Application programmer
- D. Database administrator
Explanation: A database administrator is a IT professional who is responsible for all aspects of a database system, including design, implementation…
Correct answer: Database administrator- A. Centralized
- B. Partitioned
- C. Hybrid
- D. Duplicated
Explanation: Duplication is not a basic data distribution strategy because it does not involve distributing data across multiple locations for…
Correct answer: Duplicated- A. Sort key
- B. Composite key
- C. Primary key
- D. Foreign key
Explanation: The text in the image appears to be incorrect. A control key is a special key on a computer keyboard that, when pressed in combination…
Correct answer: Foreign key- A. Sort Key
- B. Secondary Key
- C. Primary Key
- D. Control Key
Explanation: A primary key is a unique identifier for a row in a table. It is used to efficiently retrieve specific data records and enforce data…
Correct answer: Primary Key- A. Parent table
- B. Dependent table
- C. Pivot table
- D. Index table
Explanation: In a relational database, a foreign key is a column or set of columns in a table that references the primary key of another table.
Correct answer: Dependent tableDatabases MCQs: common questions
Are these Databases MCQs free?
Yes. All Databases MCQs from Computer Science and IT are free on TestUstad, with unlimited attempts and no account needed. Nothing on this page is a sample or a trial.
How many Databases MCQs are on this page?
There are 210 Databases MCQs in the Computer Science and IT bank, shown 20 to a page with the correct answer and an explanation on each.
Does every Databases MCQ have an explanation?
Yes. Each Databases question shows the correct option and a written explanation of why it is correct, so a wrong answer teaches you something rather than just being marked wrong.
Can I take a timed Databases test?
Yes. The practice button on this page starts a free Databases test drawn from the Computer Science and IT bank. It marks each answer instantly, gives you a score at the end, and can be retaken as many times as you like.