Sarkari JobsTest Prep
Download App

Database Concepts MCQs 2026

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

📚 Computer📄 16 Past-Paper Qs✓ Free · No Login Needed
🎯 Mock Test

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 1Questions 1–10 of 45
  1. Q1hard

    A candidate key not chosen as the primary key is called a/an

    1. AForeign key
    2. BComposite key
    3. CSuper key
    4. DAlternate key
    💡 Explanation:

    A candidate key not selected as the primary key is called an alternate key.

  2. Q2Past Paper · PPSC/FPSC/NTSeasy

    DBMS stands for

    1. AData Basic Management System
    2. BDatabase Management System
    3. CData Backup Management System
    4. DDigital Base Management System
    💡 Explanation:

    DBMS stands for Database Management System, software to manage databases.

  3. Q3easy

    A collection of related data stored together is called a

    1. AQuery
    2. BReport
    3. CForm
    4. DDatabase
    💡 Explanation:

    A database is an organized collection of related data.

  4. Q4Past Paper · PPSC/FPSC/NTSeasy

    In a relational database, data is stored in

    1. ATables
    2. BFolders
    3. CFiles
    4. DGraphs
    💡 Explanation:

    Relational databases store data in tables made of rows and columns.

  5. Q5Past Paper · PPSC/FPSC/NTSeasy

    RDBMS stands for

    1. ARapid Database Management System
    2. BRelational Data Backup Management System
    3. CRelational Database Management System
    4. DRemote Database Management System
    💡 Explanation:

    RDBMS stands for Relational Database Management System.

  6. Q6Past Paper · PPSC/FPSC/NTSeasy

    A single row in a table is also called a

    1. AField
    2. BRecord
    3. CColumn
    4. DAttribute
    💡 Explanation:

    A row in a table is also called a record or tuple.

  7. Q7Past Paper · PPSC/FPSC/NTSeasy

    A single column in a table is also called a

    1. ARecord
    2. BRow
    3. CTuple
    4. DField
    💡 Explanation:

    A column in a table is also called a field or attribute.

  8. Q8Past Paper · PPSC/FPSC/NTSmedium

    A key that uniquely identifies each record in a table is the

    1. APrimary key
    2. BForeign key
    3. CCandidate key
    4. DComposite key
    💡 Explanation:

    A primary key uniquely identifies each record in a table.

  9. Q9Past Paper · PPSC/FPSC/NTSmedium

    A field that links one table to another by referencing its primary key is a

    1. APrimary key
    2. BCandidate key
    3. CForeign key
    4. DSuper key
    💡 Explanation:

    A foreign key references the primary key of another table to link them.

  10. Q10Past Paper · PPSC/FPSC/NTSmedium

    The primary key of a table cannot contain

    1. ANumbers
    2. BNULL or duplicate values
    3. CText
    4. DDates
    💡 Explanation:

    A primary key must be unique and cannot contain NULL or duplicate values.

  11. Q11Past Paper · PPSC/FPSC/NTSeasy

    SQL stands for

    1. ASequential Query Language
    2. BStructured Question Language
    3. CSystem Query Language
    4. DStructured Query Language
    💡 Explanation:

    SQL stands for Structured Query Language, used to manage relational databases.

  12. Q12Past Paper · PPSC/FPSC/NTSeasy

    Which SQL command is used to retrieve data from a database

    1. ASELECT
    2. BINSERT
    3. CDELETE
    4. DUPDATE
    💡 Explanation:

    The SELECT command retrieves data from a database.

  13. Q13easy

    Which SQL command is used to add new records to a table

    1. ASELECT
    2. BUPDATE
    3. CINSERT
    4. DDROP
    💡 Explanation:

    The INSERT command adds new records to a table.

  14. Q14easy

    Which SQL command is used to remove records from a table

    1. ASELECT
    2. BDELETE
    3. CCREATE
    4. DALTER
    💡 Explanation:

    The DELETE command removes records from a table.

  15. Q15easy

    Which SQL command modifies existing records

    1. ASELECT
    2. BDELETE
    3. CDROP
    4. DUPDATE
    💡 Explanation:

    The UPDATE command modifies existing records in a table.

  16. Q16medium

    Commands like CREATE, ALTER and DROP belong to which category

    1. ADDL
    2. BDML
    3. CDCL
    4. DTCL
    💡 Explanation:

    CREATE, ALTER and DROP are Data Definition Language (DDL) commands.

  17. Q17medium

    Commands like SELECT, INSERT and UPDATE belong to which category

    1. ADDL
    2. BDCL
    3. CDML
    4. DTCL
    💡 Explanation:

    SELECT, INSERT and UPDATE are Data Manipulation Language (DML) commands.

  18. Q18Past Paper · PPSC/FPSC/NTSmedium

    The process of organizing data to reduce redundancy is called

    1. AIndexing
    2. BNormalization
    3. CQuerying
    4. DEncryption
    💡 Explanation:

    Normalization organizes data to reduce redundancy and improve integrity.

  19. Q19medium

    Duplicate or repeated data in a database is called data

    1. AIntegrity
    2. BQuery
    3. CSchema
    4. DRedundancy
    💡 Explanation:

    Data redundancy is the unnecessary duplication of data in a database.

  20. Q20Past Paper · PPSC/FPSC/NTSeasy

    Which of the following is a relational database software

    1. AOracle
    2. BMS Word
    3. CPowerPoint
    4. DPhotoshop
    💡 Explanation:

    Oracle is a relational database management system.

  21. Q21Past Paper · PPSC/FPSC/NTSeasy

    Microsoft's desktop database program included in Office is

    1. AMS Word
    2. BMS Excel
    3. CMS Access
    4. DMS Outlook
    💡 Explanation:

    MS Access is Microsoft's desktop database application in the Office suite.

  22. Q22medium

    A real-world object represented in a database is called a/an

    1. AAttribute
    2. BEntity
    3. CQuery
    4. DIndex
    💡 Explanation:

    An entity is a real-world object represented in a database.

  23. Q23Past Paper · PPSC/FPSC/NTSmedium

    An ER diagram is used to represent

    1. AOnly reports
    2. BOnly queries
    3. CData types
    4. DEntities and their relationships
    💡 Explanation:

    An Entity-Relationship (ER) diagram shows entities and their relationships.

  24. Q24medium

    A structure that speeds up data retrieval from a table is a/an

    1. AIndex
    2. BForm
    3. CReport
    4. DMacro
    💡 Explanation:

    An index speeds up data retrieval from a database table.

  25. Q25easy

    A request made to a database to retrieve specific information is called a

    1. ARecord
    2. BField
    3. CQuery
    4. DSchema
    💡 Explanation:

    A query is a request to retrieve or manipulate data in a database.

  26. Q26Past Paper · PPSC/FPSC/NTSmedium

    The overall structure or design of a database is called its

    1. AQuery
    2. BSchema
    3. CRecord
    4. DTuple
    💡 Explanation:

    A schema defines the overall structure and design of a database.

  27. Q27medium

    The accuracy and consistency of data in a database is called data

    1. ARedundancy
    2. BQuery
    3. CSchema
    4. DIntegrity
    💡 Explanation:

    Data integrity refers to the accuracy and consistency of stored data.

  28. Q28medium

    A key made up of two or more columns is called a

    1. AComposite key
    2. BForeign key
    3. CSimple key
    4. DPrimary key
    💡 Explanation:

    A composite key is made up of two or more columns to identify a record.

  29. Q29medium

    In database terminology, a tuple refers to a

    1. AColumn
    2. BTable
    3. CRow
    4. DKey
    💡 Explanation:

    A tuple is another name for a row in a relational table.

  30. Q30medium

    In database terminology, an attribute refers to a

    1. ARow
    2. BColumn
    3. CTable
    4. DKey
    💡 Explanation:

    An attribute is another name for a column in a relational table.

  31. Q31medium

    Which of the following is a NoSQL database

    1. AMySQL
    2. BOracle
    3. CMS Access
    4. DMongoDB
    💡 Explanation:

    MongoDB is a NoSQL (non-relational) database.

  32. Q32easy

    Oracle database software is developed by

    1. AOracle Corporation
    2. BMicrosoft
    3. CGoogle
    4. DIBM
    💡 Explanation:

    Oracle database is developed by Oracle Corporation.

  33. Q33easy

    The smallest unit of a table that holds a single value is a

    1. ARecord
    2. BTable
    3. CField
    4. DRow
    💡 Explanation:

    A field holds a single data value at the intersection of a row and column.

  34. Q34medium

    Which command permanently deletes an entire table structure

    1. ADELETE
    2. BSELECT
    3. CUPDATE
    4. DDROP
    💡 Explanation:

    The DROP command permanently removes an entire table and its structure.

  35. Q35medium

    A virtual table based on the result of a query is called a

    1. AView
    2. BIndex
    3. CSchema
    4. DForm
    💡 Explanation:

    A view is a virtual table derived from the result of a query.

  36. Q36easy

    MySQL is an example of a/an

    1. AWord processor
    2. BRelational database
    3. CSpreadsheet
    4. DWeb browser
    💡 Explanation:

    MySQL is a popular open-source relational database.

  37. Q37hard

    In a table, the number of rows is called its

    1. ADegree
    2. BAttribute
    3. CCardinality
    4. DSchema
    💡 Explanation:

    Cardinality is the number of rows (records) in a table.

  38. Q38Past Paper · PPSC/FPSC/NTSeasy

    The person who manages and maintains a database is called a

    1. AProgrammer
    2. BUser
    3. CAnalyst
    4. DDatabase Administrator (DBA)
    💡 Explanation:

    A Database Administrator (DBA) manages and maintains databases.

  39. Q39easy

    A collection of fields that describe one item is called a

    1. ARecord
    2. BColumn
    3. CKey
    4. DQuery
    💡 Explanation:

    A record is a collection of related fields describing one item.

  40. Q40medium

    The WHERE clause in SQL is used to

    1. ASort data
    2. BFilter rows based on a condition
    3. CDelete a table
    4. DCreate a database
    💡 Explanation:

    The WHERE clause filters rows that meet a specified condition.

  41. Q41medium

    Which SQL clause is used to sort query results

    1. AWHERE
    2. BGROUP BY
    3. CORDER BY
    4. DHAVING
    💡 Explanation:

    The ORDER BY clause sorts the results of a query.

  42. Q42easy

    In a database, "field" and "column" mean the

    1. ASame thing
    2. BOpposite thing
    3. CTwo different tables
    4. DTwo records
    💡 Explanation:

    The terms field and column refer to the same thing in a table.

  43. Q43easy

    Which of the following is NOT a valid SQL command

    1. ASELECT
    2. BDISPLAY
    3. CINSERT
    4. DUPDATE
    💡 Explanation:

    DISPLAY is not a valid SQL command; SELECT, INSERT and UPDATE are.

  44. Q44medium

    Data about data is known as

    1. ARedundant data
    2. BBackup
    3. CMetadata
    4. DQuery
    💡 Explanation:

    Metadata is data that describes other data.

  45. Q45hard

    The number of columns (attributes) in a table is called its

    1. ACardinality
    2. BTuple
    3. CSchema
    4. DDegree
    💡 Explanation:

    The degree of a table is its number of columns or attributes.

More Computer Topics

📖
Computer Fundamentals & Introduction45 MCQs
→📖
Generations & History of Computers45 MCQs
→📖
Input & Output Devices45 MCQs
→📖
CPU, Memory & Storage45 MCQs
→📖
Operating Systems45 MCQs
→📖
MS Word45 MCQs
→

See all Computer topics →

Get instant alerts & apply faster — install the free appInstall App