[Solved] Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?

Q.	Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
A.	SELECT
B.	PROJECT
C.	UNION
D.	JOIN
Answer» B. PROJECT

2.2k

Do you find this helpful?

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Which of the following is used to get all the columns of a table?
What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
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 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.
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identiﬁer, name, and salary attributes. This process is called
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.