📚 Exam by Category
▾
Objective Questions

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
Back to Exam

Data Base Administrator

Question 1Single Answer
Which of the following is a key advantage of using a Database Management System (DBMS)?
  1. A
    Data redundancy
  2. B
    Data inconsistency
  3. C
    Centralized data management
  4. D
    Difficulty in backup and recovery
Question 2Single Answer
What does DBMS stand for?
  1. A
    Data Backup Management System
  2. B
    Data Base Management System
  3. C
    Distributed Binary Management System
  4. D
    Data Block Management System
Question 3Single Answer
Which of the following is NOT a type of DBMS?
  1. A
    Relational DBMS (RDBMS)
  2. B
    Network DBMS
  3. C
    Object-Oriented DBMS
  4. D
    Command Line DBMS
Question 4Single Answer
Which of these DBMS types is known for its ability to store unstructured data like documents, images, and videos?
  1. A
    Relational DBMS
  2. B
    NoSQL DBMS
  3. C
    Network DBMS
  4. D
    Object-Oriented DBMS
Question 5Single Answer
What is a major disadvantage of using a traditional file processing system over a DBMS?
  1. A
    Data redundancy and inconsistency
  2. B
    Centralized data management
  3. C
    Reduced data integrity
  4. D
    Real-time access to data
Question 6Single Answer
Which of the following is a characteristic of a Relational DBMS (RDBMS)?
  1. A
    Stores data in tables and relationships between them
  2. B
    Uses hierarchical data storage
  3. C
    Supports only text-based data
  4. D
    Does not allow data normalization
Question 7Single Answer
Which of the following DBMS types is used for highly scalable applications with large amounts of data?
  1. A
    Relational DBMS
  2. B
    NoSQL DBMS
  3. C
    Object-Oriented DBMS
  4. D
    File-Based DBMS
Question 8Single Answer
What is a key feature of NoSQL databases?
  1. A
    Strong consistency
  2. B
    Ability to handle large volumes of unstructured data
  3. C
    Use of SQL for querying
  4. D
    Fixed schema design
Question 9Single Answer
Which of the following is a benefit of DBMS over traditional file systems?
  1. A
    Increased data redundancy
  2. B
    Complex user interfaces
  3. C
    Easier data retrieval and management
  4. D
    Lack of backup facilities
Question 10Single Answer
Which of the following is an example of a widely used RDBMS?
  1. A
    MongoDB
  2. B
    Oracle Database
  3. C
    Hadoop
  4. D
    Redis
Question 11Single Answer
Which of the following DBMS types provides a more flexible way of handling hierarchical data?
  1. A
    Relational DBMS
  2. B
    Network DBMS
  3. C
    Object-Oriented DBMS
  4. D
    NoSQL DBMS
Question 12Single Answer
Which of the following is a primary feature of a DBMS?
  1. A
    Data is stored as flat files
  2. B
    Data is stored in tables and can be easily queried
  3. C
    It does not support data integrity
  4. D
    It does not allow backup operations
Question 13Single Answer
What is an Entity-Relationship (ER) Model used for in database design?
  1. A
    To define the database structure and relationships between entities
  2. B
    To store unstructured data
  3. C
    To manage complex queries
  4. D
    To execute stored procedures
Question 14Single Answer
In an ER diagram, what does a rectangle represent?
  1. A
    An attribute
  2. B
    A relationship
  3. C
    An entity
  4. D
    A primary key
Question 15Single Answer
What does 1NF (First Normal Form) require in database design?
  1. A
    Elimination of duplicate rows and atomicity of data
  2. B
    Elimination of all redundant data
  3. C
    Avoidance of foreign keys
  4. D
    Storing data in non-relational format
Question 16Single Answer
Which of the following is a characteristic of 2NF (Second Normal Form)?
  1. A
    Elimination of partial dependency
  2. B
    All non-key attributes are dependent on the primary key
  3. C
    Elimination of transitive dependency
  4. D
    Storing only atomic values
Question 17Single Answer
What does 3NF (Third Normal Form) ensure in database design?
  1. A
    Elimination of transitive dependency
  2. B
    Avoidance of primary keys
  3. C
    Redundancy in data
  4. D
    Multiple foreign keys
Question 18Single Answer
What is the main purpose of database normalization?
  1. A
    To improve the storage capacity of the database
  2. B
    To reduce data redundancy and ensure data integrity
  3. C
    To store data in non-relational format
  4. D
    To ensure faster retrieval of data
Question 19Single Answer
Which of the following is an example of a violation of 3NF?
  1. A
    Storing a student’s name and age in the same table as their course
  2. B
    Storing product information in a separate table
  3. C
    Using a unique primary key for every record
  4. D
    Storing data in separate tables for normalization
Question 20Single Answer
Which of the following is the correct way to perform denormalization?
  1. A
    Splitting a table into smaller tables
  2. B
    Merging tables to reduce joins in queries
  3. C
    Deleting redundant data
  4. D
    Removing foreign keys
Question 21Single Answer
What is denormalization typically used for?
  1. A
    To improve data integrity
  2. B
    To increase query performance by reducing joins
  3. C
    To store data in non-relational format
  4. D
    To avoid primary keys
Question 22Single Answer
Which of the following is the main purpose of a database schema?
  1. A
    To specify data types and relationships among tables
  2. B
    To increase redundancy
  3. C
    To store unstructured data
  4. D
    To generate backup copies of the database
Question 23Single Answer
What does the term "foreign key" refer to in a relational database?
  1. A
    A primary key of a table
  2. B
    A key used to establish relationships between two tables
  3. C
    A unique identifier for records
  4. D
    A key used for indexing data
Question 24Single Answer
What is the result of violating normalization rules in database design?
  1. A
    Increased redundancy and possible data anomalies
  2. B
    Decreased storage requirements
  3. C
    Better user experience
  4. D
    Decreased complexity of queries
Question 25Single Answer
Which of the following is typically the first step in database design?
  1. A
    Data normalization
  2. B
    ER modeling
  3. C
    Table creation
  4. D
    Data querying

Logical Reasoning

Question 26Single Answer
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?
  1. A
    Two
  2. B
    Three
  3. C
    Five
  4. D
    Four
  5. E
    None of these
Question 27Single 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
  1. A
    True
  2. B
    False
  3. C
    Uncertain
  4. D
    None
Question 28Single 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.
  1. A
    A
  2. B
    E
  3. C
    T
  4. D
    X
  5. E
    Y
Question 29Single 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?
  1. A
    None            
  2. B
    One         
  3. C
    Two       
  4. D
    Three        
  5. E
    More than three
Question 30Single 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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 31Single Answer
How many meaningful words can be made from the letters ‘LMEA’ using each letter only once in each word?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 32Single 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.
  1. A
    T
  2. B
    L
  3. C
    E
  4. D
    Y
  5. E
    X
Question 33Single Answer
If the letters of the word HANDOVER are arranged alphabetically from left to right how many letters will remain at the same position?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 34Single 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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 35Single 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’.
  1. A
    V
  2. B
    T
  3. C
    E
  4. D
    A
  5. E
    B
Question 36Single 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 ?
  1. A
    N
  2. B
    Q
  3. C
    J
  4. D
    M
  5. E
    None of these
Question 37Single 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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    None of these
Question 38Single 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 .
  1. A
    The only argument I is strong
  2. B
    Only argument II is strong
  3. C
    Either I or II is strong
  4. D
    Neither I nor II is strong
Question 39Single 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’.
  1. A
    P
  2. B
    L
  3. C
    T
  4. D
    X
  5. E
    Y
Question 40Single Answer
How many meaningful English words can be formed with the letters RAE using each letter only once in each word?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 41Single Answer
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?
  1. A
    One
  2. B
    Two
  3. C
    Three
  4. D
    Four
  5. E
    More than four
Question 42Single Answer
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.
  1. A
    I
  2. B
    A
  3. C
    L
  4. D
    M
  5. E
    N
Question 43Single Answer
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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 44Single Answer
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?
  1. A
    26
  2. B
    28
  3. C
    30
  4. D
    32
  5. E
    None of these
Question 45Single Answer
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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 46Single Answer
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?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 47Single Answer
How many meaningful English words can be formed with the letters LMAE using each letter only once in each word?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. E
    More than three
Question 48Single Answer
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?
  1. A
    P                 
  2. B
    Q            
  3. C
    B              
  4. D
    K              
  5. E
    None of these
Question 49Single Answer
If the letters in the word AMONGST are arranged in the English alphabetical order, the position of how many letters will remain unchanged?
  1. A
    None
  2. B
    One
  3. C
    Three
  4. D
    Four
  5. E
    More than Four
Question 50Single Answer
How many meaningful English words can be formed with the letters ACRS using each letter only once in each word?
  1. A
    None
  2. B
    One
  3. C
    Two
  4. D
    Three
  5. 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 NameAmount
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 : 1000 Question & Answer Download in PDF (Send by Email)
₹151 [₹550]
8.Canara Bank SO Exam (Data Base Administrator) Question Bank Book - English
Description : 1000 Question with Answer (Printed Material)
₹560 [₹650]
9.Canara Bank SO Exam (Network Administrator) Question Bank Book - English
Description : 1000 Question with Answer (Printed Material)
₹390 [₹650]
10.Canara Bank SO Exam (Network Administrator) - English
Description : 1000 Question & Answer Download in PDF (Send by Email)
₹151 [₹550]
11.Canara Bank SO Exam (System Administrator) - English
Description : 1000 Question & Answer Download in PDF (Send by Email)
₹151 [₹550]
12.Canara Bank SO Exam (System Administrator) Question Bank Book- English
Description : 1000 Question with Answer (Printed Material)
₹390 [₹650]
Back to Exam
Question for Canara Bank Specialist Officer 2026 - Quiz / Questions / MCQ - Toppersexam