×

Computer Awareness Quiz - Set 100

image 2018-01-19 10:38:25
Computer Awareness Quiz - Set 100

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

Answers:

Ans1.(a)
Relational database is a collection of Relations or Table. A table is also known as relation in RDBMS. Fields are the column of the relation or tables. Records are each row in relation. Keys are the constraints in a relation.

Ans2.(b)
Attribute may refer to columns in a table and tuple refers to rows in a table.

Ans3.(a)
The values of the attribute should be present in the domain. Domain is a set of values permitted.

Ans4.(d)
Instance is an instance of time and schema is a representation.

Ans5.(d)
An external schema specifies a view of the data in terms of the conceptual level. This is also referred to as the view level.

Ans6.(a)
A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, requesting, inserting, deleting and updating data in a database.

Ans7.(c)
DDL stands for Data Definition Language.

Ans8. (d)
A field is category of information.

Ans9. (c)
Super key is a set of one or more attributes taken collectively to uniquely identify a record.

Ans10. (b)
Key is a property of the entire relation (relation is a table).