Computer Science - Database Systems - Discussion

23. 

The PROJECT command will create new table that has

[A]. more fields than the original table
[B]. more rows than the original table
[C]. both (a) and (b)
[D]. all the fields of master table
[E]. None of the above

Answer: Option E

Explanation:

No answer description available for this question.

Sudha said: (Apr 24, 2011)  
What is the use PROJECT command?

Sakshi Kalia said: (Nov 16, 2011)  
PROJECT is not any command. Doesnt exist in DBMS till now.. ;P

Hello said: (May 30, 2012)  
Projection means combining of two tables na? and here its not specified that in DBMS.

T.A. Usha said: (Nov 21, 2012)  
Project selects the columns from the table or a relation. Columns are nothing but fields.
Table need not be a master table alone. So answer (E) is correct.

Shivakumara T said: (Jun 26, 2013)  
Project does not exists in dbms, but it exists in relational algebra as a projection, it means that it selects all fields and all rows from the table.

Sharon Manmothe said: (Jun 28, 2013)  
Project is a subset of fields displayed for specific reason.

Nitin said: (Aug 1, 2013)  
The PROJECT operation is used to select a subset of the attributes of a relation by specifying the names of the required attributes.

For example, to get a list of all employees surnames and employee numbers:

PROJECT surname, empno(employee)

Honey said: (Jul 30, 2019)  
Project eliminates columns whereas Select eliminates rows.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.