MCQs on DBMS

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