Computer Programming MCQs » DBMS MCQs
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
13 May
Virulent
(of a disease or poison) extremely severe or harmful in its effects.
زہریلا، تلخی، ہلاکت آفرینی

MCQs Menu

Basic Computer MCQs / General Knowledge MCQs (mixed)16408
Pak Study MCQs11702
English Literature Mcqs / English MCQs (mixed)9319
CHEMICAL ENGINEERING6108
Basic Computer MCQs / Computer Programming MCQs (mixed)5739
Everyday Science MCQs5111
Medical MCQs5099
Economics Mcqs4475
Political Science Mcqs4081
World Affairs MCQs / World Current Affairs MCQs (mixed)3947
Civil Engineering Mcqs2965
Islamiat MCQs2964
Judiciary And Law Mcqs2940
Basic Computer MCQs2872
Agriculture MCQs2798
Mechanical Engineering Mcqs2075
Psychology Mcqs2056
Mathematics Mcqs1762
Marketing Mcqs1725
Accounting MCQs1590
Sociology Mcqs1528
Finance Mcqs1052
Operating System1019
Computer Network / Computer Networks (mixed)1014
HRM Mcqs937
Physics852
Statistics Mcqs734
Forest Classifications / Forestry Mcqs (mixed)729
Urdu MCQs683
Evolution of International Relations / International Relations (mixed)599
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 Management102
Health Education98
Stoichiometry98
General Knowledge MCQs / World Geography (mixed)94
Computer Networks MCQs / Network Security (mixed)93
General Knowledge MCQs / Pakistan Studies (mixed)93
FIA Act 197492
Pak Study MCQs / Pakistan Affairs (mixed)86
Rules of Volleyball Game85
Nuclear Power Engineering83
Coordination78
Developmental Psychology76
Polymer Technology75
Pak Affairs MCQs74
Educational Psychology74
Religion68
Motivation58
Learning55
Islamic Studies54
Chemistry54
Personality52
Biological Foundations of Behaviour49
Distributed Operating System49
International Law47
Optical Communication40
Realtime Operating System39
Methods and Approaches37
General Science35
Network Security Interview34
Industrial Management33
Cognitive Psychology32
Current Affairs32
Major Thinkers in Psychology32
Historic Agreements, Pacts, Peace and Major Contracts31
Computer Fundamentals / Networking Fundamentals31
Computer Networks Interview29
General Knowledge MCQs / History (mixed)28
Cyber Security27
Digital Communications26
Conflict, War, and Terrorism26
Law MCQs26
International Organization, Law, and Human Rights24
Cognitive Radio / Wireless Communication - Cognitive Radio24
Nervous System23
Basic Mathematics MCQs20
Disputed Barrages. Dams20
Industrial Psychology20
Criminal Psychology20
Liberal and Social Theories19
Math18
Tough Network Security18
Electronic Devices And Circuits16
English15
Network Security Online Test/15
Network Security Test/15
PUNJAB LAND REVENUE ACT 1967 MCQs15
Interpersonal Relations And Group Processes14
Language And Thought13
Network Security Quiz/13
Clinical Psychology13
Pharmaceutical Chemistry Mcqs12
Biodiversity12
Methodology12
Neural Networks11
Mathematics10
Operating System Question Answers Multimedia Systems/10
Computer Networks Question Answers Basics/10
Computer Networks Questions Bank/10
Network Security Questions Entrance Exams/10
Power Systems10
Network Security Aptitude Test/9
Network Security Assessment Questions/9
Environment and Technology9
Network Security Multiple Choice9
Computer Networks Multiple Choice9
FIA Rules9
Biology9
Network Security Questions Campus Interviews/9
Mongodb9
Network Security Quiz Online/9
Physical Education8
Organizational Psychology8
Network Security Puzzles/8
Network Security Question Bank/8
International Borders & Lines8
Network Engineering MCQs8
URDU GENERAL KNOWLEDGE7
Current Affairs MCQs7
Computer7
Diplomacy7
Tricky Network Security7
Globalization and the Transformation of Political Community6
International Regimes6
Photography Mcqs6
International and Global Security6
Joints and their movements5
Poverty, Development, and Hunger5
Soil Science5
Gender in World Politics5
Contemporary Mainstream Approaches. Neo-Realism and Neo-Liberalism5
Culture in World Affairs5
Globalization and the Post-Cold-war Order5
One Word Substitutes Mcqs4
Social Sciences4
Fill in the blanks Mcqs4
Human Security4
Humanitarian Intervention in World Politics4
International Ethics4
Entomology3
Poststructuralism3
Biotechnology MCQs3
CONSTITUTIONAL HISTORY (CASES)3
Transnational Actors and International Organizations in Global Politics3
Government & Law2
Current Federal Ministers2
Regionalism in International Affairs2
Current Provincial Ministers Balochistan2
Horticulture MCQs2
Environmental Science / Science (mixed)2
MOTORWAY POLICE2
Civil Procedure 19082
Quadratic Equations1
Commerce1
Philosophy1
Vocabulary1
Operating System Interview Questions/1
Current Presidents - Chairmen - CEOs1
Islamic History1
Islamic Knowledge1
Sensation And Perception1
HRMS1
Pak Current Affairs MCQs1
Microsoft Excel Mcqs1
Direct And Indirect Speech Mcqs1
Software Engineering types1
President of Countries1
Namaz MCQs1
General Sports1
Management Mcqs1

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 Notes110Data 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 202533PPSC - 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 - 20174PPSC - 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 - 202424PPSC - 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 - 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)1System Administrator 20266301Sub Inspector (BS-14) Held on 19-10-2025 (2025)1