Computer Questions on Basics of DBMS for IBPS RRB Mains 2017

Computer efficiency is now important in almost every stream and computer awareness is an important section in bank recruitment Examination. Practice with these 15 questions of Computer Knowledge for IBPS RRB Mains Exam 2017.

Q1. A relational database consists of a collection of:
(a) Tables
(b) Fields
(c) Records
(d) Keys
(e) None of the above

Q2. The term attribute refers to a ___________ of a table.
(a) Record
(b) Column
(c) Tuple
(d) Key
(e) Relation

Q3. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
(a) Domain
(b) Relation
(c) Set
(d) Schema
(e) Algebra

Q4. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
(a) Instance, Schema
(b) Relation, Schema
(c) Relation, Domain
(d) Schema, Instance
(e) Key, Domain

Q5. In the architecture of a database system external level is the:
(a) physical level
(b) logical level
(c) conceptual level
(d) view level
(e) data level

Q6.The language used in application programs to request or select data from the DBMS is referred to as the:
(a) DML
(b) DDL
(c) VDL
(d) SDL
(e) TCL

Q7.The full form of DDL is:
(a) Dynamic Data Language
(b) Detailed Data Language
(c) Data Definition Language
(d) Data Derivation Language
(e) Demo Derivation Language

Q8. In relational database, a field is a:
(a) label
(b) table of information
(c) group of related tables
(d) category of information
(e) None of these

Q9. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
(a) Candidate key
(b) Sub key
(c) Super key
(d) Foreign key
(e) None of these

Q10. A __________ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
(a) Rows
(b) Key
(c) Attribute
(d) Fields
(e) Relation

Q11. A __________ is an abstract model that describes, how the data are organized and represented.
(a) data model
(b) instances
(c) schema
(d) database
(e) DBMS

Q12.Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
(a) IDMS
(b) DB2
(c) dBase-II
(d) R:base
(e) SQL

Q13. Before use of DBMS information was stored using :
(a) Cloud Storage
(b) Data System
(c) File Management System
(d) Cloud Computing
(e) None of these

Q14. ____________ is an interface between low level database and application program.
(a) Database Associate
(b) Database Server
(c) Database or Store Manager
(d) Database Constrains
(e) None of the above

Q15. Which one of the following design is both software and hardware independent?
(a) Logical
(b) Physical
(c) Conceptual
(d) Rational
(e) None of the above