Oracle: Introduction & SQL Overview Queries, Functions & Joins Beginner
Q What does a LEFT OUTER JOIN return?
  • A Only matching rows
  • B All rows from the right table only
  • C Only unmatched rows from both
  • D All rows from the left table plus matching rows from the right
FPSC - Database Administrator Model Papers -2026
Previous What does an INNER JOIN return?
Next In older Oracle syntax, which operator denotes an outer…
Leave a Comment
Word of the Day
02 Nov
Obligation
an act or course of action to which a person is morally or legally bound; a duty or commitment.
Ψ§Ψ­Ψ³Ψ§Ω†ΨŒ فرآ، ذمہ داری

MCQs Menu

General Knowledge MCQs16403
Pak Study MCQs11702
English MCQs9321
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
Civil Servants Act 1973 & Rules108
Computer Network Management103
Designing Solution & Testing100
Development of Basic Algorithms100
Computer Networks and Internet100
Program Logic100
Programming Languages (C++, VB, Python)100
Search Engine Optimization100
Unix/Red Hat Linux Operating System100
Multiple Browsers100
Web Development100
Fundamental Programming100
Data Types100
Rules of Business, 197399
Stoichiometry98
Health Education98
Network Security94
World Geography94
Pakistan Studies93
FIA Act 197492
Public Procurement Rules, 200491
Pakistan Affairs86
Rules of Volleyball Game85
FM & Powers of PAOs Regulations, 202185
Nuclear Power Engineering83
Coordination78
Developmental Psychology76
Polymer Technology75
Pak Affairs MCQs74
Educational Psychology74
Religion68
Human Resource Management67
Oracle: Backup and Recovery58
Oracle: Database Server Architecture58
Motivation58
Oracle: Users & Security58
Oracle: Constraints & Indexes57
Oracle: Introduction & SQL Overview57
Oracle: Modifying Data & Multiple Databases56
Learning55
Oracle: Tables & Views55
Chemistry54
Islamic Studies54
Personality52
Biological Foundations of Behaviour49
Distributed Operating System49
International Law47
Optical Communication40
Realtime Operating System39
Methods and Approaches37
General Science35
English: Prepositions35
Network Security Interview34
English: Vocabulary34
Industrial Management33
Major Thinkers in Psychology32
Current Affairs32
Cognitive Psychology32
Networking Fundamentals31
Historic Agreements, Pacts, Peace and Major Contracts31
English: Active & Passive Voice30
English: Direct & Indirect Narration30
Computer Networks Interview29
History28
Cyber Security27
Law MCQs26
Digital Communications26
Conflict, War, and Terrorism26
International Organization, Law, and Human Rights24
English: Sentence Structuring24
Wireless Communication - Cognitive Radio24
Nervous System23
Criminal Psychology20
Basic Mathematics MCQs20
Part-I English (Grammar & Sentence Structure)20
Industrial Psychology20
Disputed Barrages. Dams20
Liberal and Social Theories19
Tough Network Security18
Math18
Electronic Devices And Circuits16
Network Security Test/15
English15
Basic Arithmetic15
Network Security Online Test/15
PUNJAB LAND REVENUE ACT 1967 MCQs15
Computer / IT15
Interpersonal Relations And Group Processes14
Network Security Quiz/13
Clinical Psychology13
Language And Thought13
Methodology12
Biochemistry MCQs12
Pharmaceutical Chemistry Mcqs12
Neural Networks11
Computer Networks Question Answers Basics/10
Computer Networks Questions Bank/10
English: Grammar Usage10
Mathematics10
Power Systems10
Network Security Questions Entrance Exams/10
Operating System Question Answers Multimedia Systems/10
Network Security Quiz Online/9
Environment and Technology9
Network Security Aptitude Test/9
Network Security Assessment Questions/9
Computer Networks Multiple Choice9
FIA Rules9
Mongodb9
Network Security Multiple Choice9
Network Security Questions Campus Interviews/9
Network Engineering MCQs8
Physical Education8
Tricky Network Security8
Network Security Puzzles/8
International Borders & Lines8
Network Security Question Bank/8
Computer8
Organizational Psychology8
Diplomacy7
Current Affairs MCQs7
URDU GENERAL KNOWLEDGE7
International Regimes6
Photography Mcqs6
Globalization and the Transformation of Political Community6
International and Global Security6
Horticulture MCQs6
Culture in World Affairs5
Globalization and the Post-Cold-war Order5
Poverty, Development, and Hunger5
Joints and their movements5
Soil Science5
Contemporary Mainstream Approaches. Neo-Realism and Neo-Liberalism5
Gender in World Politics5
Human Security4
Humanitarian Intervention in World Politics4
Fill in the blanks Mcqs4
Social Sciences4
One Word Substitutes Mcqs4
International Ethics4
Entomology3
Transnational Actors and International Organizations in Global Politics3
Poststructuralism3
Biotechnology Engineering MCQs3
CONSTITUTIONAL HISTORY (CASES)3
Science2
Civil Procedure 19082
Government & Law2
Current Federal Ministers2
Office Management MCQs2
MOTORWAY POLICE2
Current Provincial Ministers Balochistan2
Regionalism in International Affairs2
Pak Current Affairs MCQs1
Philosophy1
HRMS1
General Sports1
Microsoft Excel Mcqs1
Current Affair MCQs1
Management Mcqs1
Islamic History1
Sensation And Perception1
Direct And Indirect Speech Mcqs1
Islamic Knowledge1
Current Presidents - Chairmen - CEOs1
Commerce1
Vocabulary1
Quadratic Equations1
Software Engineering types1
Namaz MCQs1
Operating System Interview Questions/1
President of Countries1

Past Papers

(22-06-2025) ADD# 1510120% GK Assistant Director (STAT) BS-17 (Evening) Held on 21-09-2025 (2025)17D2025 (2025)1AD Attorney (2024)1AD Research GK 40% (12-04-2025) (2025)1AD STAT BS-17 (Morning) Held on 21-9-2025 (2025)1ASI Service quota (13-04-2025) (2025)2ASSISTANT EXECUTIVE ENGINEERS / SUB DIVISIONAL OFFICER / ASSISTANT DESIGN ENGINEER / ASSISTANT DESIGN OFFICER / ASSISTANT DIRECTOR FLOOD MONITORING / ASSISTANT DIRECTOR (BS-17) (2025)1ASSISTANT REGISTRAR GK PAPER HELD on 28-9-2025 (2025)1Account and Audit Officer (Morning ) (13-10-2024) (2024)1Accountant / Auditor Held on 24.02.2025 (2025)1Accounts Officer BS-17 (25-06-2024) (2024)1Agriculture) Held on 13-07-2024 (2024)1Archaeology & Tourism Department - 20191Archaeology & Tourism Department - 20191Assistant (13-07-2025) (2025)1Assistant BOR2Assistant Controller-Morning 23-11-2024 (2024)1Assistant Director (Accounts) FDA Held on 14-07-2024 (2024)1Assistant Director (C&W) Communication and works department Held on: 08-06-2024 (2024)1Assistant Director (HR and ADMIN) BS-17 (2025)1Assistant Director -Evening (23-11-2024) (2024)1Assistant Director ASF (BS-17) Batch 01 (05-08-2024) (2024)1Assistant Director Farms/Procurement (Punjab Seed Corporation1Assistant Director Fisheries (BS-17) (1-06-2025) (2025)1Assistant Director LDA (27-04-2025) (2025)1Assistant Director TEPA BS-17 (13-07-2025) (2025)1Assistant Director Wildlife BS-17 Held on 23.02.2025 (2025)1Assistant Director legal (24-08-2024) (2024)1Assistant Election Commissioner (BS-17) (2025)1Assistant Held on 07.12.2025 (2025)1Assistant PESSI Held on 19-10-2025 (2025)1Assistant S&GAD (Evening) Held On 01-12-2024 (2024)1Assistant S&GAD (Evening) Held On 24-11-2024 (2024)1Assistant S&GAD (Morning) Held On 01-12-2024 (2024)1Assistant S&GAD (Morning) Held On 24-11-2024 (2024)1Assistant Sub Inspector BPS-11 (BATCH-1) 08-04-2025 (2025)2Assistant Sub Inspector PHP (09-03-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)3CURATOR (BS-17) DIRECTORATE GENERAL OF ARCHAEOLOGY1Chief Officer/Municipal Officer (Regulations) Local Government & Community Develop1Chief Officer/Municipal Officer (Regulations) Local Government & Community Development (Held on 11-08-2024) (2024)2Clubbed (27-04-2025) (2025)2Clubbed Case 74 – Assistant (BS-16) Various Departments – 2024 (2024)5Clubbed Case-75 (Evening) Held on 13-07-2024 (2024)2Clubbed Case-76 (Evening) Held on 08-06-2024 (2024)4Clubbed Case-85 (Morning) Held on 08-06-2024 (2024)4Clubbed Case-91(Morning) Punjab Special Education Department (10-08-2024) (2024)3Clubbed Case-97 (Evening) Held on 13-07-2024 (2024)4Clubbed Case-Various Post(Labour Inspector/Officer2Clubbed ID 163 Assistant Held On 16.11.2025 (2025)2Clubbed ID-96 (27-07-2024) (2024)1Clubbes Case 98 – Various Posts -2024 (2024)3Computer Instructor (BS-17) Punjab Special Education (Held on 14-07-2024) (2024)1Concept Academy Notes87Data Entry Operator (BS-12) (31-05-2025) (2025)2ENFORCEMENT OFFICER (16-03-2025) (2025)1Educator (BS-16) Punjab Special Education Held on 13-07-2024 (2024)2English: Combined competitive Examination 2023 Held in 2025 (2025)1FIA - Assistant - FIA - 20181FIA - Sub Inspector (Investigation) - FIA - 20181FIA - VU - Assistant - Past Paper - 14-12-20211FIA ASI Test By VU on 13-12-20211FIA Assistant Test by VU paper on 14-12-20211FIA Assistant paper 14-12-20211FIA Past Paper Assistant/ASI/Inspector1FIA Superintedent Model Paper 20261FIA-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 Inspector1FPSC - Database Administrator Model Papers -20261FPSC - English Grammar - Model Papers (mcqhive.com)- 20261FPSC- Programmer (BS-17) - PMD High Yield - 20261FPSC- Programmer (BS-17) - Pakistan Meteorological Department (PMD) Model Papers - 20261G.k Portion( Sub Engineer Civil Bs-14) Dated 30-11-2024 (2024)1G.k Portion(Horticulture Officer) Dated 30-11-2024 (2024)1G.k Portion(Sub Engineer Mechanical Bs-14)Dated 30-11-2024 (2024)1GK 20261General Knowledge P.M.S (Held On 15-12-2024) (2024)1Hill Torrent Officer - Board of Revenue (BOR) Punjab - 20251History PORTION (22-06-2025) (2025)1INSTRUCTOR/LECTURER (MALE) ENGLISH (BS-17) (2024)2Inspector (BS-16) Tourist Services (DTS)3Inspector Cooperative (Cooperative Department) Held on 10-08-2024 (2024)3Internal Audit Specialist (BS-16) 31-05-2025 (2025)2Islamic Studies: Combined competitive Examination 2023 Held in 2025 (2025)1Junior Clerk (BS-11) (1-06-2025) (2025)1Junior Clerk (Evening) Held on 14.12.2025 (2025)1Junior Clerk (Morning) Held on 14.12.2025 (2025)1Junior Clerk BOR Held on 20.12.2025 (2025)1Junior Clerk Paper BS-11 (28C2025) Held on 27-09-2025 (2025)1Junior Computer Operator BS 11 (23-11-2024) (2024)1Junior Computer Operator- Morning (30-11-2024) (2024)1Junior Traffic Warden BS-11 (09-03-2025) (2025)1Labour Officer Held On 16.11.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)4MCQsCity - Tehsildar Naib Tehsildar1Medical Officer (BS-17) Labour Department Held on 09-06-2024 (2024)2Municipal Officer Gk (12-04-2025-0 (2025)1Nutritionist-Morning (23-11-2024) (2024)1PLANNING OFFICER (BS-17)1PLANNING OFFICER (BS-17) GK 20% (28-06-2025) (2025)1PLANNING OFFICER/ ASSISTANT DIRECTOR ( PLANNING) (BS-17) (2024)1PMS Ministerial (13-04-2025) (2025)2PMS Ministerial Qouta 202530PMS Ministerial Quota 20252PPPSC - Assistant (Punjab Police) - (20-06-2026 Evening Shift)1PPSC - 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 - Assistant1PPSC - 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 - 20201PPSC - Assistant - Clubbed Cases Various Departments - 20245PPSC - 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 Director (Accounts) / Lecturer Psychology 14 Jul 2024 - Higher Education Department & Others - 20241PPSC - 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 - Punjab Police Department - 20222PPSC - PMS - PPSC - 20246PPSC - PMS General Knowledge - S&GAD - 20191Pakistan Studies: Combined competitive Examination 2023 Held in 2025 (2025)1Physiotherapist (Punjab Special Education Department) Held on: 10-08-2024 (2024)1Punjab Police (20-06-2026 Evening Shift)1Punjab held on 13-07-2024 (2024)3Sports2Sports Archaeology & Tourism Department - 20192Sub Inspector (BS-14) Held on 19-10-2025 (2025)1System Administrator 202647ZILLADAR Morning (29-06-2025) (2025)1