What is the difference between Select and Project command?

1.	What is the difference between Select and Project command?
Answer» Select: THE SELECT operation is used for selecting a subset with tuples according to a given condition. Select filters out all tuples that do not satisfy C. Project: The projection eliminates all attributes of the input relation but those mentioned in the projection list. The projection method defines a relation that contains a vertical subset of Relation.

Answer»

Select:

THE SELECT operation is used for selecting a subset with tuples according to a given condition. Select filters out all tuples that do not satisfy C.

Project:

The projection eliminates all attributes of the input relation but those mentioned in the projection list. The projection method defines a relation that contains a vertical subset of Relation.

Discussion

No Comment Found

Related InterviewSolutions

………. is a repository collection of related data(a) data(b) Information(c) database(d) tuple
………. gives meaningful information(a) data(b) Information(c) row(d) tuple
Which model establishes many to many relationships?(a) Network(b) Relational(c) Hierarchical(d) Object
Entire collection of related data in one table, is referred to as ……… or ……
…… are raw facts stored in a computer(a) data(b) Information (c) row (d) tuple
Pick the odd out.Oracle, Foxpro, MariaDB, SQLite
……… uniquely identifies a particular tuple in a table
Fill in the blanks.1. Each table ………. represents a Field2. Each ……… in table represents a record.
Find the true statement(a) Data redundancy is exhibited by DBMS(b) Data redundancy is not present in DBMS
The relational model was developed in the year ……….(a) 1980(b) 1970(c) 1965(d) 1985

What is the difference between Select and Project command?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment