How many such pairs of letters are there in the word โCLEANLINESSโ each of the which has as many letters between them in the word as they have in the English alphabet, in the same sequence?
A
Two
B
Three
C
Five
D
Four
E
None of these
Question 2Single Answer
Team A has scored more goals than Team B
Team C has scored fewer goals than Team B
Team A has scored fewer goals than Team C .
If the first two statements are true, the third statement is
A
True
B
False
C
Uncertain
D
None
Question 3Single Answer
If it is possible to make only one meaningful word with the second, the third, the sixth and the eight letters of the word FRAGMENT using each only once, which of the following will be the third letter of that word ? If no such word can be formed, give โXโ as the answer and if more than one such word can be formed, give โYโ as the answer.
A
A
B
E
C
T
D
X
E
Y
Question 4Single Answer
How many such letters are there in the word ORIENTAL each of which is as far away from the beginning of the word as when they are arranged alphabetically?
A
Noneย ย ย ย ย ย ย ย ย ย ย ย
B
Oneย ย ย ย ย ย ย ย ย
C
Twoย ย ย ย ย ย ย
D
Threeย ย ย ย ย ย ย ย
E
More than three
Question 5Single Answer
How many such pairs of letters in the word CREDIT each of which has as many letters between them in the word as in the English alphabet?
A
None
B
One
C
Two
D
Three
E
More than three
Question 6Single Answer
How many meaningful words can be made from the letters โLMEAโ using each letter only once in each word?
A
None
B
One
C
Two
D
Three
E
More than three
Question 7Single Answer
If it is possible to make only one meaningful word with the first, the second, the seventh and the eighth letters of the word TEMPORAL, which of the following will be the first letter of that word? If more than one such word can be made, give โYโ as the answer and if no such word can be made, give โXโ as the answer.
A
T
B
L
C
E
D
Y
E
X
Question 8Single Answer
If the letters of the word HANDOVER are arranged alphabetically from left to right how many letters will remain at the same position?
A
None
B
One
C
Two
D
Three
E
More than three
Question 9Single Answer
How many such pairs of letters are there in the word EXCURSION, each of which has as many letters between them in the word as they have in the English alphabet?
A
None
B
One
C
Two
D
Three
E
More than three
Question 10Single Answer
If it is possible to make only one meaningful word with the first, the second, the third, the sixth and the eighth letters of the word DEVIATION first letter of that word is your answer? If more than one such word can be made formed your answer is โAโย and if no such word can be formed your answer is โBโ.
A
V
B
T
C
E
D
A
E
B
Question 11Single Answer
If each alternate letter beginning with the first in the word WORKING is replaced by the next letter in the English alphabet and each of the remaining letters is replaced by the previous letter in the English alphabet, which of the following will be the fourth from the right and after the replacement ?
A
N
B
Q
C
J
D
M
E
None of these
Question 12Single Answer
How many pairs of letters are there in the word โSHIFTEDโ each of which has as many letters between its two letters as there are between in the English alphabet?
A
None
B
One
C
Two
D
Three
E
None of these
Question 13Single Answer
Statement: Is common currency a necessary ingredient for Europeโs growth ?
Arguments :
I. Yes, A common currency will enable entire Europe to market itself as one .
II. No, Similar experiments by Latin America countries have not affected their economies .
A
The only argument I is strong
B
Only argument II is strong
C
Either I or II is strong
D
Neither I nor II is strong
Question 14Single Answer
If it is possible to make only one meaningful word with the first, the fifth, the sixth, the tenth and the eleventh letters of the word EXCEPTIONAL using each letter only once, first letter of that word is your answer. If no such word can be made formed your answer is โXโย and if more than one such word can be formed your answer is โYโ.
A
P
B
L
C
T
D
X
E
Y
Question 15Single Answer
How many meaningful English words can be formed with the letters RAE using each letter only once in each word?
A
None
B
One
C
Two
D
Three
E
More than three
Question 16Single Answer
Passage :
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z .
Which letter in this alphabet is the eighth letter to the right of the letter and which is tenth letter to the left of the last but one letter of the alphabet ?
A
X
B
W
C
I
D
H
Question 17Single Answer
Passage :
Directionย : The following question is based on the five words given below:
AND FOR THE BIG SUM (The new words formed after performing the mentioned operations may or may not necessarily the meaningful English words.)
If the third alphabet of each of the words is changed to the next alphabet in the English alphabetical series, which of the following will form a meaningful English word?
A
SUM
B
BIG
C
Both BIG and THE
D
FOR
E
Both FOR and BIG
Question 18Single Answer
Passage :
Direction : The following question is based on the five words given below:
AND FOR THE BIG SUM (The new words formed after performing the mentioned operations may or may not necessarily the meaningful English words.)
If the given words are arranged in the order as they would appear in a dictionary from left to right, which of the following will be second from the right ?
A
AND
B
FOR
C
THE
D
BIG
E
SUM
Question 19Single Answer
Passage :
Direction: The following question is based on the five words given below:
AND FOR THE BIG SUM (The new words formed after performing the mentioned operations may or may not necessarily the meaningful English words.)
If second alphabet in each of the words is changed to next alphabet in the English alphabetical order, how many words having two vowels (same or different vowels) will be formed ?
A
None
B
One
C
Two
D
Three
E
Four
Question 20Single Answer
Passage :
Direction : The following question is based on the five words given below:
AND FOR THE BIG SUM (The new words formed after performing the mentioned operations may or may not necessarily the meaningful English words.)
How many letters are there in the English alphabetical series between the second letter of the word which is second from the right and the second letter of the word which is second from the left of the given words?
A
Two
B
Five
C
Six
D
Nine
E
Three
Question 21Single Answer
Passage :
Direction: The following question is based on the five words given below:
AND FOR THE BIG SUM (The new words formed after performing the mentioned operations may or may not necessarily the meaningful English words.)
If in each of the given words, each of the consonant is changed to previous letter and each vowel is changed to next letter in the English alphabetical series, in how many words thus formed will no vowels appear?
A
None
B
One
C
Two
D
Three
E
More than three
Question 22Single Answer
Passage :
Direction : Following question is based on five words given below: BRU LEGINKCATOWN
(The new words formed after performing the mentioned operations may or may not necessarily be meaningful English words)
If the third alphabet in each of the words is changed to the next alphabet in the English alphabetical order, how many words having two vowels (same or different vowels) will be formed?
A
None
B
One
C
Two
D
Three
E
Four
Question 23Single Answer
Passage :
Direction : Following question is based on five words given below: BRU LEGINKCATOWN
(The new words formed after performing the mentioned operations may or may not necessarily be meaningful English words)
If the position of the first and the second alphabets of each of the words are interchanged, which of the following will form a meaningful English word?
A
Both CAT and OWN
B
Both BRU and INK
C
Only CAT
D
Only INK
E
Only LEG
Question 24Single Answer
Passage :
Direction: Following question is based on five words given below: BRU LEGINKCATOWN
(The new words formed after performing the mentioned operations may or may not necessarily be meaningful English words)
If the given words are arranged in the order as they would appear in a dictionary from left to right, which of the following will be exactly in the middle of the five words?
A
OWN
B
LEG
C
BRU
D
CAT
E
INK
Question 25Single Answer
Passage :
Direction: Following question is based on five words given below: BRU LEGINKCATOWN
(The new words formed after performing the mentioned operations may or may not necessarily be meaningful English words)
If in each of the given words, each of the consonants is changed to previous letter and each vowel is changed to next letter in the English alphabetical series, in how many words thus formed will the same alphabet appear twice?
A
None
B
One
C
Two
D
Three
E
More than three
Quantitative Aptitude
Question 26Single Answer
The cash difference between the selling prices of an article at a profit of 4% and 6% is Rs. 3. The ratio of the two selling prices is:__________ ?
A
51:52
B
52:53
C
51:53
D
52:55
Question 27Single Answer
Which of the following numbers is irrational ?
A
√49
B
0.125
C
√2
D
22/7
Question 28Single Answer
356 x 936 โ 356 x 836 = ?
A
35600ย ย
B
34500
C
9630
D
93600
Question 29Single Answer
Arrange in descending order: 5/8, 7/10, 3/4
A
3/4 > 7/10 > 5/8
B
7/10 > 3/4 > 5/8
C
3/4 > 5/8 > 7/10
D
5/8 > 7/10 > 3/4
Question 30Single Answer
What is (3^{4} times 9^{2}) ?
A
36
B
38
C
310
D
96
ย
Question 31Single Answer
If 34X-2 = 729, then find the value of X.
A
4ย ย ย ย ย
B
3
C
2ย
D
5
Question 32Single Answer
Convert 0.6 into fraction ?
A
3/5
B
2/3
C
4/5
Question 33Single Answer
The no. plate of a bus had peculiarity. The bus number was a perfect square. It was also a perfect square when the plate numbers were reversed. The bus company had only five hundred buses numbered from 1 to 500. What was the number ?
A
169ย ย
B
36
C
196ย
D
Can not say
Question 34Single Answer
If a and b are positive integers, such that ab = 125, then (a-b)a+b-4 = ?
A
16 ย ย
B
25
C
28 ย
D
30
Question 35Single Answer
If x*y = x2 + y2 โ xy, then value of 9*11 is
A
93ย ย ย ย ย
B
103
C
60.5
D
121
Question 36Single Answer
Which is greater ?
A
15/16
B
17/18
C
Equal
D
Cannot compare
Question 37Single Answer
If sum of two numbers is 42 and their product is 437, then find their difference.
A
3ย
B
4
C
5ย ย ย ย
D
7
Question 38Single Answer
Write the 44000 in Roman numerals
A
XLIย
B
XLVI
C
XLIVย
D
XLVIC
Question 39Single Answer
Convert 0.0909โฆ into fraction ?
A
1/11
B
9/11
C
1/9
D
9/10
Question 40Single Answer
What is (98 times 102) ?
A
9996
B
10000
C
10096
D
10196
Question 41Single Answer
Passage :
information given below and answer the question that follow.
The result of an exam is given below. Out of 1000 students who appeared
(i) 658 failed in Physics
(ii) 166 failed in Physics and Chemistry
(iii) 372 failed in Chemistry, 434 failed in Physics and Maths
(iv) 590 failed in Maths, 126 failed in Maths & Chemistry
Find the number of people who failed in (assuming that none is passed in all subjects.
We have the following equations:
a+ b + c + d + e + f + g = 1000
a + b + d + e = 658, b + d = 166
b + d + c + f = 372
d + e = 434 as in the figure.
d + e + f + g = 590, d + f = 126. Find the values
Chemistry but not in Physics.
A
318
B
198
C
213ย
D
206
Question 42Single Answer
Passage :
Direction: information given below and answer the question that follow.
The result of an exam is given below. Out of 1000 students who appeared
(i) 658 failed in Physics
(ii) 166 failed in Physics and Chemistry
(iii) 372 failed in Chemistry, 434 failed in Physics and Maths
(iv) 590 failed in Maths, 126 failed in Maths & Chemistry
Find the number of people who failed in (assuming that none is passed in all subjects.
We have the following equations:
a+ b + c + d + e + f + g = 1000
a + b + d + e = 658, b + d = 166
b + d + c + f = 372
d + e = 434 as in the figure.
d + e + f + g = 590, d + f = 126. Find the values
Physics or Maths but not in Chemistry.
A
558ย ย ย
B
718
C
628ย ย
D
None of these
Question 43Single Answer
Passage :
For the next four question that follow:
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
ย (x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
What is the percentage of persons who read all the three papers ?
A
20%ย ย
B
25%
C
30%ย ย
D
40%
Question 44Single Answer
Passage :
For the next four : question that follow :
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
ย (x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
What is the percentage of persons who read only two papers?
A
19%ย ย
B
31%
C
44%
D
None of these
Question 45Single Answer
Passage :
For the next four : question that follow :
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
(x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
What is the percentage of persons who read only one paper ?
A
38%ย
B
48%
C
51%ย ย
D
None of these
Question 46Single Answer
Passage :
For the next four : question that follow:
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
ย (x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
What is the percentage of persons who read only A but neither B nor C ?
A
4%
B
3%
C
1%ย ย
D
None of these
Question 47Single Answer
Passage :
For the next four : question that follow:
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
ย (x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
If A and B are any two sets, then what is A แด (A แด B) equal to ?
A
Complement of Aย
B
Complement of B
C
Bย ย ย
D
A
Question 48Single Answer
Passage :
For the next four : question that follow:
In a city, three daily newspapers A, B, C are published, 42% read A; 51% read B; 68% read C; 30% read A and B; 28% read B and C; 36% read A and C; 8% do not read any of the three newspapers.
Let x% people read all the three newspapers.
Since 8% people do not read any newspapers.
ย (x โ 24) + (x โ 7) + (x + 4) + (30 โ x) + (36 โ x) + (28 โ x) + x = 92
→ x + 98 โ 31 = 92
→ x = 92 โ 67 = 25
40% of the people read newspaper X, 50% read newspaper Y and 10% read both the papers. What percentage of the people read neither newspaper ?
A
10%ย ย ย ย
B
15%
C
20%ย ย
D
25%
Question 49Single Answer
Passage :
Read the passage below and solve the question based on it.
5% of the passengers do not like coffee, tea and lassi and 10% like all the three, 20% like coffee and tea, 25% like lassi and coffee and 25% like lassi and tea. 55% like coffee, 50% like tea, and 50% like lassi.
Where C = Coffee, T = Tea and L =Lassi
The passengers who like only coffee is greater than the passengers who like only lassi by
A
25%ย ย ย
B
100%
C
75%ย ย ย
D
0%
Question 50Single Answer
Passage :
Read the passage below and solve the question based on it.
5% of the passengers do not like coffee, tea and lassi and 10% like all the three, 20% like coffee and tea, 25% like lassi and coffee and 25% like lassi and tea. 55% like coffee, 50% like tea, and 50% like lassi.
Where C = Coffee, T = Tea and L =Lassi
The percentage of passengers who like both tea and lassi but not coffee, is
A
15ย
B
25
C
40ย
D
75
Important Questions Package
Bank of Baroda IT API Developer Exam Online Question Bank Package
Buy Bank of Baroda IT API Developer Important Questions, MCQ, question answer in Hindi & English. It will help you to score high marks in Bank of Baroda IT API Developer question bank 2026 in Online, PDF & Print study material.
+ Free Monthly Current Affairs, GK & more PDF Download
Sr.
Package Name
Amount
1.
Bank of Baroda IT (API Developer) Exam - Hindi
Description : 1000 Question with Answer
โน101[โน500]
2.
Bank of Baroda IT (API Developer) Exam - Hindi
Description : 2000 Question with Answer
โน151[โน500]
3.
Bank of Baroda IT (API Developer) Exam - Hindi
Description : 3000 Question with Answer
โน181[โน500]
4.
Bank of Baroda IT (API Developer) Exam - English
Description : 1000 Question with Answer
โน101[โน500]
5.
Bank of Baroda IT (API Developer) Exam - English
Description : 2000 Question with Answer
โน151[โน500]
6.
Bank of Baroda IT (API Developer) Exam - English
Description : 3000 Question with Answer
โน181[โน500]
7.
Bank of Baroda IT (API Developer) Exam - Hindi
Description : 1000 Question & Answer Download in PDF (Send by Email)
โน151[โน450]
8.
Bank of Baroda IT (API Developer) Exam - English
Description : 1000 Question & Answer Download in PDF (Send by Email)
โน151[โน450]
9.
Bank of Baroda IT (API Developer) Exam Question Bank Book - Hindi
Description : 1000 Question with Answer (Printed Material)
โน450[โน800]
10.
Bank of Baroda IT (API Developer) Exam Question Bank Book - English
Description : 1000 Question with Answer (Printed Material)
โน390[โน600]
English
Question 51Single Answer
I go to Madurai by โโ Vaigai Express
A
a
B
an
C
some
D
the
Question 52Single Answer
Have the car stolen!
A
Steal the car
B
You should have the stolen car
C
Get someone to steal the car
D
They have stolen the car
Question 53Single Answer
The payment was collected by the hardworking salesman.
A
The hardworking salesman collected the payment.
B
the salesman who worked heard was able to collect the payment.
C
to collect the payment the salesman had to work hard.
D
The hardworking salesman was able to collect the payment.
Question 54Single Answer
I had to stop all my work to complete this project.
A
All other work had to be stopped to complete this project by me
B
For completing this project all other work must be stopped
C
For completing this project I had to stop all my work
D
To complete this project all other work had been stopped by me
Question 55Single Answer
They have published the names of all the successful candidates.
A
The candidates who have succeeded their names they had published.
B
The names of all the successful candidates have been published by them
C
The candidates who have succeeded their names have been published by them.
D
The names of all the successful candidate were published by them.ย
Question 56Single Answer
The online shopping site lowered the prices.
A
Lowering of the prices was done by the online shopping site
B
The prices were lowered by the online shopping site
C
The prices had been lowered by the online shopping site
D
The prices have been lowered by the online shopping site
Question 57Single Answer
Who taught you to drive a truck ?
A
To drive a truck by whom were you taught?
B
Driving a truck by who were you taught?
C
Driving a truck by who were you being taught?
D
By whom were you taught to drive a truck?
Question 58Single Answer
We shall invite Suresh.
A
Suresh would be invited by us
B
Suresh would have been invited by us
C
Suresh will be invited by us
D
Suresh will have been invited by us
Question 59Single Answer
Dark clouds have overcast the evening sky.
A
By the dark clouds the evening sky was overcast.
B
The evening sky has been overcast by the dark clouds.
C
Dark clouds overcastted the evening sky.
D
The sky of the evening was overcasted by dark clouds.
Question 60Single Answer
The partners will celebrate their triumph tomorrow.ย
A
The triumph would be celebrated by the partners a day before
B
The triumph would be celebrated by the partners a day after
C
The triumph would have been celebrated by the partners a day after
D
The triumph will have been celebrated by the partners tomorrow
Question 61Single Answer
Why did break the vase?
A
why is the vase broken by him
B
why was the vase broken by him
C
why had been the vase broken by him
D
why has been the vase broken by him
Question 62Single Answer
Mariam was writing a note to her boss.
A
A note was written to her boss by Mariam
B
A note was wrote by Mariam to her boss
C
A note was being written by Mariam to her boss
D
A note was written by Mariam to her boss
Question 63Single Answer
The baby really enjoys that music.
A
That music was really enjoyed by the baby.
B
That music was really being enjoyed by the baby.
C
That music is really enjoyed by the baby.
D
This music was really enjoyed by the baby.
Question 64Single Answer
The weather disrupted the final match.
A
The final match has been disrupted by the weather.
B
The final match had been disrupted by the weather.
C
The final match was disrupted by the weather.ย
D
The final match was being disrupted by the weather.
Question 65Single Answer
The management committee is required to publish a report every year.ย
A
report would be published by the management committee every year.
B
A report would have been published by the management committee every year.
C
A report requires to be published by the management committee every year.
D
Every year the report would be published by the management committee.
Bank of Baroda IT (API Developer) Exam - English
Question 66Single Answer
Passage :
Direction :ย Question below has two blanks, each blank indicting that some thing has been omitted. Choose the word for each blank which best fits the meaning of the sentence as a whole.
The Finance Department has โฆโฆโฆโฆโฆa centralized online databank system for all statutory government bodies to โฆโฆโฆโฆan eye on their assets and liabilities.
A
ย presented , stay
B
introduced , keep
C
announce , make
D
created , let
E
proclaimed , hold
Question 67Single Answer
Passage :
Direction : The five items in this section consists of a word or group of words followed by four words as (a), (b), (c) and (d). Select the word which is nearly opposite to the meaning of the original word or group of words and mark your response as (a), (b), (c) and (d), as the case may be, in your Answer Sheet.
Assets
A
liabilities
B
responsibilities
C
estates
D
profits
Question 68Single Answer
Passage :
Direction :ย In the question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Affidavit
A
ย Affirmation
B
Slander
C
Oath
D
Testimony
Question 69Single Answer
Passage :
Direction:ย In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Hollow
A
Alveolate
B
Cleft
C
ย Cavernous
D
Solid
Question 70Single Answer
Passage :
Directions: In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Cossetย
A
Ignoreb
B
Close
C
Caress
D
Fondle
Question 71Single Answer
Passage :
Directions: In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Ogle
A
Leer
B
Gaze
C
Ignore
D
Gawk
Question 72Single Answer
Passage :
Directions:In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Intrinsic
A
Elemental
B
Innate
C
Connate
D
Acquired
Question 73Single Answer
Passage :
Direction :ย In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Coalesce
A
Separate
B
Adhere
C
Cleave
D
Amalgamate
Question 74Single Answer
Passage :
Directions:ย In the following question, out of the four alternatives, choose the word which is opposite in meaning to the given word and click the button corresponding to it
Loiter
A
lagย
B
Hasten
C
Amble
D
Loii
Question 75Single Answer
Passage :
Direction : Question below has two blanks, blank indicating that something has been omitted. Choose the set of words for blank which best fits the meaning of the sentence as a whole.
The protests were......... at ......... awareness among the elite and the educated.
A
held, generating
B
aimed, creating
C
targeted, awakening
D
focused, building
E
concentrated, producing
Professional Knowledge
Question 76Single Answer
Which of the following is not one of the ACID properties of transactions?
A
Atomicity
B
Consistency
C
Availability
D
Durability
Question 77Single Answer
Atomicity in ACID ensures that a transaction is treated as a ?
A
Single indivisible unit
B
Collection of independent statements
C
Partial execution set
D
Optional operation
Question 78Single Answer
Which ACID property guarantees that concurrent transactions do not interfere with each other?
A
Durability
B
Consistency
C
Atomicity
D
Isolation
Question 79Single Answer
Durability in ACID means that once a transaction is committed ?
A
It is visible only to the current session
B
It can still be rolled back
C
It becomes read-only
D
Its changes are permanent even in case of system failure
Question 80Single Answer
Which normal form eliminates transitive dependencies?
A
BCNF
B
2NF
C
1NF
D
3NF
Question 81Single Answer
A relation is in 2NF if it is in 1NF and ?
A
No partial dependency exists
B
No transitive dependency exists
C
Every determinant is a candidate key
D
It has no repeating groups
Question 82Single Answer
Boyce-Codd Normal Form (BCNF) is stronger than 3NF because ?
A
It removes transitive dependencies only
B
It eliminates partial dependencies only
C
It allows multi-valued dependencies
D
Every determinant must be a candidate key
Question 83Single Answer
Which of the following violates 1NF?
A
Transitive dependency
B
Partial dependency
C
Repeating groups / multi-valued attributes
D
Non-key determinant
Question 84Single Answer
In an ER diagram, a diamond shape represents ?
A
Entity
B
Relationship
C
Attribute
D
Key
Question 85Single Answer
In an ER diagram, a double rectangle represents ?
A
Multi-valued attribute
B
Strong entity
C
Weak entity
D
Derived attribute
Question 86Single Answer
A dashed underline in ER diagram indicates ?
A
Foreign key
B
Primary key
C
Partial key of weak entity
D
Composite key
Question 87Single Answer
A double diamond in ER diagram denotes ?
A
Identifying relationship
B
Regular relationship
C
Recursive relationship
D
Ternary relationship
Question 88Single Answer
Which SQL command is used to retrieve data from one or more tables?
A
DELETE
B
INSERT
C
UPDATE
D
SELECT
Question 89Single Answer
Which clause is mandatory in a SELECT statement?
A
FROM
B
WHERE
C
GROUP BY
D
HAVING
Question 90Single Answer
The SQL command that permanently removes rows from a table is ?
A
DROP
B
DELETE
C
TRUNCATE
D
Both A and C
Question 91Single Answer
Which command removes the entire table including structure?
A
DELETE TABLE
B
DROP TABLE
C
TRUNCATE TABLE
D
REMOVE TABLE
Question 92Single Answer
The command used to modify existing records in a table is ?
A
ALTER
B
UPDATE
C
MODIFY
D
CHANGE
Question 93Single Answer
Which SQL clause is used to filter groups after aggregation?
A
HAVING
B
WHERE
C
GROUP BY
D
ORDER BY
Question 94Single Answer
Which join returns all rows from left table and matching rows from right table?
A
LEFT OUTER JOIN
B
RIGHT OUTER JOIN
C
FULL OUTER JOIN
D
INNER JOIN
Question 95Single Answer
A CROSS JOIN produces ?
A
No rows
B
Only matching rows
C
Only non-matching rows
D
Cartesian product of two tables
Question 96Single Answer
Which subquery is executed once for the outer query?
A
Correlated subquery
B
Non-correlated subquery
C
Scalar subquery
D
Row subquery
Question 97Single Answer
A correlated subquery ?
A
Returns multiple rows
B
Is independent of outer query
C
References column from outer query
D
Cannot be used in WHERE
Question 98Single Answer
Which DDL command is used to modify table structure?
A
CHANGE TABLE
B
MODIFY TABLE
C
ALTER TABLE
D
UPDATE TABLE
Question 99Single Answer
The DCL command used to give privileges to a user is ?
A
COMMIT
B
REVOKE
C
GRANT
D
ROLLBACK
Question 100Single Answer
The command that removes privileges from a user is ?
A
REVOKE
B
GRANT
C
DENY
D
DROP
Question 101Single Answer
Which indexing technique organizes data in sorted order?
A
Full-text index
B
Hash index
C
Bitmap index
D
B-Tree index
Question 102Single Answer
B-Tree indexes are most suitable for ?
A
Exact match only
B
Range queries and equality searches
C
Text search
D
Bitmap operations
Question 103Single Answer
Hash indexes are efficient for ?
A
Grouping
B
Range queries
C
Sorting
D
Equality comparisons only
Question 104Single Answer
Bitmap indexes are most effective on columns with ?
A
Continuous values
B
High cardinality
C
Unique values
D
Low cardinality
Question 105Single Answer
Which isolation level allows dirty reads?
A
Read Uncommitted
B
Read Committed
C
Repeatable Read
D
Serializable
Question 106Single Answer
The highest isolation level that prevents phantom reads is ?
A
Repeatable Read
B
Serializable
C
Read Committed
D
Read Uncommitted
Question 107Single Answer
Which isolation level is the default in most databases?
A
Serializable
B
Read Committed
C
Repeatable Read
D
Read Uncommitted
Question 108Single Answer
In MongoDB, the default storage engine is ?
A
RocksDB
B
MMAPv1
C
WiredTiger
D
In-Memory
Question 109Single Answer
Which NoSQL database is schema-less and document-oriented?
A
Redis
B
Cassandra
C
MongoDB
D
Neo4j
Question 110Single Answer
Cassandra is best classified as a ?
A
Key-value store
B
Document store
C
Wide-column store
D
Graph database
Question 111Single Answer
Which command creates a new table in SQL?
A
MAKE TABLE
B
NEW TABLE
C
ADD TABLE
D
CREATE TABLE
Question 112Single Answer
The command to add a column to an existing table is ?
A
UPDATE TABLE ... ADD
B
MODIFY TABLE ... ADD
C
ALTER TABLE ... ADD COLUMN
D
INSERT COLUMN
Question 113Single Answer
Which command removes a column from a table?
A
ALTER TABLE ... DROP COLUMN
B
DELETE COLUMN
C
REMOVE COLUMN
D
TRUNCATE COLUMN
Question 114Single Answer
The SQL command to create an index is ?
A
NEW INDEX
B
ADD INDEX
C
CREATE INDEX
D
MAKE INDEX
Question 115Single Answer
Which clause is used to sort the result set in SQL?
A
ARRANGE BY
B
SORT BY
C
GROUP BY
D
ORDER BY
Question 116Single Answer
To eliminate duplicate rows from the result set we use ?
A
UNIQUE
B
DISTINCT
C
GROUP BY
D
HAVING
Question 117Single Answer
The command used to remove all rows from a table but keep structure is ?
A
DELETE TABLE
B
TRUNCATE TABLE
C
DROP TABLE
D
REMOVE TABLE
Question 118Single Answer
Which constraint ensures that all values in a column are unique?
A
PRIMARY KEY
B
UNIQUE
C
FOREIGN KEY
D
CHECK
Question 119Single Answer
A PRIMARY KEY constraint automatically creates ?
A
Non-unique index
B
Unique index
C
Clustered index only
D
No index
Question 120Single Answer
A FOREIGN KEY constraint is used to enforce ?
A
Referential integrity
B
Domain integrity
C
Entity integrity
D
User-defined integrity
Question 121Single Answer
Which command is used to start a transaction in SQL?
A
BEGIN
B
START
C
BEGIN TRANSACTION or START TRANSACTION
D
INIT
Question 122Single Answer
The command to permanently save changes in a transaction is ?
A
END
B
ROLLBACK
C
SAVEPOINT
D
COMMIT
Question 123Single Answer
The command to undo changes since last COMMIT is ?
A
CANCEL
B
COMMIT
C
UNDO
D
ROLLBACK
Question 124Single Answer
A SAVEPOINT in transaction allows ?
A
Transaction end
B
Full commit
C
No rollback
D
Partial rollback to a named point
Question 125Single Answer
Which isolation level prevents dirty reads but allows non-repeatable reads?
A
Read Committed
B
Read Uncommitted
C
Repeatable Read
D
Serializable
Question 126Single Answer
Which isolation level prevents non-repeatable reads?
A
Read Committed
B
Repeatable Read
C
Read Uncommitted
D
Serializable
Question 127Single Answer
In B-Tree index, the leaf nodes contain ?
A
No data
B
Only keys
C
Actual data pointers or values
D
Parent pointers
Question 128Single Answer
B+Tree differs from B-Tree because ?
A
Only root has data
B
Data is stored in internal nodes
C
No linking
D
Leaf nodes are linked and store data only in leaves
Question 129Single Answer
Hash indexes are best for ?
A
Sorting
B
Range queries
C
Exact match queries
D
Joins
Question 130Single Answer
Bitmap indexes are very efficient for columns with ?
A
High cardinality
B
Low distinct values (low cardinality)
C
Unique values
D
Text data
Question 131Single Answer
Which command creates a composite index?
A
CREATE INDEX idx_name ON table(col1, col2)
B
CREATE INDEX ON col1, col2
C
ADD INDEX col1 col2
D
NEW INDEX col1 col2
Question 132Single Answer
Covering index means ?
A
No covering
B
Index covers only key
C
Index contains all columns needed by the query
D
Partial cover
Question 133Single Answer
Clustered index determines ?
A
No order
B
Logical order only
C
Physical order of data rows in table
D
Secondary order
Question 134Single Answer
A table can have how many clustered indexes?
A
Zero
B
Multiple
C
Unlimited
D
Only one
Question 135Single Answer
Non-clustered index stores ?
A
No pointer
B
Actual data
C
Pointers to data rows
D
Key only
Question 136Single Answer
MongoDB stores data in ?
A
BSON documents
B
Tables
C
Rows
D
Columns
Question 137Single Answer
In MongoDB, a collection is analogous to ?
A
Row
B
Table in RDBMS
C
Column
D
Database
Question 138Single Answer
Cassandra is designed for ?
A
High write throughput and linear scalability
B
High read only
C
Small data
D
ACID transactions
Question 139Single Answer
Which NoSQL database is best for time-series API logs?
A
MySQL
B
Cassandra or MongoDB
C
PostgreSQL
D
Oracle
Question 140Single Answer
In MongoDB, the command to insert a document is ?
A
CREATE ROW
B
INSERT INTO
C
ADD DOCUMENT
D
db.collection.insertOne() or insertMany()
Question 141Single Answer
The command to find documents in MongoDB is ?
A
SELECT
B
db.collection.find()
C
GET
D
QUERY
Question 142Single Answer
Which MongoDB operator is used for greater than comparison?