Access free live classes and tests on the app
Download
+
Unacademy
  • Goals
    • AFCAT
    • AP EAMCET
    • Bank Exam
    • BPSC
    • CA Foundation
    • CAPF
    • CAT
    • CBSE Class 11
    • CBSE Class 12
    • CDS
    • CLAT
    • CSIR UGC
    • GATE
    • IIT JAM
    • JEE
    • Karnataka CET
    • Karnataka PSC
    • Kerala PSC
    • MHT CET
    • MPPSC
    • NDA
    • NEET PG
    • NEET UG
    • NTA UGC
    • Railway Exam
    • SSC
    • TS EAMCET
    • UPSC
    • WBPSC
    • CFA
Login Join for Free
avtar
  • ProfileProfile
  • Settings Settings
  • Refer your friendsRefer your friends
  • Sign outSign out
  • Terms & conditions
  • •
  • Privacy policy
  • About
  • •
  • Careers
  • •
  • Blog

© 2023 Sorting Hat Technologies Pvt Ltd

Watch Free Classes
GATE 2026 Exam Date Announced – Complete Schedule, Syllabus, and Key Details » GATE MCQs » MCQs on DBMS
Prepare for GATE & ESE

MCQs on DBMS

Here are the various Mcq of GATE exam (Graduate Aptitude Test in Engineering (GATE) is an examination conducted in India) which will help you to check your knowledge in the subject.

Table of Content
  •  

The Graduate Aptitude Test in Engineering (GATE) is an examination held in India that primarily assesses a student’s understanding of various undergraduate engineering and science subjects in preparation for admission to a master’s program and employment in the public sector. GATE is administered on behalf of the National Coordination Board – GATE, Department of Higher Education, Ministry of Education (MoE), Government of India, by the Indian Institute of Science and seven Indian Institutes of Technology in Roorkee, Delhi, Guwahati, Kanpur, Kharagpur, Chennai (Madras), and Mumbai (Bombay).

A candidate’s GATE score reflects his or her relative level of performance. The score is used to determine admission to various post-graduate education programs in Indian higher education institutions, with funding provided by the Ministry of Human Resource Development and other government agencies.

MCQs (Multiple Choice Questions)

Q1. In a rectangular channel 1 m wide and 250 mm deep, a steady discharge of 1 cumec flows uniformly. The channel bed has a slope of:

a)  adverse

b)  critical

c)  steep

d)  mild

Answer=A.

As it has an adverse slope

Q2 Which of these databases must be backed up on a regular basis?

a). Master

b). TEMPDB

c). Pub

d). Adventure Works

Answer: (a) Master.

master database stores all of an instance of SQL Server’s system-level information, including instance-wide metadata like logon accounts, endpoints, linked servers, and system configuration settings.

Q3 In which of the following modes is the database read-only?

a). Restore mode is a mode that allows you to restore your computer to its

b). Remain steadfast

c). Read-only storage

d). All of the preceding

Answer: (b) Remain steadfast.

Users can read but not modify data in a read-only database.

Q4 SQL Server Extended Events Packages include which of the following items?

a). Predicates

b). Types

c). Events

d). All of the above

Answer: (d) All of the above.

As SQL Server Extended Events Packages include all the items

Q5 What causes anxiety as a result of modern life, and how do we deal with it?

a). Distress

b). Eustress

c). Depression

d). None of the above

Answer: (a) Distress

Distressed is an adjective that describes a general sense of dissatisfaction, such as the distressed feeling you get when your team is about to lose a big game. Distressed can also refer to a state of being stressed and exhausted as a result of worry.

Q6 Which of these factors has an impact on one’s personality?

a). The arts

b). The family

c). Genetics

d). All of the preceding

Answer: (d) All of the preceding.

The arts, family, genetics all of these factors have an impact on one’s personality

Q7 A mismatch between a person’s personality and their organization can result in:

a). Members of an organization’s membership will lose interest.

b). Low morale and job satisfaction

c). Confusion and chaos

d). All of the preceding

Answer: (d) All of the preceding.

Confusion and chaos, low morale and job satisfaction,& the Members of an organization’s membership will lose interest and thus it includes all the above proceedings

Q8 Which of these stages involves the use of change management techniques such as questionnaires, interviews, and so on?

a). Employee recruitment

b). Education

c). The Finding of a Diagnosis

d). All of the preceding

Answer:(c) Diagnosis is the correct answer.

The cause or nature of a condition, situation, or problem is investigated or analyzed.

Q9 Which of these cannot result in a Poisson distribution being generated?

a). The total number of bacteria that lives in a cubic yard of soil

b). The total number of customers who are arriving at a petrol pump

c). The total number of phone calls that one can receive in an interval of ten minutes

d). The total number of misprints that one can find on a page

Answer: (b) The total number of customers who are arriving at a petrol pump.

Q10 Determine which of the following statements is NOT true or correct.

a). The Poisson distribution is a probability distribution for discrete random variables, whereas the continuous exponential distribution is for continuous random variables.

b). The mean of an exponential distribution is the inverse of Poisson’s mean.

c). The exponential distribution is a group of curves that are completely described by the mean.

d). The exponential distribution describes the Poisson process as a continuous random variable.

Answer: (b) The mean of an exponential distribution is the inverse of Poisson’s mean.

Q11 The mean of an exponential distribution is equal to the mean of a Poisson distribution when the former’s mean is equal to

a). 2.0

b). 0.25

c). 0.5

d). 1.0

Answer: (d) 1.0.

Q12 For an f(x) probability density function, which of these statements would be correct?

a). As the value of X increases, the density function increases as well.

b). There will be a difference in the height of the available density function for different values of X.

c). The density function would always be constant for any value of X that we could imagine.

d). The density function would be roughly “bell-shaped.”

e). None of the preceding statements are correct.

Answer: (c) The density function would always remain constant for all possible values of X.

Q13 If you consider the number of states in minimal DFA and NFA using the regular expression r = (11 + 111)* over = 0 and 1, you get:

a). DFA – 4; NFA – 3; DFA – 4; NFA – 3; DFA – 4;

b). DFA – 3; NFA – 3; DFA – 3; DFA – 3; DFA – 3;

c). DFA (3), NFA (4)

d). DFA – 4; NFA – 4; DFA – 4; NFA – 4; DFA – 4;

Answer: a) DFA – 4, NFA – 3 is the correct answer.

Thus, the correct answer to the following is DFA – 4; NFA – 3; DFA – 4; NFA – 3; DFA – 4;

Q14 If G is the CFG, r is the total number of rightmost derivations, l is the total number of leftmost derivations, and P is the total number of parse trees, then r, l, and P must be computed for each string separately. What are the relationship between all three of these for a given ‘G’ CFG and a given ‘w’ string?

a). r ≤ P ≥ l

b). r = P = l

c). r ≥ P ≤ l

d). None

Answer: (b) r = P = l.

Thus, the correct answer to the following is  r = P = l

Q15 Consider the case of a G ambiguous grammar and its D disambiguated counterpart. Which of these statements is true if the language recognized by these two grammars is denoted by L(G) and L(D)?

a). L (D) = L (G)

b). L (D) ⊂ L (G)

c). L (D) is empty

D). L (D) ⊃ L (G)

Answer: (a) L (D) = L (G).

Thus, correct answer of the following is  L (D) = L (G)

Q16 Which of these refers to the water content of the soil, which represents any liquid-plastic state boundary?

a). liquid limit

b). plastic limit

c). shrinkage limit

d). none of the above

Answer: (a) liquid limit.

The liquid limit is the point at which the soil begins to behave like a liquid. The liquid limit is determined by placing a clay sample in a standard cup and using a spatula to create separation (groove). The cup is dropped until the separation is no longer visible.

Q17 Which of these directories do we keep the system’s user-defined files that we use to create various user directories?

a). /etc/users

b). /etc/skel/

c). /etc/default

d). /usr/temp

Answer: (b) /etc/skel.

/etc/skel/ is used to  keep the system’s user-defined files that we use to create various user directories

Q18 In a consolidated drained test on a very normal consolidated day, the total volume of the available soil sample during the shearing

a). improves

b). does not change

c). decreases at first then increase

d). declines

Answer (d) decreases is the correct answer.

In a consolidated drained test on a very normal consolidated day, the total volume of the available soil sample during the shearing decreases 

Q19 The reluctance is increased by 20% when the length of a magnetic material bar is increased by 20% and the cross-sectional area is decreased by 20%.

a)Decreased by 33%

b)Increased by 55%

c)Decreased by 55%

d)Increased by 50%

Answer (d).

As a result, it is decreased by 50%.

Q20 The maximum core flux density of a transformer will increase by 50% when the applied voltage is increased by 50% and the frequency is reduced by 50% (assuming the magnetic circuit remains unsaturated).

  1. a) Increase the value to three times the original.
  1. b) Increase the value to twice the original value 
  1. c) Increase the value to 1.5 times the original valued
  1. d) Retains the same value as before.

Answer (a).

The maximum core flux density of a transformer will increase by 50% when the applied voltage is increased by 50% and the frequency is reduced by 50% thus it increases the value to three times the original

 

Crack GATE with Unacademy

Get subscription and access unlimited live and recorded courses from India’s best educators

  • Structured syllabus
  • Daily live classes
  • Ask doubts
  • Tests & practice
Learn more

Notifications

Get all the important information related to the GATE Exam including the process of application, important calendar dates, eligibility criteria, exam centers etc.

Complete Guide to GATE 2025 Syllabus for CSE with Subject-wise Weightage – Quick Guide
GATE 2012 Questions with Answers
GATE 2013 Question with Answers
GATE 2014 Question with Answers
GATE 2015 Questions with Answers
GATE 2016 Questions with Answers
GATE 2017 Questions with Answers
GATE 2018 Questions with Answers
GATE 2019 Questions with Answers
GATE 2020 Question Paper with Answer: Download PDFs
GATE 2021 Questions with Answers
GATE 2022 Rankers Summit
GATE 2023 Admit Card – Release Date, How to Download & Direct Link
GATE 2023 Exam Dates
GATE 2024 Registration – Application Form at gate2024.iisc.ac.in
GATE 2026 Detailed Paper Analysis & Solution
GATE CS & IT Engineering Previous Year Questions with Answers
GATE Cutoff 2023 – Brach-wise and Category-wise cut-off
GATE Electrical Engineering Previous Year Questions with Answers
GATE Electronics and Communication Engineering (ECE) Previous Year Questions with Answers
GATE Eligibility Criteria 2026: Age Restrictions, Qualifications, and Applicants
GATE Exam Calendar 2023
GATE Exam Pattern 2023 – New Test Structure, Paper Pattern, Marking Scheme for all papers
GATE Mechanical Engineering Previous Year Questions with Answers
GATE Previous Year Question Papers with Solution – Download PDFs
GATE Previous Year Question Papers with Solutions for Civil Engineering
GATE Result 2023 Out – Steps to check GATE Result
GATE Syllabus 2026: Download GATE Syllabus PDF
See all

Related articles

Learn more topics related to GATE MCQs
Python MCQs

Python is a programming language, basically a very high-level and a general-purpose language. The design is such that it lays emphasis on code readability with the use of significant indentation. The language used in python helps construct an object-oriented approach with the aim to help the programmers write clear and logical codes for small and large-scale products.

Organisational Behaviour

The below articles contains MCQs on Organisational Behaviour. These questions involves the types of questions that are frequently asked in the examination.

Operating System MCQs

This article will discuss important points about operating systems and will as mention multiple choice questions on operating systems. The article will further explain the answers to each question in brief. Further questions related to various sections under the operating system are covered throughout the article.

Mobile Computing

MCQs on " Mobile Computing": Find the multiple choice questions on " Mobile Computing", frequently asked for all competitive examinations.

See all
Access more than

10,997+ courses for GATE & ESE

Get subscription

Trending Topics

  • Comprehensive Guide for GATE Data Science
  • GATE PYQs Test Series (DS & AI Engineering)
  • GATE DS & AI UA Lite – 2026
  • Unacademy Subscription – GATE CSIT, DSAI & Interview Preparation
  • Foundation Batch for GATE & PSUs 2028 – DSAI 4.0
  • GATE Preparation Books

Related Links

  • Abhyaas : Practice Program Batch for GATE & ESE 2026 – CE
  • Starters Kit for GATE 2027 & 2028 – CE
  • Abhyaas : Practice Batch for GATE, ESE & PSUs 2026 – ME
  • Course On Measurements & Instrumentation
  • Starters Kit for GATE 2027 & 2028 – EC
  • Distance Learning Program for GATE – ECE 2025
  • Aasha : Batch for WBSEDCL JE Gr-II 2025
  • GATE Civil Engineering Syllabus 2026
  • GATE Exam Syllabus For Mechanical Engineering
  • Best GATE Preparation Books for ECE
  • How to Prepare for GATE CS & IT
  • GATE Preparation
Download previous years papers
.
Company Logo

Unacademy is India’s largest online learning platform. Download our apps to start learning


Starting your preparation?

Call us and we will answer all your questions about learning on Unacademy

Call +91 8585858585

Company
About usShikshodayaCareers
we're hiring
BlogsPrivacy PolicyTerms and Conditions
Help & support
User GuidelinesSite MapRefund PolicyTakedown PolicyGrievance Redressal
Products
Learner appLearner appEducator appEducator appParent appParent app
Popular goals
IIT JEEUPSCSSCCSIR UGC NETNEET UG
Trending exams
GATECATCANTA UGC NETBank Exams
Study material
UPSC Study MaterialNEET UG Study MaterialCA Foundation Study MaterialJEE Study MaterialSSC Study Material

© 2026 Sorting Hat Technologies Pvt Ltd

Unacademy
  • Goals
    • AFCAT
    • AP EAMCET
    • Bank Exam
    • BPSC
    • CA Foundation
    • CAPF
    • CAT
    • CBSE Class 11
    • CBSE Class 12
    • CDS
    • CLAT
    • CSIR UGC
    • GATE
    • IIT JAM
    • JEE
    • Karnataka CET
    • Karnataka PSC
    • Kerala PSC
    • MHT CET
    • MPPSC
    • NDA
    • NEET PG
    • NEET UG
    • NTA UGC
    • Railway Exam
    • SSC
    • TS EAMCET
    • UPSC
    • WBPSC
    • CFA

Share via

COPY