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

Related MCQs

• 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?
• An attribute of one table matching the primary key of another table, is called as
• Which of the following is the formal process for deciding which attributes should be grouped together in a relation?
• Some of the columns of a relation are at different sites is which of the following?
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
• To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.
• If attribute A determines both attributes B and C, then it is also true that:
• Which of the following clause specifies the table or tables from where the data has to be retrieved?