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. Snapshot of the data in the database at a given instant of time is called _____.
(1) Database Schema
(2) Database Instance
(3) Database Snapshot
(4) All of the above
(5) None of these
Q.2. Which of the following is not Unary operation?
(1) Select
(2) Project
(3) Rename
(4) Union
(5) None of these
Q.3. Which of the following is not binary operation?
(1) Union
(2) Project
(3) Set Difference
(4) Cartesian Product
(5) None of these
Q.4. The raw facts and figures are:
(1) Program
(2) Information
(3) Snapshot
(4) Reports
(5) None of these
Q.5. A command to remove a relation from an SQL database is ____.
(1) Delete table
(2) Drop table
(3) Erase table
(4) Alter table
(5) None of these
Q.6. Entities having primary key are called?
(1) Primary Entities
(2) Strong Entities
(3) Weak Entities
(4) Primary Key
(5) None of these
Q.7. In the E-R diagrams, the term cardinality is a synonym for the term?
(1) Attribute
(2) Degree
(3) Entities
(4) Cartesian
(5) None of these
Q.8. TRUNCATE statement in SQL is a ____.
(1) DML statement
(2) DDL statement
(3) DCL statement
(4) TCL statement
(5) None of above
Q.9. The default date format in SQL is?
(1) DD-MON-YY
(2) DD-MM-YY
(3) DD-MM-YYY
(4) DD-MM-YYYY
(5) None of these
Q.10. For adding number of hours to a date, which of the following statement is used ?
(1) Date + Number
(2) Date + Number/24
(3) Date+Number of Hours
(4) Date +Hour/30
(5) None of above
ANSWERS
Q.1. (2) Snapshot of the data in the database at a given instant of time is called Database Instance.
Q.2. (4) Union is not Unary operation.
Q.3. (5) Project is not binary operation.
Q.4. (5) None of these
Q.5. (2) Drop table
Q.6. (2) Strong Entities
Q.7. (4) Cartesian
Q.8. (2) TRUNCATE statement in SQL removes all records from table, including all spaces allocated for the records are removed.
Q.9. (4) The default date format in SQL is DD-MM-YYYY.
Q.10. (2) Date + Number/24
