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. A data dictionary is a special file that contains?
(1) the data types of all fields in all files
(2) the names of all fields in all files
(3) the widths of all fields in all files
(4) All of above
(5) None of above
Q.2. A command that lets you change one or more fields of a record is?
(1) Insert
(2) Modify
(3) Look-up
(4) All of above
(5) None of above
Q.3. In a large DBMS?
(1) Each user can see only a small part of the entire database
(2) Each user can access every sub schema
(3) Each sub schema contains every field in the logical schema
(4) All of above
(5) None of above
Q.4. It is better to use files than a DBMS when there are _______ .
(1) Stringent real-time requirements
(2) Multiple users who wish to access the data
(3) Complex relationships among data
(4) All of the above
(5) None of these
Q.5. The conceptual model is _______ .
(1) dependent on hardware
(2) dependent on software
(3) dependent on both hardware and software
(4) independent of both hardware and software
(5) None of these
Q.6. What is a relationship called when it is maintained between two entities?
(1) Unary
(2) Binary
(3) Ternary
(4) Quaternary
(5) 1 and 2
Q.7. Which of the following operation is used if we are interested in only certain columns of a table?
(1) PROJECTION
(2) SELECTION
(3) UNION
(4) JOIN
(5) Intersect
Q.8. Which of the following is a valid SQL type?
(1) CHARACTER
(2) NUMERIC
(3) FLOAT
(4) DATE
(5) All of the above
Q.9. The RDBMS terminology for a row is _______?
(1) Tuple
(2) Relation
(3) Attribute
(4) Degree
(5) Field
Q.10. Which of the following operations need the participating relations to be union compatible?
(1) UNION
(2) INTERSECTION0
(3) DIFFERENCE
(4) All of the above
(5) None of these
ANSWERS
Q.1. (4) the data types of all fields in all files, the names of all fields in all files and the widths of all fields in all files
Q.2. (2) Modify
Q.3. (1) Each user can see only a small part of the entire database.
Q.4. (2) Multiple users who wish to access the data
Q.5. (4) Independent of both hardware and sofware.
Q.6. (2) Binary
Q.7. (1) Projection operation is used if we are interested in only certain columns of a table.
Q.8. (5) All are valid SQL data type.
Q.9. (1) The RDBMS terminology for a row is Tuple.
Q.10. (4) Union, Intersection and difference