Database Concepts MCQs 2026

45 questions with detailed answers · 16 from past papers · 5 quiz batches available

📚 Computer Mcqs 📄 16 Past-Paper Qs ✓ Free · No Login Needed

Read each question, think about the answer, then click Show Answer to reveal the correct option and explanation. Load 10 at a time so it stays manageable — perfect for one-topic study sessions on the bus or during a break.

Page 1 of 1 Questions 1–10 of 45

Q1 hard

The number of columns (attributes) in a table is called its
1. A Cardinality
2. B Tuple
3. C Schema
4. D Degree
💡 Explanation:
The degree of a table is its number of columns or attributes.
Q2 medium

Data about data is known as
1. A Redundant data
2. B Backup
3. C Metadata
4. D Query
💡 Explanation:
Metadata is data that describes other data.
Q3 easy

Which of the following is NOT a valid SQL command
1. A SELECT
2. B DISPLAY
3. C INSERT
4. D UPDATE
💡 Explanation:
DISPLAY is not a valid SQL command; SELECT, INSERT and UPDATE are.
Q4 easy

In a database, "field" and "column" mean the
1. A Same thing
2. B Opposite thing
3. C Two different tables
4. D Two records
💡 Explanation:
The terms field and column refer to the same thing in a table.
Q5 hard

A candidate key not chosen as the primary key is called a/an
1. A Foreign key
2. B Composite key
3. C Super key
4. D Alternate key
💡 Explanation:
A candidate key not selected as the primary key is called an alternate key.
Q6 medium

Which SQL clause is used to sort query results
1. A WHERE
2. B GROUP BY
3. C ORDER BY
4. D HAVING
💡 Explanation:
The ORDER BY clause sorts the results of a query.
Q7 medium

The WHERE clause in SQL is used to
1. A Sort data
2. B Filter rows based on a condition
3. C Delete a table
4. D Create a database
💡 Explanation:
The WHERE clause filters rows that meet a specified condition.
Q8 easy

A collection of fields that describe one item is called a
1. A Record
2. B Column
3. C Key
4. D Query
💡 Explanation:
A record is a collection of related fields describing one item.
Q9 Past Paper · PPSC/FPSC/NTS easy

The person who manages and maintains a database is called a
1. A Programmer
2. B User
3. C Analyst
4. D Database Administrator (DBA)
💡 Explanation:
A Database Administrator (DBA) manages and maintains databases.
Q10 hard

In a table, the number of rows is called its
1. A Degree
2. B Attribute
3. C Cardinality
4. D Schema
💡 Explanation:
Cardinality is the number of rows (records) in a table.
Q11 easy

MySQL is an example of a/an
1. A Word processor
2. B Relational database
3. C Spreadsheet
4. D Web browser
💡 Explanation:
MySQL is a popular open-source relational database.
Q12 medium

A virtual table based on the result of a query is called a
1. A View
2. B Index
3. C Schema
4. D Form
💡 Explanation:
A view is a virtual table derived from the result of a query.
Q13 medium

Which command permanently deletes an entire table structure
1. A DELETE
2. B SELECT
3. C UPDATE
4. D DROP
💡 Explanation:
The DROP command permanently removes an entire table and its structure.
Q14 easy

The smallest unit of a table that holds a single value is a
1. A Record
2. B Table
3. C Field
4. D Row
💡 Explanation:
A field holds a single data value at the intersection of a row and column.
Q15 easy

Oracle database software is developed by
1. A Oracle Corporation
2. B Microsoft
3. C Google
4. D IBM
💡 Explanation:
Oracle database is developed by Oracle Corporation.
Q16 medium

Which of the following is a NoSQL database
1. A MySQL
2. B Oracle
3. C MS Access
4. D MongoDB
💡 Explanation:
MongoDB is a NoSQL (non-relational) database.
Q17 Past Paper · PPSC/FPSC/NTS easy

DBMS stands for
1. A Data Basic Management System
2. B Database Management System
3. C Data Backup Management System
4. D Digital Base Management System
💡 Explanation:
DBMS stands for Database Management System, software to manage databases.
Q18 easy

A collection of related data stored together is called a
1. A Query
2. B Report
3. C Form
4. D Database
💡 Explanation:
A database is an organized collection of related data.
Q19 Past Paper · PPSC/FPSC/NTS easy

In a relational database, data is stored in
1. A Tables
2. B Folders
3. C Files
4. D Graphs
💡 Explanation:
Relational databases store data in tables made of rows and columns.
Q20 Past Paper · PPSC/FPSC/NTS easy

RDBMS stands for
1. A Rapid Database Management System
2. B Relational Data Backup Management System
3. C Relational Database Management System
4. D Remote Database Management System
💡 Explanation:
RDBMS stands for Relational Database Management System.
Q21 Past Paper · PPSC/FPSC/NTS easy

A single row in a table is also called a
1. A Field
2. B Record
3. C Column
4. D Attribute
💡 Explanation:
A row in a table is also called a record or tuple.
Q22 Past Paper · PPSC/FPSC/NTS easy

A single column in a table is also called a
1. A Record
2. B Row
3. C Tuple
4. D Field
💡 Explanation:
A column in a table is also called a field or attribute.
Q23 Past Paper · PPSC/FPSC/NTS medium

A key that uniquely identifies each record in a table is the
1. A Primary key
2. B Foreign key
3. C Candidate key
4. D Composite key
💡 Explanation:
A primary key uniquely identifies each record in a table.
Q24 Past Paper · PPSC/FPSC/NTS medium

A field that links one table to another by referencing its primary key is a
1. A Primary key
2. B Candidate key
3. C Foreign key
4. D Super key
💡 Explanation:
A foreign key references the primary key of another table to link them.
Q25 Past Paper · PPSC/FPSC/NTS medium

The primary key of a table cannot contain
1. A Numbers
2. B NULL or duplicate values
3. C Text
4. D Dates
💡 Explanation:
A primary key must be unique and cannot contain NULL or duplicate values.
Q26 Past Paper · PPSC/FPSC/NTS easy

SQL stands for
1. A Sequential Query Language
2. B Structured Question Language
3. C System Query Language
4. D Structured Query Language
💡 Explanation:
SQL stands for Structured Query Language, used to manage relational databases.
Q27 Past Paper · PPSC/FPSC/NTS easy

Which SQL command is used to retrieve data from a database
1. A SELECT
2. B INSERT
3. C DELETE
4. D UPDATE
💡 Explanation:
The SELECT command retrieves data from a database.
Q28 easy

Which SQL command is used to add new records to a table
1. A SELECT
2. B UPDATE
3. C INSERT
4. D DROP
💡 Explanation:
The INSERT command adds new records to a table.
Q29 easy

Which SQL command is used to remove records from a table
1. A SELECT
2. B DELETE
3. C CREATE
4. D ALTER
💡 Explanation:
The DELETE command removes records from a table.
Q30 easy

Which SQL command modifies existing records
1. A SELECT
2. B DELETE
3. C DROP
4. D UPDATE
💡 Explanation:
The UPDATE command modifies existing records in a table.
Q31 medium

Commands like CREATE, ALTER and DROP belong to which category
1. A DDL
2. B DML
3. C DCL
4. D TCL
💡 Explanation:
CREATE, ALTER and DROP are Data Definition Language (DDL) commands.
Q32 medium

Commands like SELECT, INSERT and UPDATE belong to which category
1. A DDL
2. B DCL
3. C DML
4. D TCL
💡 Explanation:
SELECT, INSERT and UPDATE are Data Manipulation Language (DML) commands.
Q33 Past Paper · PPSC/FPSC/NTS medium

The process of organizing data to reduce redundancy is called
1. A Indexing
2. B Normalization
3. C Querying
4. D Encryption
💡 Explanation:
Normalization organizes data to reduce redundancy and improve integrity.
Q34 medium

Duplicate or repeated data in a database is called data
1. A Integrity
2. B Query
3. C Schema
4. D Redundancy
💡 Explanation:
Data redundancy is the unnecessary duplication of data in a database.
Q35 Past Paper · PPSC/FPSC/NTS easy

Which of the following is a relational database software
1. A Oracle
2. B MS Word
3. C PowerPoint
4. D Photoshop
💡 Explanation:
Oracle is a relational database management system.
Q36 Past Paper · PPSC/FPSC/NTS easy

Microsoft's desktop database program included in Office is
1. A MS Word
2. B MS Excel
3. C MS Access
4. D MS Outlook
💡 Explanation:
MS Access is Microsoft's desktop database application in the Office suite.
Q37 medium

A real-world object represented in a database is called a/an
1. A Attribute
2. B Entity
3. C Query
4. D Index
💡 Explanation:
An entity is a real-world object represented in a database.
Q38 Past Paper · PPSC/FPSC/NTS medium

An ER diagram is used to represent
1. A Only reports
2. B Only queries
3. C Data types
4. D Entities and their relationships
💡 Explanation:
An Entity-Relationship (ER) diagram shows entities and their relationships.
Q39 medium

A structure that speeds up data retrieval from a table is a/an
1. A Index
2. B Form
3. C Report
4. D Macro
💡 Explanation:
An index speeds up data retrieval from a database table.
Q40 easy

A request made to a database to retrieve specific information is called a
1. A Record
2. B Field
3. C Query
4. D Schema
💡 Explanation:
A query is a request to retrieve or manipulate data in a database.
Q41 Past Paper · PPSC/FPSC/NTS medium

The overall structure or design of a database is called its
1. A Query
2. B Schema
3. C Record
4. D Tuple
💡 Explanation:
A schema defines the overall structure and design of a database.
Q42 medium

The accuracy and consistency of data in a database is called data
1. A Redundancy
2. B Query
3. C Schema
4. D Integrity
💡 Explanation:
Data integrity refers to the accuracy and consistency of stored data.
Q43 medium

A key made up of two or more columns is called a
1. A Composite key
2. B Foreign key
3. C Simple key
4. D Primary key
💡 Explanation:
A composite key is made up of two or more columns to identify a record.
Q44 medium

In database terminology, a tuple refers to a
1. A Column
2. B Table
3. C Row
4. D Key
💡 Explanation:
A tuple is another name for a row in a relational table.
Q45 medium

In database terminology, an attribute refers to a
1. A Row
2. B Column
3. C Table
4. D Key
💡 Explanation:
An attribute is another name for a column in a relational table.

Jump to page:

Database Concepts MCQs 2026

More Computer Mcqs Topics