Computer Awareness Quiz – Set 2 (DBMS)

Computer Awareness Quiz: Computer Awareness is one of the sections in Exams like IBPS RRB, FCI etc. So we have started this series of Quiz on Computer Awareness. These questions are most important for banking exams. So attempt all the sets now.

1. A __________ is a collection of interrelated data stored together to serve multiple applications?
   A) DBMS
   B) Database
   C) Data sharing
   D) Controlled Data
   
   View answer

     Option B
   Explanation: Database; While DBMS is a tool to manage this data.
2. Which of the following is not a DBMS tool?
   A) MS- Access
   B) Ingres
   C) Turner Database
   D) Oracle Database
   
   View answer

     Option C
   Explanation: Rest all are database software. DBMS stands for Database Management System. It is a tool used to manage database.
3. In a database, duplication of data is referred to as __________.
   A) Data abstraction
   B) Data inconsistency
   C) Data security
   D) Data redundancy
   
   View answer

   Option D
   Explanation: Data redundancy. When a same data is present more than one time in a database it is known as Data redundancy.
4. In a DBMS, data is arranged in rows and columns. This arrangement is known as?
   A) Relation
   B) Tuple
   C) Attribute
   D) Degree
   
   View answer

   Option A
   Explanation: A table=Relation
5. Which of the following is not a level of Database Implementation?
   A) Physical Level
   B) External Level
   C) Relational Level
   D) Conceptual Level
   
   View answer

   Option C
   Explanation: There are three velels: a) Internal Level(Physical Level) b) Conceptual Level c) External Level (View Level)
6. The rows of tables in a relationship are known as?
   A) Relation
   B) Tuple
   C) Attribute
   D) Degree
   
   View answer

   Option B
   Explanation: Tuple: The rows of tables in a relationship are generally termed as Tuples.
7. The column of tables in a relationship are known as?
   A) Relation
   B) Tuple
   C) Attribute
   D) Degree
   
   View answer

   Option C
   Explanation: Attributes: The columns or fields of a table is termed as Attributes.
8. The number of attributes in a relation is known as?
   A) Cardinality
   B) Tuple
   C) Attribute
   D) Degree
   
   View answer

   Option D
   Explanation:
9. The number of tuples or rows in a relation is known as?
   A) Cardinality
   B) Tuple
   C) Attribute
   D) Degree
   
   View answer

   Option A
   Explanation: So we have: Table= Relation; Row= Tuple; Column= Attribute; Number of row= Cardinality; No. of column= Degree
10. A virtual table in DBMS is known as?
    A) Visible
    B) View
    C) Tuple
    D) Associate
    
    View answer

    Option B
    Explanation: View

Click Here for More Computer Quiz

Click Here for Computer Study Material