Rdbms(Engineering > Computer Science And Engineering > Dbms Questions And Answers ) Questions and Answers
Question 1. Which one of the following is a procedural language ?
Domain relational calculus
Tuple relational calculus
Relational algebra
Query language
Explanation:-
Answer: Option C. -> Relational algebra
Relational algebraDomain and Tuple relational calculus are non-procedural language.Query language is a method through which the database entries can be accessed.
Question 2. The _______operation performs a set union of two "similarly structured tables
Union
Join
Product
Intersect
Explanation:-
Answer: Option A. -> Union
UnionUnion just combines all the values of relations of same attributes.
Question 3. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Join
Projection
Select
Union
Explanation:-
Answer: Option C. -> Select
SelectSelect is used to view the tuples of the relation with or without some constraints.
Question 4. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Join
Cartesian product
Intersection
Set difference
Explanation:-
Answer: Option B. -> Cartesian product
Cartesian productCartesian product is the multiplication of all the values in the attributes.
Question 5. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Select
Join
Union
Intersection
Explanation:-
Answer: Option B. -> Join
JoinJoin finds the common tuple in the relations and combines it.
Question 6. A ________ in a table represents a relationship among a set of values.
Column
Key
Row
Entry
Explanation:-
Answer: Option C. -> Row
Column has only one set of values.Keys are constraints and row is one whole set of attributes.Entry is just a piece of data.
Question 7. A relational database consists of a collection of
Tables
Fields
Records
Keys
Explanation:-
Answer: Option A. -> Tables
Fields are the column of the relation or tables.Records are each row in relation.Keys are the constraints in a relation .
Question 8. The term _______ is used to refer to a row.
Attribute
Tuple
Field
Instance
Explanation:-
Answer: Option B. -> Tuple
TupleTuple is one entry of the relation with several attributes which are fields.
Question 9. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Domain
Relation
Set
Schema
Explanation:-
Answer: Option A. -> Domain
The values of the attribute should be present in the domain.Domain is a set of values permitted .
Question 10. The term attribute refers to a ___________ of a table.
Record
Column
Tuple
Key
Explanation:-
Answer: Option B. -> Column
Attribute is a specific domain in the relation which has entries of all tuples.