๐Ÿ“š Exam by Category
โ–พ
Objective Questions

Latest MP Apex Bank Officer Computer Programmer Exam Question (Objective Questions), MCQ in English

Subjects : Professional Knowledge, Reasoning, English Language, General Awareness, Quantitative Aptitude

Question Bank MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Back to Exam

Professional Knowledge

Question 1Single Answer
The lowest level of data abstraction is?
  1. A
    Internal / Physical level
  2. B
    Conceptual level
  3. C
    External level
  4. D
    User level
Question 2Single Answer
An entity in ER model is?
  1. A
    Real-world object that is distinguishable
  2. B
    Relationship
  3. C
    Attribute
  4. D
    Key
Question 3Single Answer
A weak entity in ER diagram is represented by?
  1. A
    Double rectangle
  2. B
    Single rectangle
  3. C
    Diamond
  4. D
    Oval
Question 4Single Answer
A strong entity in ER diagram is represented by?
  1. A
    Single rectangle
  2. B
    Double rectangle
  3. C
    Double diamond
  4. D
    Circle
Question 5Single Answer
Relationship in ER model is represented by?
  1. A
    Diamond shape
  2. B
    Rectangle
  3. C
    Oval
  4. D
    Line
Question 6Single Answer
Attributes in ER model are represented by?
  1. A
    Oval
  2. B
    Rectangle
  3. C
    Diamond
  4. D
    Line
Question 7Single Answer
Key attribute (primary key) in ER diagram is underlined by?
  1. A
    Single line
  2. B
    Double line
  3. C
    Dotted line
  4. D
    No underline
Question 8Single Answer
Composite attribute in ER model is represented by?
  1. A
    Oval with branches
  2. B
    Single oval
  3. C
    Double oval
  4. D
    No branch
Question 9Single Answer
Multi-valued attribute is represented by?
  1. A
    Double oval
  2. B
    Single oval
  3. C
    Dashed oval
  4. D
    No oval
Question 10Single Answer
Derived attribute in ER diagram is represented by?
  1. A
    Dashed oval
  2. B
    Solid oval
  3. C
    Double oval
  4. D
    No oval
Question 11Single Answer
Cardinality in ER model specifies?
  1. A
    Number of instances of one entity related to another
  2. B
    Only one-to-one
  3. C
    Only many-to-many
  4. D
    No number
Question 12Single Answer
In DBMS, the three-schema architecture is also known as?
  1. A
    ANSI/SPARC architecture
  2. B
    Two-tier architecture
  3. C
    Single-tier architecture
  4. D
    Four-layer architecture
Question 13Single Answer
The three levels in the three-schema architecture are?
  1. A
    External, Conceptual, Internal
  2. B
    User, Application, Physical
  3. C
    Logical, Physical, Network
  4. D
    Data, Process, Interface
Question 14Single Answer
The highest level in three-schema architecture is?
  1. A
    External level (user view)
  2. B
    Conceptual level
  3. C
    Internal level
  4. D
    Physical level
Question 15Single Answer
The conceptual level in three-schema architecture describes?
  1. A
    Overall logical structure of the entire database
  2. B
    Physical storage details
  3. C
    User-specific views
  4. D
    Hardware configuration
Question 16Single Answer
The internal level in three-schema architecture is concerned with?
  1. A
    Physical storage structure & access paths
  2. B
    User views
  3. C
    Logical schema
  4. D
    Application programs
Question 17Single Answer
Data independence means?
  1. A
    Ability to change schema at one level without affecting schema at higher level
  2. B
    Data is always dependent
  3. C
    No change is possible
  4. D
    Data is fixed forever
Question 18Single Answer
One-to-one cardinality is represented by?
  1. A
    1:1
  2. B
    1:N
  3. C
    N:M
  4. D
    0:1
Question 19Single Answer
One-to-many cardinality is represented by?
  1. A
    1:N
  2. B
    1:1
  3. C
    N:M
  4. D
    0:N
Question 20Single Answer
Many-to-many cardinality is represented by?
  1. A
    N:M
  2. B
    1:N
  3. C
    1:1
  4. D
    0:M
Question 21Single Answer
Minimum cardinality 0 means?
  1. A
    Participation is optional
  2. B
    Participation is mandatory
  3. C
    No participation
  4. D
    Maximum participation
Question 22Single Answer
Minimum cardinality 1 means?
  1. A
    Participation is mandatory
  2. B
    Participation is optional
  3. C
    No participation
  4. D
    Maximum participation
Question 23Single Answer
Total participation is represented by?
  1. A
    Double line between entity & relationship
  2. B
    Single line
  3. C
    Dashed line
  4. D
    No line
Question 24Single Answer
Partial participation is represented by?
  1. A
    Single line between entity & relationship
  2. B
    Double line
  3. C
    Dashed line
  4. D
    No line
Question 25Single Answer
Mapping an ER diagram to relational model involves?
  1. A
    Creating tables for entities & relationships
  2. B
    No mapping
  3. C
    Only entities
  4. D
    Only relationships
Question 26Single Answer
For strong entity, mapping rule is?
  1. A
    Create table with all attributes, primary key underlined
  2. B
    No table
  3. C
    Weak table
  4. D
    Relationship table
Question 27Single Answer
For weak entity, mapping rule is?
  1. A
    Table with partial key + owner entity primary key as composite primary key
  2. B
    Only partial key
  3. C
    No primary key
  4. D
    Separate key
Question 28Single Answer
For 1:1 relationship, mapping rule is?
  1. A
    Primary key of any one entity is placed as foreign key in the other table
  2. B
    New table created
  3. C
    No foreign key
  4. D
    Both keys
Question 29Single Answer
For 1:N relationship, mapping rule is?
  1. A
    Primary key of 1-side entity is placed as foreign key in N-side table
  2. B
    New table created
  3. C
    No foreign key
  4. D
    Both keys
Question 30Single Answer
For N:M relationship, mapping rule is?
  1. A
    Create separate relationship table with primary keys of both entities as composite primary key
  2. B
    Place foreign key in one table
  3. C
    No table
  4. D
    Merge both entities
Question 31Single Answer
In ER model, identifying relationship is represented by?
  1. A
    Double diamond
  2. B
    Single diamond
  3. C
    Dashed diamond
  4. D
    No diamond
Question 32Single Answer
Weak entity depends on?
  1. A
    Strong (owner/identifying) entity
  2. B
    No entity
  3. C
    Multiple entities
  4. D
    Itself
Question 33Single Answer
The three-schema architecture provides?
  1. A
    Data independence
  2. B
    No independence
  3. C
    Only physical independence
  4. D
    Only logical independence
Question 34Single Answer
Data abstraction hides?
  1. A
    Complexity from users
  2. B
    Data from users
  3. C
    No hiding
  4. D
    Only physical data
Question 35Single Answer
External schema is also called?
  1. A
    User view / subschema
  2. B
    Conceptual schema
  3. C
    Internal schema
  4. D
    Physical schema
Question 36Single Answer
Conceptual schema is also called?
  1. A
    Logical schema
  2. B
    Physical schema
  3. C
    External schema
  4. D
    User schema
Question 37Single Answer
Internal schema is also called?
  1. A
    Physical schema
  2. B
    Logical schema
  3. C
    External schema
  4. D
    Conceptual schema
Question 38Single Answer
Change in storage structure without affecting conceptual schema is?
  1. A
    Physical data independence
  2. B
    Logical data independence
  3. C
    No independence
  4. D
    External independence
Question 39Single Answer
Change in conceptual schema without affecting external schema is?
  1. A
    Logical data independence
  2. B
    Physical data independence
  3. C
    No independence
  4. D
    Internal independence
Question 40Single Answer
In ER diagram, total participation is shown by?
  1. A
    Double line
  2. B
    Single line
  3. C
    Dotted line
  4. D
    No line

Reasoning

Question 41Single 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 42Single 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 43Single 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 44Single 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 45Single 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 46Single 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 47Single 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 48Single 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 49Single 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 50Single 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
Important Questions Package

MP Apex Bank Officer Computer Programmer Exam Online Question Bank Package

Buy MP Apex Bank Officer Computer Programmer Important Questions, MCQ, question answer in Hindi & English. It will help you to score high marks in MP Apex Bank Officer Computer Programmer question bank 2026 in Online, PDF & Print study material.

+ Free Monthly Current Affairs, GK & more PDF Download
Sr.Package NameAmount
1.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - Hindi
Description : 1000 Question with Answer
โ‚น101 [โ‚น500]
2.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - Hindi
Description : 2000 Question with Answer
โ‚น151 [โ‚น500]
3.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - Hindi
Description : 3000 Question with Answer
โ‚น181 [โ‚น500]
4.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - Hindi
Description : 4000 Question with Answer
โ‚น201 [โ‚น500]
5.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Description : 1000 Question with Answer
โ‚น101 [โ‚น500]
6.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Description : 2000 Question with Answer
โ‚น151 [โ‚น500]
7.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Description : 3000 Question with Answer
โ‚น181 [โ‚น500]
8.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Description : 4000 Question with Answer
โ‚น201 [โ‚น500]
9.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - Hindi
Description : 1000 Question & Answer Download in PDF (Send by Email)
โ‚น151 [โ‚น450]
10.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) - English
Description : 1000 Question & Answer Download in PDF (Send by Email)
โ‚น151 [โ‚น450]
11.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) Question Bank Book - Hindi
Description : 1000 Question with Answer (Printed Material)
โ‚น450 [โ‚น800]
12.MP Apex Bank Officer Computer Programmer Exam (Senior Management Grade 2) Question Bank Book - English
Description : 1000 Question with Answer (Printed Material)
โ‚น390 [โ‚น600]
Back to Exam
Question for MP Apex Bank Officer (Computer Programmer) 2026 - Quiz / Questions / MCQ - Toppersexam