Computer is the easiest and scoring section in every bank's examination which is entirely based on the basic knowledge of computer. Computer Quiz basically judges your basic knowledge and helps to analyze your performance so that you can improve your preparation level for an upcoming exam. Mahendra Guru provides you a Computer Knowledge Quiz for Bank examination based on the latest pattern so that you can practice on regular basis. It will definitely help you to score good marks in the exam. It is the most important section for all the govt exam like IBPS PO/ Clerk/SO/RRB, RBI, SBI Clerk/PO, Insurance,SSC-MTS, CGL, CHSL, State Level and other Competitive exams.
Mahendra Guru provides you a Bank Quiz of Computer Knowledge on daily basis to help you in your preparation for Govt job. You can clear your doubts before exam. Mahendra Guru also provides you important notes and study material for all subjects and test through its website, Mahendra Guru App and YouTube channel apart from it Speed Test Portal. Most of these preparation products are also available for purchase on my shop. You can also visit Mahendras.org to get more information about our endeavours for your success. You can also study in detail through our E-Mahendras Facebook and Mahendra Guru YouTube channel of Computer Knowledge.
Q.1. The full form of DDL is _______?
(1) Dynamic Data Language
(2) Detailed Data Language
(3) Data Definition Language
(4) Data Derivation Language
(5) Data Dimensional Language
Q.2. Which of the following is an advantage of a View?
(1) Data security
(2) Derived columns
(3) Hiding of complex queries
(4) All of the above
(5) None of these
Q.3. Which database level is closest to the users?
(1) External
(2) Internal
(3) Physical
(4) Conceptual
(5) None of these
Q.4. Which are the two ways in which entities can participate in a relationship?
(1) Passive and active
(2) Total and partial
(3) Simple and Complex
(4) All of the above
(5) None of these
Q.5. The result of the UNION operation between R1 and R2 is a relation that includes _______.
(1) All the tuples of R1
(2) All the tuples of R2
(3) All the tuples of R1 and R2
(4) All the tuples of R1 and R2 which have common columns
(5) None of these
Q.6. Which of the following option appropriate is a comparison operator in SQL?
(1) =
(2) LIKE
(3) BETWEEN
(4) All of the above
(5) None of these
Q.7. ________ is a process when relation between two entity is treated as a single entity.
(1) Normalization
(2) Aggregation
(3) Generalization
(4) Specialization
(5) Simplification
Q.8. In an ER Diagram, ellipse with underlying lines is used to represent _________?
(1) attribute
(2) Key attribute
(3) Composite attribute
(4) Multivalued attribute
(5) Entity
Q.9. _________ constraint is used to restrict actions that would destroy links between tables?
(1) Primary key
(2) Foreign Key
(3) Check
(4) Not Null
(5) Unique
Q.10. In a table of data base, degree refers-
(1) total numer of row
(2) row in a table
(3) column in a table
(4) total number of column in a table
(5) none of these
ANSWERS
Q.1. (3) DDL stands for Data Definition Language.
Q.2. (4) All are advantages of view.
Q.3. (1) External database level is closest to the users.
Q.4. (2) Total and partial.
Q.5. (4) All the tuples of R1 and R2 which have common columns.
Q.6. (4) =, Like and Between are comparison operators in SQL.
Q.7. (2) Aggregation is a process when relation between two entities is treated as a single entity.
Q.8. (2) In an ER Diagram, ellipse with underlying lines is used to represent Key attribute.
Q.9. (2) Foreign Key constraint is used to restrict actions that would destroy links between tables.
Q.10. (4) Total mumber of column in a table.
