To boost your performance in Canara Bank SO exam, practice each question regularly and with focus. Every question tests your subject understanding, so solve them one at a time. Taking a quiz improves your speed and accuracy. Practicing topic-wise MCQs. Students benefit greatly from reviewing questions with answer keys, which help clarify concepts and strengthen Questions knowledge for success in Canara Bank SO exams.
Latest Canara Bank SO Exam Question (Objective Questions), MCQ in English
Subjects : Data Base Administrator, Logical Reasoning
Question Bank Canara Bank SO Exam (Data Base Administrator) - English
Data Base Administrator
Q 1 :
Which of the following is a key advantage of using a Database Management System (DBMS)?
A.Data redundancy
B.Data inconsistency
C.Centralized data management
D.Difficulty in backup and recovery
Q 2 :
What does DBMS stand for?
A.Data Backup Management System
B.Data Base Management System
C.Distributed Binary Management System
D.Data Block Management System
Q 3 :
Which of the following is NOT a type of DBMS?
A.Relational DBMS (RDBMS)
B.Network DBMS
C.Object-Oriented DBMS
D.Command Line DBMS
Q 4 :
Which of these DBMS types is known for its ability to store unstructured data like documents, images, and videos?
A.Relational DBMS
B.NoSQL DBMS
C.Network DBMS
D.Object-Oriented DBMS
Q 5 :
What is a major disadvantage of using a traditional file processing system over a DBMS?
A.Data redundancy and inconsistency
B.Centralized data management
C.Reduced data integrity
D.Real-time access to data
Q 6 :
Which of the following is a characteristic of a Relational DBMS (RDBMS)?
A.Stores data in tables and relationships between them
B.Uses hierarchical data storage
C.Supports only text-based data
D.Does not allow data normalization
Q 7 :
Which of the following DBMS types is used for highly scalable applications with large amounts of data?
A.Relational DBMS
B.NoSQL DBMS
C.Object-Oriented DBMS
D.File-Based DBMS
Q 8 :
What is a key feature of NoSQL databases?
A.Strong consistency
B.Ability to handle large volumes of unstructured data
C.Use of SQL for querying
D.Fixed schema design
Q 9 :
Which of the following is a benefit of DBMS over traditional file systems?
A.Increased data redundancy
B.Complex user interfaces
C.Easier data retrieval and management
D.Lack of backup facilities
Q 10 :
Which of the following is an example of a widely used RDBMS?
A.MongoDB
B.Oracle Database
C.Hadoop
D.Redis
Q 11 :
Which of the following DBMS types provides a more flexible way of handling hierarchical data?
A.Relational DBMS
B.Network DBMS
C.Object-Oriented DBMS
D.NoSQL DBMS
Q 12 :
Which of the following is a primary feature of a DBMS?
A.Data is stored as flat files
B.Data is stored in tables and can be easily queried
C.It does not support data integrity
D.It does not allow backup operations
Q 13 :
What is an Entity-Relationship (ER) Model used for in database design?
A.To define the database structure and relationships between entities
B.To store unstructured data
C.To manage complex queries
D.To execute stored procedures
Q 14 :
In an ER diagram, what does a rectangle represent?
A.An attribute
B.A relationship
C.An entity
D.A primary key
Q 15 :
What does 1NF (First Normal Form) require in database design?
A.Elimination of duplicate rows and atomicity of data
B.Elimination of all redundant data
C.Avoidance of foreign keys
D.Storing data in non-relational format
Q 16 :
Which of the following is a characteristic of 2NF (Second Normal Form)?
A.Elimination of partial dependency
B.All non-key attributes are dependent on the primary key
C.Elimination of transitive dependency
D.Storing only atomic values
Q 17 :
What does 3NF (Third Normal Form) ensure in database design?
A.Elimination of transitive dependency
B.Avoidance of primary keys
C.Redundancy in data
D.Multiple foreign keys
Q 18 :
What is the main purpose of database normalization?
A.To improve the storage capacity of the database
B.To reduce data redundancy and ensure data integrity
C.To store data in non-relational format
D.To ensure faster retrieval of data
Q 19 :
Which of the following is an example of a violation of 3NF?
A.Storing a student’s name and age in the same table as their course
B.Storing product information in a separate table
C.Using a unique primary key for every record
D.Storing data in separate tables for normalization
Q 20 :
Which of the following is the correct way to perform denormalization?
A.Splitting a table into smaller tables
B.Merging tables to reduce joins in queries
C.Deleting redundant data
D.Removing foreign keys
Q 21 :
What is denormalization typically used for?
A.To improve data integrity
B.To increase query performance by reducing joins
C.To store data in non-relational format
D.To avoid primary keys
Q 22 :
Which of the following is the main purpose of a database schema?
A.To specify data types and relationships among tables
B.To increase redundancy
C.To store unstructured data
D.To generate backup copies of the database
Q 23 :
What does the term "foreign key" refer to in a relational database?
A.A primary key of a table
B.A key used to establish relationships between two tables
C.A unique identifier for records
D.A key used for indexing data
Q 24 :
What is the result of violating normalization rules in database design?
A.Increased redundancy and possible data anomalies
B.Decreased storage requirements
C.Better user experience
D.Decreased complexity of queries
Q 25 :
Which of the following is typically the first step in database design?
A.Data normalization
B.ER modeling
C.Table creation
D.Data querying
Logical Reasoning
Q 26 :
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
Q 27 :
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
Q 28 :
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
Q 29 :
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
Q 30 :
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
Q 31 :
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
Q 32 :
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
Q 33 :
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
Q 34 :
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
Q 35 :
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
Q 36 :
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
Q 37 :
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
Q 38 :
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
Q 39 :
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
Q 40 :
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
Q 41 :
How many such pairs of letters are there in the word WONDERS, each of which has as many letters between its two letters as there are between them in the English alphabet?
A.One
B.Two
C.Three
D.Four
E.More than four
Q 42 :
If it is possible to make only one meaningful English word from the second, the fifth, the seventh and the eighth letters of the word PHYSICAL, using each letter only once, second letter of that word is your answer. If more than one such word can be formed your answer is M. if no such word can be formed your answer is N.
A.I
B.A
C.L
D.M
E.N
Q 43 :
How many such pairs of letters are there in the word JUSTIFY, each of which have as many letters between them in the word as they have between them in the English alphabet?
A.None
B.One
C.Two
D.Three
E.More than three
Q 44 :
If the alphabets are assigned values as A=3, D=6, G=8, I=2, L=4 and T=5 then what is the sum of values of all the alphabets in the word DIGITAL?
A.26
B.28
C.30
D.32
E.None of these
Q 45 :
How many such pairs of letters are there in the word EDUCATION, 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
Q 46 :
How many such pairs of letters are there in the word MEASURE 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
Q 47 :
How many meaningful English words can be formed with the letters LMAE using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 48 :
If each consonant in the word EXPLORATION is replaced by previous the alphabet and each vowel replaced by alphabet following it in the English alphabetic series, and then the order of the alphabets thus formed is reversed, which of the following from the right?
A.P
B.Q
C.B
D.K
E.None of these
Q 49 :
If the letters in the word AMONGST are arranged in the English alphabetical order, the position of how many letters will remain unchanged?
A.None
B.One
C.Three
D.Four
E.More than Four
Q 50 :
How many meaningful English words can be formed with the letters ACRS using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Important Questions Package
Canara Bank SO Exam Online Question Bank Package
Buy Canara Bank SO Important Questions, MCQ, question answer in Hindi & English. It will help you to score high marks in Canara Bank SO question bank 2026 in Online, PDF & Print study material.
+ Free Monthly Current Affairs, GK & more PDF Download
Sr.
Package Name
Amount
1.
Canara Bank SO Exam (Data Base Administrator) - English
Description : 1000 Question With Answer
₹101[₹500]
2.
Canara Bank SO Exam (Data Base Administrator) - English
Description : 1800 Question With Answer
₹131[₹500]
3.
Canara Bank SO Exam (Network Administrator) - English
Description : 1000 Question With Answer
₹101[₹500]
4.
Canara Bank SO Exam (Network Administrator) - English
Description : 1900 Question Wtih Answer
₹131[₹500]
5.
Canara Bank SO Exam (System Administrator) - English
Description : 1800 Question With Answer
₹131[₹500]
6.
Canara Bank SO Exam (System Administrator) - English
Description : 1000 Question With Answer
₹101[₹500]
7.
Canara Bank SO Exam (Data Base Administrator) - English
Description : <span style="color:#800000"><strong><span style="font-size:16px"><span style="font-family:georgia,serif">1000 Question & Answer Download in PDF (Send by Email)</span></span></strong></span>
₹151[₹550]
8.
Canara Bank SO Exam (Data Base Administrator) Question Bank Book - English
Canara Bank SO Exam (Network Administrator) - English
Description : <span style="color:#800000"><strong><span style="font-size:16px"><span style="font-family:georgia,serif">1000 Question & Answer Download in PDF (Send by Email)</span></span></strong></span>
₹151[₹550]
11.
Canara Bank SO Exam (System Administrator) - English
Description : <span style="color:#800000"><strong><span style="font-size:16px"><span style="font-family:georgia,serif">1000 Question & Answer Download in PDF (Send by Email)</span></span></strong></span>
₹151[₹550]
12.
Canara Bank SO Exam (System Administrator) Question Bank Book- English
How many such pairs of letters there in the word, UNWANTED, each of which has as many letters between its two letters as there are between them in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 52 :
How many meaningful English words can be made with the letters EIND using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.None of these
Q 53 :
How many such pairs of letters are there in the word, ‘TROUBLE’, each of which has as many letters between its two letters as there are between them in the English alphabet?
A.None
B.One
C.Two
D.Three
E.None of these
Q 54 :
How many such pairs of letters there in the word DOUBTS each of which has as many letters between its two letters as there are between them in the English alphabet?
A.None
B.One
C.Two
D.Three
E.None of these
Q 55 :
How many meaningful English words can be made with the letters ESDO using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.None of these
Q 56 :
How many such pairs of letters there in the word, BONDING each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.None of these
Q 57 :
How many such pairs of letters are there in the word CHARGES each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.None of these
Q 58 :
How many meaningful English words can be made with the letters EDSU using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 59 :
How many meaningful English words can be made with the letters RTOU using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 60 :
How many such pairs of letters are there in the word ENGULFED each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 61 :
How many such pairs of letters are there in the word CORPORATE each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 62 :
If it is possible to make only one meaningful word with the first, second, fifth and sixth letters of the word ‘EDUCATION’, which would be the last letter of the word? If more than one such word can be formed, give X as the answer. If no such word can be formed, give K as your answer.
A.T
B.X
C.A
D.E
E.K
Q 63 :
How many meaningful English words can be made with the letters ‘OEHM’ using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 64 :
How many such pairs of letters are there in the word CONFIRM each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 65 :
If JOSEPH is coded as FKOALD, then GEORGE will be coded as
A.CAKNCA
B.CADMNO
C.CAKNIT
D.JAKINS
Q 66 :
How many such pairs of letters are there in the word TAILSPIN each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 67 :
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 is in the middle of 13th letter from the left and 4th letter from the right ?
A.R
B.I
C.J
D.S
Q 68 :
How many such pairs of letters are there in the word MINORITY each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 69 :
How many such pairs of letters are there in the word CHARIOT each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 70 :
If it is possible to make only one meaning word with the first, second, fourth, and the sixth letters of the word ’STARVING’ . Which would be the second letter of the word from the right end? If more than one such word can be formed, give X as the answer. If no such word can be formed, give K as your answer.
A.T
B.S
C.X
D.I
E.K
Q 71 :
How many such pairs of letters are there in the word ELUSIVE each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 72 :
If it is possible to make only one meaning word with the first, third, fifth, and the ninth letters of the word ’CURVATURE’ . Which would be the second letter of the word ? If more than one such word can be formed, give X as the answer. If no such word can be formed, give K as your answer.
A.R
B.D
C.X
D.I
E.K
Q 73 :
If in certain code MONKEY is written as ZFLOPN then in the same code how CHARACTER is written ?
A.SFUBIDDBS
B.SFUDBSBID
C.SFUDBSCID
D.SFUDBEBID
Q 74 :
How many meaningful English words can be made with the letters NNEO using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 75 :
If MADRAS can be written as NBESBT, how can BOMBAY be written in that code ?
A.CPNCBX
B.CPNCBZ
C.CPOCBZ
D.CQOCBZ
Q 76 :
How many such pairs of letters are there in the word CONSUMER each of which has as many pairs of letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 77 :
How many such pairs of letters are there in the word SEAMING each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.More than three
Q 78 :
If each vowel in the word DEFAULTS is changed to the next letter in the English alphabetical series and each consonant is changed to the previous letter in the English alphabetical series, how many alphabets will appear twice in the new formation?
A.None
B.One
C.Two
D.Three
E.Four
Q 79 :
How many such pairs of letters are there in the word RATIONS each of which has as many letters between them in the word (in both forward and backward directions) as they have between them in the English alphabetical series?
A.None
B.One
C.Two
D.Three
E.More than three
Q 80 :
If it is possible to make only one meaning word with the first, fifth, seventh, and the eleventh letters of the word ’RECIPROCATE’. Which would be the second letter of the word from the left? If more than one such word can be formed, give X as the answer. If no such word can be formed, give Z as your answer.
A.R
B.P
C.E
D.X
E.Z
Q 81 :
How many meaningful English words can be made from the letters EAP, using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.four
Q 82 :
If each vowel of the word SILVER is changed to the previous letter in the English alphabetical series and each consonant is changed to the next letter in the English alphabetical series and then the alphabets thus formed are arranged in alphabetical order from left to right, which of the following will be fourth from the left?
A.M
B.S
C.T
D.H
E.W
Q 83 :
The positions of how many alphabets well remain the same if each of the alphabets in the word PROFIT is rearranged in the alphabetical order from the left to right?
A.None
B.One
C.Two
D.Three
E.More than three
Q 84 :
If MADRAS can be written as ARSARS, how can ARKONAM be written in that code ?
A.ROAAKNM
B.ROAKANM
C.ROAKNNM
D.ROKANAM
E.ROANKNM
Q 85 :
If each of the alphabets in the word FAINTED is arranged in alphabetical order from left to right and then each vowel is changed to the next letter in the English alphabetical series and each consonant is changed to the previous letter in the English alphabetical series. Which of the following will be exactly in the middle of the new rearrangement thus formed?
A.F
B.E
C.J
D.I
E.O
Q 86 :
The positions of how many alphabets will remain the same if each of the alphabets in the word FRIENDS is rearranged in the alphabetical order from the left to right?
A.None
B.One
C.Two
D.Three
E.More than three
Q 87 :
How many meaningful English words can be made with the letters SWA using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 88 :
The positions of the first and the fourth letters of the word WORTHLY are interchanged, similarly, the positions of second and fifth letters and third and sixth letters are interchanged. In the new arrangement thus formed, how many letters are there between the letter which is third from the right and the letter which is third from the left, in the English alphabetical order?
A.None
B.One
C.Two
D.Three
E.More than three
Q 89 :
How many meaningful English words can be formed with the letters UOT using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 90 :
If each of the alphabets of the word COMPARE is arranged in alphabetical order from the left to right and then each vowel in the new word thus formed is changed to the next letter in the English alphabetical series and each consonant is changed to the previous letter in the English alphabetical series which of the following will be the fifth from the right?
A.F
B.P
C.L
D.E
E.O
Q 91 :
How many such pairs of letters are there in the word FORCES, each of which has as many letters between them in the word (in both forward and backward directions) as they have between them in the English alphabetical order?
A.None
B.One
C.Two
D.Three
E.More than three
Q 92 :
How many meaningful English words can be made with the letters STIF starting with F. using each letter-only once in each word?
A.None
B.One
C.Two
D.Three
E.More than three
Q 93 :
How many such pairs of letters are there in the word RELUCTANCE each of which has as many letters between them in the word (in both forward and backward directions) as they have between them in the English alphabetical series?
A.None
B.One
C.Two
D.Three
E.More than three
Q 94 :
If it is possible to make only one meaning word with the first, fifth, seventh, and the eighth letters of the word SPONTANEOUS, then the second letter from the left is your answer. If no such word can be formed, then your answer is X and if more than word such can be formed your answer is Y.
A.X
B.T
C.E
D.S
E.Y
Q 95 :
How many such pairs of letters are there in the word MERIT each of which has as many letters between them in the word as in the English alphabets?
A.None
B.One
C.Two
D.Three
E.FOUR
Q 96 :
How many meaningful English words can be formed with the letters IEST using each letter only once in each word?
A.Two
B.Three
C.Four
D.Five
E.None of these
Q 97 :
If the consonants in the word DROVE are first arranged alphabeticalliy and the vowels are put in between two pairs two pairs of consonants in the alphabetical order, which of the following will be the fourth from the right end after the rearrangement?
A.D
B.E
C.R
D.O
E.None of these
Q 98 :
How many meaningful English words can be made from the letters IRA, using each letter only once in each word?
A.None
B.One
C.Two
D.Three
E.Four
Q 99 :
How many such pairs of letters are there in the word INTRUDE each of which has as many letters between them in the word (in both forward and backward directions) as they have between them in the English alphabetical order?
A.None
B.One
C.Two
D.Three
E.Four
Q 100 :
If each of the vowels in the word HONESTLY is changed to the next letter in the English alphabetical series and each consonant is changed to the previous letter in the English alphabetical series, and then the alphabets so formed are arranged in alphabetical order from left to right, the positions of how many of the following alphabets will remain unchanged? (from that of before arranging in alphabetical order)
