×

Computer Awareness Quiz - Set 75

image 2017-11-21 10:29:34
Computer Awareness Quiz - Set 75

Q1. It is better to use files than a DBMS when there is/are -
(a) Stringent real time requirements
(b) Complex relationship among data
(c) Multiple users wish to access the data
(d) All of the above
(e) None of the above

Q2. Redundancy is dangerous as it is a potential threat to data _____________
(a) Integrity
(b) Consistency
(c) Sufficiency
(d) Both (a) and (c)
(e) None of these

Q3. A relationship database consists of a collection of -
(a) Tables
(b) Fields
(c) Records
(d) Keys
(e) None of these

Q4. A ______ in a table represents a relationship among a set of values.
(a) Column
(b) Key
(c) Row
(d) Entry
(e) None of these
            
Q5. The term ______ is used to refer to a row.   
(a) Attribute
(b) Tuple
(c) Field
(d) Instance
(e) None of these

Q6. Which language can be used by a user to request the information from a database?  
(a) Query
(b) Relational
(c) Structural
(d) Complier
(e) None of these

Q7. In E-R diagram, derived attribute(s) is/are represented by -
(a) Ellipse
(b) Dashed ellipse
(c) Rectangle
(d) Triangle
(e) None of these

Q8. In E-R diagram, generalization is represented by -
(a) Ellipse
(b) Dashed ellipse
(c) Rectangle
(d) Triangle
(e) None of these

Q9. In E-R diagram, relationship is represented by  
(a) Ellipse shaped
(b) Dashed ellipse shaped
(c) Rectangle shaped
(d) Diamond shaped
(e) None of these

Q10. Which of the following hardware component is/are the most important for the operation of database management system?
(a) High resolution video display
(b) Printer
(c) High speed, large capacity disk
(d) Plotter
(e) Mouse

Answers:

Ans1.(c)
Files are more useful when multiple users access the data.

Ans2.(b)
Data redundancy is a condition created within a data storage technology in which the same piece of data is held in two separate places. It is a potential threat to data consistency (It is the process of keeping information uniform as it moves across a network and between various applications on a computer)

Ans3.(a)
Data base is a collection of different tables.

Ans4.(c)
A row—also called a record or tuple—represents a single, implicitly structured data item in a table and represents the relation among the values of a table.

Ans5.(b)
A row is also called a tuple.

Ans6.(a)
Query language is useful for the specification of procedures for the retrieval (and sometimes also modification) of information from a database

Ans7.(b)
ER-Diagram is a visual representation of data that describe how data are related to each other and derived attributes are represented by dashed ellipse.

Ans8.(d)
Generalization is represented by a triangle. Generalization is a bottom-up approach in which two lower level entities combine to form a higher-level entity.

Ans9.(d)
Diamond shape uses to represent the relation among the entities.

Ans10.(c)
For the operation of database management system the most important needs are high speed processor and large storage.