Software-Engineering
August 25, 2024Database-Management-System
August 26, 2024Database-Management-System
|
Question 513
|
The PROJECT Command will create new table that has
|
more fields than the original table
|
|
|
more rows than original table
|
|
|
both (A) & (B)
|
|
|
none of these
|
Question 513 Explanation:
Project command is used to select a column of a relation based on the condition given in the query.
Option(A) is incorrect because the maximum number of columns Project command can select is equal to the total number of columns in the given relation.
Option(B) is incorrect because project command is related to the columns of a relation, it is not related to the selection of rows in the table. The result of Project command contain same number of rows as that of given relation.
Option(A) is incorrect because the maximum number of columns Project command can select is equal to the total number of columns in the given relation.
Option(B) is incorrect because project command is related to the columns of a relation, it is not related to the selection of rows in the table. The result of Project command contain same number of rows as that of given relation.
Correct Answer: D
Question 513 Explanation:
Project command is used to select a column of a relation based on the condition given in the query.
Option(A) is incorrect because the maximum number of columns Project command can select is equal to the total number of columns in the given relation.
Option(B) is incorrect because project command is related to the columns of a relation, it is not related to the selection of rows in the table. The result of Project command contain same number of rows as that of given relation.
Option(A) is incorrect because the maximum number of columns Project command can select is equal to the total number of columns in the given relation.
Option(B) is incorrect because project command is related to the columns of a relation, it is not related to the selection of rows in the table. The result of Project command contain same number of rows as that of given relation.