System Administrator 2026
Attempt This Past Paper
The system periodically performs checkpoints that consists of the following operation(s) ____________
  • A. Putting all the log records currently in main memory onto stable storage
  • B. Putting all modified data residing in main memory onto stable storage
  • C. Putting a log record onto stable storage
  • D. All of the mentioned
Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________
  • A. There is a need to perform an undo operation on t1
  • B. There is a need to perform a redo operation on t1
  • C. There is no need to perform an undo and redo operation on t1
  • D. All of the mentioned
Serializable schedules are ones where ____________
  • A. Concurrent execution of transactions is equivalent to the transactions executed serially
  • B. The transactions can be carried out one after the other
  • C. A valid result occurs after execution transactions
  • D. None of the mentioned
A locking protocol is one that ____________
  • A. Governs how locks are acquired
  • B. Governs how locks are released
  • C. Governs how locks are acquired and released
  • D. None of the mentioned
The two phase locking protocol consists of ____________
  • A. Growing & shrinking phase
  • B. Shrinking & creation phase
  • C. Creation & growing phase
  • D. Destruction & creation phase
The growing phase is a phase in which?
  • A. A transaction may obtain locks, but does not release any
  • B. A transaction may obtain locks, and releases a few or all of them
  • C. A transaction may release locks, but does not obtain any new locks
  • D. A transaction may release locks, and does obtain new locks
The shrinking phase is a phase in which?
  • A. A transaction may obtain locks, but does not release any
  • B. A transaction may obtain locks, and releases a few or all of them
  • C. A transaction may release locks, but does not obtain any new locks
  • D. A transaction may release locks, and does obtain new locks
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering
  • A. I only
  • B. Ii only
  • C. Both i and ii
  • D. Neither i nor ii
A deadlock can be broken by ____________
  • A. Abort one or more processes to break the circular wait
  • B. Abort all the process in the system
  • C. Preempt all resources from all processes
  • D. None of the mentioned
The two ways of aborting processes and eliminating deadlocks are ____________
  • A. Abort all deadlocked processes
  • B. Abort all processes
  • C. Abort one process at a time until the deadlock cycle is eliminated
  • D. All of the mentioned
Word of the Day
18 Jun
Betray
expose (one’s country, a group, or a person) to danger by treacherously giving information to an enemy.
دغا دینا، غداری کرنا، ساتھ چھوڑنا

MCQs Menu

General Knowledge MCQs16405
Pak Study MCQs11702
English MCQs9319
Chemical Engineering6108
Computer Programming MCQs5739
Everyday Science MCQs5120
Medical MCQs5099
Economics Mcqs4475
Political Science Mcqs4081
World Current Affairs MCQs3947
Civil Engineering MCQs2965
Islamiat MCQs2963
Judiciary And Law Mcqs2940
Basic Computer MCQs2872
Agriculture MCQs2794
Mechanical Engineering Mcqs2075
Psychology Mcqs2056
Mathematics MCQs1762
Marketing Mcqs1725
Accounting MCQs1590
Sociology Mcqs1528
Finance Mcqs1052
Operating System1019
Computer Networks1014
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 Management102
Stoichiometry98
Health Education98
World Geography94
Network Security93
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
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
Major Thinkers in Psychology32
Current Affairs32
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
Basic Mathematics MCQs20
Criminal Psychology20
Disputed Barrages. Dams20
Industrial Psychology20
Liberal and Social Theories19
Math18
Tough Network Security18
Electronic Devices And Circuits16
English15
Network Security Test/15
PUNJAB LAND REVENUE ACT 1967 MCQs15
Network Security Online Test/15
Interpersonal Relations And Group Processes14
Clinical Psychology13
Language And Thought13
Network Security Quiz/13
Pharmaceutical Chemistry Mcqs12
Biochemistry MCQs12
Methodology12
Neural Networks11
Computer Networks Question Answers Basics/10
Mathematics10
Computer Networks Questions Bank/10
Operating System Question Answers Multimedia Systems/10
Network Security Questions Entrance Exams/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 Question Bank/8
International Borders & Lines8
Network Engineering MCQs8
Organizational Psychology8
Physical Education8
Network Security Puzzles/8
Current Affairs MCQs7
Tricky Network Security7
URDU GENERAL KNOWLEDGE7
Computer7
Diplomacy7
International and Global Security6
Horticulture MCQs6
International Regimes6
Photography Mcqs6
Globalization and the Transformation of Political Community6
Joints and their movements5
Poverty, Development, and Hunger5
Gender in World Politics5
Contemporary Mainstream Approaches. Neo-Realism and Neo-Liberalism5
Culture in World Affairs5
Globalization and the Post-Cold-war Order5
Soil Science5
Fill in the blanks Mcqs4
International Ethics4
Social Sciences4
Human Security4
Humanitarian Intervention in World Politics4
One Word Substitutes Mcqs4
Poststructuralism3
Transnational Actors and International Organizations in Global Politics3
CONSTITUTIONAL HISTORY (CASES)3
Biotechnology Engineering MCQs3
Entomology3
Government & Law2
MOTORWAY POLICE2
Current Federal Ministers2
Regionalism in International Affairs2
Civil Procedure 19082
Current Provincial Ministers Balochistan2
Science2
Operating System Interview Questions/1
Namaz MCQs1
Current Presidents - Chairmen - CEOs1
President of Countries1
Sensation And Perception1
Commerce1
Philosophy1
HRMS1
Pak Current Affairs MCQs1
Vocabulary1
Microsoft Excel Mcqs1
General Sports1
Direct And Indirect Speech Mcqs1
Software Engineering types1
Management Mcqs1
Islamic History1
Quadratic Equations1
Islamic Knowledge1

Past Papers

Archaeology & Tourism Department - 20191Archaeology &amp; 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 &amp; 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 &amp; 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&amp;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&amp;GAD - 20191PPSC - PMS General Knowledge - S&amp;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