DBMS MCQs

15 MCQs  — Computer Programming MCQs  (Page 1 of 2)

Practice DBMS MCQs with correct answers and explanations. These questions are from the Computer Programming MCQs section.

Attempt DBMS MCQs Quiz
Computer Programming MCQs Subcategories
Algorithms & Data StructuresASP.net
ASP.net MCQsBasic computer knowledge
Basic of linux unixCharacteristics Windows Nt
Commercial Operating SystemsComputer Science MCQs
Data ManagementData Representation
Data Structure MCQsDatabases
DBMS MCQsDigital Computer Electronics
Electrical Engineering McqsFile System Free Space Performance
Floating Point AccuracyFunctions
Intro to ITJava concepts and its programming
Language processorsManagement Information System - MIS
Multitasking Operating SystemNetworking MCQs
Operating SystemOperating System (OS) MCQs
Programming MCQsSoftware Development MCQs
Software Engineering McqsTransmission and Distribution
Web Development MCQs
A rotational database consists of …….?
A. Tables
B. Fields
C. Records
D. Keys
Read more about this MCQ
A …… in a table represents a relationship among a set of values?
A. Column
B. Key
C. Row
D. Entry
Read more about this MCQ
The term …… is used to refer to a row?
A. Attribute
B. Tuple
C. Field
D. Instance
Read more about this MCQ
The term attribute refers to a ……. of a table?
A. Record
B. Column
C. Tuple
D. Key
Read more about this MCQ
Which of the following is a tuple-generating dependency?
A. Functional dependency
B. Equality-generating dependencies
C. Multi-valued dependencies
D. Non-functional dependency
Read more about this MCQ
The main task carried out in the ……. is to remove repeating attributes to separate tables?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
Read more about this MCQ
Which of the normal form is based on multi-valued dependencies?
A. First
B. Second
C. Third
D. Fourth
Read more about this MCQ
Which forms have a relation that possesses data about an individual entity?
A. 2nf
B. 3nf
C. 4nf
D. 5nf
Read more about this MCQ
Which of the following has each related entity set its own schema and there is an additional schema for the relationship set?
A. A many-to-many relationship set
B. A multi-valued attribute of an entity set
C. A one-to-many relationship set
D. Both a & b
Read more about this MCQ
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?
A. A many-to-many relationship set
B. A multi-valued attribute of an entity set
C. A one-to-many relationship set
D. Both a & b
Read more about this MCQ
Word of the Day
10 Jul
Spur
a thing that prompts or encourages someone; an incentive.
اکسانے والی بات، آر،مہمیز

MCQs Menu

General Knowledge MCQs16404
Pak Study MCQs11702
English MCQs9322
Chemical Engineering6108
Computer Programming MCQs5739
Everyday Science MCQs5120
Medical MCQs5099
Economics Mcqs4475
Political Science Mcqs4081
World Current Affairs MCQs3948
Civil Engineering MCQs2965
Islamiat MCQs2964
Judiciary And Law Mcqs2943
Basic Computer MCQs2872
Agriculture MCQs2794
Mechanical Engineering Mcqs2075
Psychology Mcqs2056
Mathematics MCQs1767
Marketing Mcqs1725
Accounting MCQs1590
Sociology Mcqs1528
Finance Mcqs1052
Operating System1019
Computer Networks1018
HRM Mcqs937
Physics852
Statistics Mcqs734
Forestry Mcqs729
Urdu MCQs683
International Relations599
Pedagogy Mcqs371
Chemical Heat Transfer212
Pakistan Current Affairs MCQs165
Process Equipment and Plant Design159
Election Officer Mcqs152
Petroleum Refinery Engineering147
Process Control and Instrumentation142
PERA Laws MCQs137
Ecology and General Silviculture132
Miscellaneous Psychology130
Chemical Reaction129
Wireless Mobile Communications124
Psychological Disorders and their Treatment112
Computer Network Management103
Health Education98
Stoichiometry98
World Geography94
Network Security94
Pakistan Studies93
FIA Act 197492
Pakistan Affairs86
Rules of Volleyball Game85
Nuclear Power Engineering83
Coordination78
Developmental Psychology76
Polymer Technology75
Educational Psychology74
Pak Affairs MCQs74
Religion68
Motivation58
Learning55
Chemistry54
Islamic Studies54
Personality52
Distributed Operating System49
Biological Foundations of Behaviour49
International Law47
Optical Communication40
Realtime Operating System39
Methods and Approaches37
General Science35
Network Security Interview34
Industrial Management33
Current Affairs32
Cognitive Psychology32
Major Thinkers in Psychology32
Historic Agreements, Pacts, Peace and Major Contracts31
Networking Fundamentals31
Computer Networks Interview29
History28
Cyber Security27
Conflict, War, and Terrorism26
Law MCQs26
Digital Communications26
International Organization, Law, and Human Rights24
Wireless Communication - Cognitive Radio24
Nervous System23
Industrial Psychology20
Basic Mathematics MCQs20
Criminal Psychology20
Disputed Barrages. Dams20
Liberal and Social Theories19
Math18
Tough Network Security18
Electronic Devices And Circuits16
PUNJAB LAND REVENUE ACT 1967 MCQs15
English15
Network Security Test/15
Network Security Online Test/15
Interpersonal Relations And Group Processes14
Clinical Psychology13
Language And Thought13
Network Security Quiz/13
Biochemistry MCQs12
Methodology12
Pharmaceutical Chemistry Mcqs12
Neural Networks11
Computer Networks Question Answers Basics/10
Computer Networks Questions Bank/10
Mathematics10
Network Security Questions Entrance Exams/10
Operating System Question Answers Multimedia Systems/10
Power Systems10
FIA Rules9
Network Security Questions Campus Interviews/9
Network Security Quiz Online/9
Network Security Aptitude Test/9
Network Security Assessment Questions/9
Environment and Technology9
Network Security Multiple Choice9
Mongodb9
Computer Networks Multiple Choice9
Network Security Puzzles/8
Network Security Question Bank/8
International Borders & Lines8
Network Engineering MCQs8
Tricky Network Security8
Organizational Psychology8
Computer8
Physical Education8
Current Affairs MCQs7
URDU GENERAL KNOWLEDGE7
Diplomacy7
Globalization and the Transformation of Political Community6
International and Global Security6
Horticulture MCQs6
International Regimes6
Photography Mcqs6
Soil Science5
Joints and their movements5
Poverty, Development, and Hunger5
Contemporary Mainstream Approaches. Neo-Realism and Neo-Liberalism5
Gender in World Politics5
Culture in World Affairs5
Globalization and the Post-Cold-war Order5
One Word Substitutes Mcqs4
Fill in the blanks Mcqs4
International Ethics4
Human Security4
Social Sciences4
Humanitarian Intervention in World Politics4
Poststructuralism3
Transnational Actors and International Organizations in Global Politics3
CONSTITUTIONAL HISTORY (CASES)3
Biotechnology Engineering MCQs3
Entomology3
Office Management MCQs2
Government & Law2
MOTORWAY POLICE2
Current Federal Ministers2
Civil Procedure 19082
Regionalism in International Affairs2
Current Provincial Ministers Balochistan2
Science2
Islamic Knowledge1
Quadratic Equations1
Namaz MCQs1
Current Presidents - Chairmen - CEOs1
Operating System Interview Questions/1
Commerce1
President of Countries1
HRMS1
Sensation And Perception1
Philosophy1
Microsoft Excel Mcqs1
Pak Current Affairs MCQs1
Vocabulary1
General Sports1
Direct And Indirect Speech Mcqs1
Current Affair MCQs1
Management Mcqs1
Software Engineering types1
Islamic History1

Past Papers

Archaeology & Tourism Department - 20191Archaeology & Tourism Department - 20191Assistant BOR1Assistant Controller-Morning 23-11-2024 (2024)1Assistant Director (HR and ADMIN) BS-17 (2025)1Assistant Director ASF (BS-17) Batch 01 (05-08-2024) (2024)1Assistant Director Fisheries (BS-17) (1-06-2025) (2025)1Assistant PESSI Held on 19-10-2025 (2025)2Assistant Sub Inspector BPS-11 (BATCH-1) 08-04-2025 (2025)1Assistant Superintendent / Deputy Superintendent Jail (GK) (2025)1Assistant) PPSC 25-08-2024 (2024)2Bio Medical Engineer (Labour & Resource) Held on 10-08-2024) (2024)3Chief Officer/Municipal Officer (Regulations) Local Government & Community Develop1Chief Officer/Municipal Officer (Regulations) Local Government & Community Development (Held on 11-08-2024) (2024)1Clubbed (27-04-2025) (2025)1Clubbed Case 74 – Assistant (BS-16) Various Departments – 2024 (2024)3Clubbed Case-76 (Evening) Held on 08-06-2024 (2024)2Clubbed Case-85 (Morning) Held on 08-06-2024 (2024)3Clubbed Case-91(Morning) Punjab Special Education Department (10-08-2024) (2024)2Clubbed Case-97 (Evening) Held on 13-07-2024 (2024)3Clubbed Case-Various Post(Labour Inspector/Officer2Clubbes Case 98 – Various Posts -2024 (2024)1Concept Academy Notes111Data Entry Operator (BS-12) (31-05-2025) (2025)2Educator (BS-16) Punjab Special Education Held on 13-07-2024 (2024)1FIA - Assistant - FIA - 20181FIA - Sub Inspector (Investigation) - FIA - 20181FIA ASI Test By VU on 13-12-20211FIA Assistant paper 14-12-20211FIA Past Paper Assistant/ASI/Inspector1FIA-Assistant / Inspector / ASI / UDC / LDC / Constable1FIA-Assistant Director / Inspector1FIA-Assistant Director / Inspector / Sub-Inspector / ASI / Clerk1FIA-Assistant/SI/ASI/UDC/LDC/Constable1FIA-FIA (All Posts) - Act Knowledge1FIA-Stenotypist1FIA-Sub Inspector1INSTRUCTOR/LECTURER (MALE) ENGLISH (BS-17) (2024)1Inspector (BS-16) Tourist Services (DTS)2Inspector Cooperative (Cooperative Department) Held on 10-08-2024 (2024)2Junior Clerk (BS-11) (1-06-2025) (2025)1Junior Clerk (Morning) Held on 14.12.2025 (2025)1Junior Clerk BOR Held on 20.12.2025 (2025)1Lecturer Punjabi (BS-17) (Special Education Department) Held on 13-07-2024 (2024)1Lecturer Urdu (Special Education Department) Held on 10-08-2024 (2024)3PMS Ministerial (13-04-2025) (2025)1PMS Ministerial Qouta 202536PPSC - ASSISTANT FOOD CONTROLLER (BS 15) 09J17J2022 - FOOD DEPARTMENT - 20232PPSC - ACCOUNTS OFFICER (BS 16) - FINANCE DEPARTMENT - 20111PPSC - ASI - Punjab Police (Service Quota) - 20193PPSC - ASSISTANT (BPS 14) - PPSC - 20151PPSC - ASSISTANT (BPS 16) - CLUBBED CASES - 20241PPSC - ASSISTANT (BPS 16) - PLANNING & DEVELOPMENT DEPARTMENT - 20162PPSC - ASSISTANT (BPS 16) - PPSC - 20161PPSC - ASSISTANT AUDIT & ACCOUNTS (BPS 14) - PUNJAB FINANCE DEPARTMENT - 20111PPSC - Accountant - Local Government & Community Development - 20201PPSC - Assistant (BS 16) - (PESS) Labour & Human Resource Department - 20201PPSC - Assistant (BS 16) - Board of Revenue - 20221PPSC - Assistant (BS 16) - Chief Minister Office Overseas Pakistanis -2PPSC - Assistant (BS 16) - Livestock & Dairy Development - 20201PPSC - Assistant (BS 16) - PPSC - 00002PPSC - Assistant (BS 16) - PPSC - 00011PPSC - Assistant (BS 16) - Punjab Public Service Commission (PPSC) - 00001PPSC - Assistant - Agricultural Department - 20181PPSC - Assistant - Agriculture Department - 20202PPSC - Assistant - Clubbed Cases Various Departments - 20244PPSC - Assistant - Disaster Management Department (Board of Revenue) - 20222PPSC - Assistant - Housing Urban Development & Public Health Engineering Department (Rawalpindi Region) - 20211PPSC - Assistant - Labour and Human Resource - 20192PPSC - Assistant - Lahore High Court (LHC) - 20195PPSC - Assistant - Planning & Development Punjab - 20194PPSC - Assistant - Population Welfare Department - 20192PPSC - Assistant - Provincial Disaster Management Authority (BOR) - 20212PPSC - Assistant - Punjab Police Department - 20202PPSC - Assistant - S&GAD Punjab - 00002PPSC - Assistant - Services and General Administration Department (S&GAD) - 00001PPSC - Assistant - Zakat & Usher Department - 20211PPSC - Assistant BS 16 - (Clubbed Cases) - 20232PPSC - Assistant BS 16 - (Clubbed Cases) - 20231PPSC - Assistant Director (Accounts) / Lecturer Psychology 14 Jul 2024 - Higher Education Department & Others - 20242PPSC - Assistant Director (Accounts) / Lecturer Psychology 14 Jul 2024 - Higher Education Department & Others - 20242PPSC - Assistant Director (BS 17) - Local Government Punjab - 20202PPSC - Assistant Director (BS 17) - Population Welfare Department - 20201PPSC - Assistant Director - Labour & Human Resource Department Punjab - 20193PPSC - Assistant Director - Local Govt & Community Development - 20183PPSC - Assistant Director - Planning & Development Department (P&D) - 20192PPSC - Assistant Director - Punjab Employees Social Security Institution (PESSI) - 20192PPSC - Assistant Protocol Officer - Directorate General Protocol - 00003PPSC - Assistant Sub Inspector (ASI) - Anti Corruption Department - 20202PPSC - Assistants / Head Clerk (BS 16) - Local Government - 20202PPSC - Caretaker (BS 14)- Lahore High Court - 20193PPSC - Caretaker- Lahore High Court (LHC) - 20191PPSC - Chief Officer / Municipal Officer (BS 16) (Regulations) 11/08/2024 (Morning) - Local Government & Community Development Department - 20242PPSC - Chief Officer / Municipal Officer (BS 16) (Regulations) 11/08/2024 (Morning) - Local Government & Community Development Department - 20241PPSC - Corporal - Counter Terrorism Department Punjab (BS 11) - 20241PPSC - DATA ENTRY OPERATOR (DEO) - PUNJAB POLICE DEPARTMENT - 20151PPSC - DATA ENTRY OPERATORS (DEO) - PUNJAB POLICE DEPARTMENT - 20151PPSC - Data Entry Operator (DEO) - Punjab Police - 20201PPSC - Deputy Accountant (BPS 14) - Punjab Treasuries Establishment under the Finance Department - 20121PPSC - Deputy Accountant (Evening) - Finance Department - 20191PPSC - Deputy Accountant (Evening) - Finance Department - 20192PPSC - Deputy Accountant (Morning) - Finance Department - 20191PPSC - Deputy Accountant (Morning) - Finance Department - 20193PPSC - Deputy Accountant - Finance Department - 20192PPSC - Divisional Coach - Youth Affairs2PPSC - EDUCATOR (BS 16) - PUNJAB SPECIAL EDUCATION DEPARTMENT - 20151PPSC - ESE General (Afternoon) - Labour & Human Resource Department - 20193PPSC - ESE General (Evening) - Labour & Human Resource Department - 20192PPSC - ESE General (Evening) - Labour & Human Resource Department - 20193PPSC - Educator (BS 16) - Education Department Punjab - 20242PPSC - Elementary School Educator (ESE) General - Labour & Human Resource Department - 20197PPSC - FOOD GRAIN SUPERVISOR (BS 09) - FOOD DEPARTMENT PUNJAB - 20234PPSC - FOOD GRAIN SUPERVISOR (BS 09) Paper 2 - FOOD DEPARTMENT - 20232PPSC - FOOD GRAINS INSPECTOR (BS 12) 18J26J2022 (30/04/2023) - FOOD DEPARTMENT - 20234PPSC - FOOD GRAINS INSPECTOR (BS 12) 18J26J2022 (30/04/2023) - FOOD DEPARTMENT - 20231PPSC - Field Assistant - Agriculture Department - 20182PPSC - Field Assistant Crop Reporter - Agriculture Department - 20182PPSC - HEALTH EDUCATOR (BS 17) - PUNJAB DEPARTMENT - 20142PPSC - INSTRUCTOR (BS 17) - Management and Professional Development Department - 00001PPSC - Inspector (BS 16) - Cooperative Societies - 20242PPSC - Inspector (BS 16) - Youth Affairs2PPSC - Inspector - Anti Corruption Establishment - 20201PPSC - Inspector - Cooperative Societies Department Punjab - 20192PPSC - Inspector - Excise & Taxation (D.G Khan Region) - 00002PPSC - Inspector - Excise & Taxation (DG Khan Region) -1PPSC - Inspector - Excise & Taxation (Lahore Region) -2PPSC - Inspector - Excise & Taxation Additional Directorate - 00002PPSC - Inspector - Excise & Taxation Department - 20182PPSC - Inspector - Excise & Taxation Region (LAHORE) - 00002PPSC - JUNIOR CLERK (BPS 07) - PUNJAB PUBLIC SERVICE COMMISSION - 00001PPSC - JUNIOR CLERK (BPS 11) - S&GAD - 20162PPSC - JUNIOR CLERK (BPS 11) - S&GAD - 20181PPSC - JUNIOR CLERK (BPS 11) - S&GAD - 20161PPSC - Junior Clerk (43J2022) - Board of Revenue - 20234PPSC - Junior Clerk (BS 11) - Anti Corruption - 20202PPSC - Junior Clerk (BS 11) - Anti Corruption Establishment Department - 20202PPSC - Junior Clerk - Labour & Human Resource Department - 20192PPSC - Junior Clerk - Punjab Police Department - 20182PPSC - Junior Clerk - Punjab Police Department - 20224PPSC - Junior Clerk - Punjab Public Service Commission (PPSC) - 20194PPSC - Junior Clerk - Revenue Department - 20194PPSC - Junior Clerk - S&GAD Punjab - 20181PPSC - Junior Clerk - S&GAD Punjab - 20193PPSC - Junior Clerk - Services and General Administration Department Punjab (S&GAD) - 20191PPSC - Labour Inspector (BS 14) - Labour & Human Resource Department - 20192PPSC - Labour Inspector - Labour & Human Resource Department - 20202PPSC - Labour Inspector - Labour and Human Resource Department - 20184PPSC - Labour Officer - Labour & Human Resource Department - 20201PPSC - Labour Officer - Labour and Human Resource Department - 20184PPSC - Lecturer Computer Science IT (BS 17) - Higher Education Department Punjab - 20171PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 20173PPSC - Lecturer English (Male) 9 Jun 2024 - Higher Education Department - 20242PPSC - Lecturer History (Male) - Higher Education Department - 20213PPSC - Manager (20M2020) - AUQAF - 20201PPSC - Monitoring & Evaluation Assistant / Field Coordinator - Punjab Employees Social Security Institution - 20191PPSC - NAIB TEHSILDAR (ENGLISH) (BS 14) - REVENUE DEPARTMENT PUNJAB - 20223PPSC - NAIB TEHSILDAR (GENERAL KNOWLEDGE) (BS 14) - REVENUE DEPARTMENT PUNJAB - 20222PPSC - PMS - PPSC - 202425PPSC - PMS GK - 2020 MCQs1PPSC - PMS General Knowledge - S&GAD - 20191PPSC - PMS General Knowledge - S&GAD - 20201PPSC - PMS General Knowledge - S&GAD - 20224PPSC - PMS General Knowledge - S&GAD - 20191PPSC - PMS General Knowledge - S&GAD - 20222PPSC - Past Papers - Most Repeated1PPSC - Personal Assistant & Assistant (BPS 16) - S&GAD - 20203PPSC - Personal Staff Officer (BS 17) - S&GAD - 20202PPSC - Planning Officer /Deputy District Officer (Planning) - Planning & Development - 20143PPSC - Provincial Management Service (PMS) - S&GAD - 20185PPSC - Provincial Management Service PMS (Ministerial Quota) - S&GAD - 20192PPSC - Service Center Official - Punjab Land Record Authority - 20182PPSC - Service Center Officials (BPS 11) - Punjab Land Record Authority - 20202PPSC - Social Security Officer – (PESSI) Labour and Human Resource Department - 20182PPSC - Sub Inspector (BS-14) - Transport - 20192PPSC - Sub Inspector (Open Merit) - Punjab Police - 20221PPSC - Sub Inspector (Service Quota) - Punjab Police - 20192PPSC - Sub Inspector - Cooperative Societies Punjab - 20182PPSC - Sub Inspector - Punjab Police - 20192PPSC - Tehsildar Consolidation Officer/Hill Torrent Officer /Reader to members Board of Revenue (BS 16) - Revenue Department - 20201PPSC - ZILADAR (14 19G2020) - Irrigation Department - 20201PPSC - ZILADAR (Research/DLR Zone) 14.20G2020 - Irrigation Department - 20203Punjab held on 13-07-2024 (2024)2SPSC - Assistant Director (BS 17) - Education Department Sindh - 20231Sports2Sports Archaeology & Tourism Department - 20192Sub Divisional Officer (2024)1Sub Inspector (BS-14) Held on 19-10-2025 (2025)1System Administrator 202657