Q1. A relational database consists of a collection of:
(e) None of the above
Q2. The term attribute refers to a ___________ of a table.
Q3. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
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:
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:
(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.
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.
Attribute may refer to columns in a table and tuple refers to rows in a table.
The values of the attribute should be present in the domain. Domain is a set of values permitted.
Instance is an instance of time and schema is a representation.
An external schema specifies a view of the data in terms of the conceptual level. This is also referred to as the view level.
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.
DDL stands for Data Definition Language.
A field is category of information.
Super key is a set of one or more attributes taken collectively to uniquely identify a record.
Key is a property of the entire relation (relation is a table).