[Solved] State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.

Q.	State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
A.	i-True, ii-False
B.	i-True, ii-True
C.	i-False, ii-True
D.	i-False, ii-False
Answer» C. i-False, ii-True

1.4k

Do you find this helpful?

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are
Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
The relation EMPDT1 is deﬁned with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in
A integrity constraint requires that the values appearing in speciﬁed attributes of any tuple in the referencing relation also appear in speciﬁed attributes of at least one tuple in the referenced relation.
A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
………………….. operator is basically a join followed by a project on the attributes of first relation.
State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..