Relational Data Language, SQL

What is the purpose of the INSERT operation in SQL?

• To delete a tuple from a relation

• To add a new tuple to a relation

• To update an existing tuple

• To select specific tuples

Which operation is used to remove a tuple from a relation based on a criterion?

• Insert

• Delete

• Update

• Select

What does the UPDATE operation do in SQL?

• Adds a new tuple to a relation

• Removes a tuple from a relation

• Modifies the value of some attributes in a tuple

• Combines two relations

Which operation creates a new relation by selecting tuples based on a criterion?

• Project

• Select

• Join

• Union

What is the purpose of the PROJECT operation?

• To select tuples based on a criterion

• To select a subset of attributes from a relation

• To combine two relations

• To delete tuples from a relation

Which operation combines two relations based on common attributes?

• Union

• Intersection

• Join

• Difference

What is the result of the UNION operation?

• Tuples that are in both relations

• Tuples that are in either of the two relations or both

• Tuples that are in the first relation but not the second

• Tuples that are in the second relation but not the first

Which operation creates a new relation with tuples that are present in both relations?

• Union

• Intersection

• Difference

• Join

What does the DIFFERENCE operation do?

• Combines two relations

• Finds tuples that are in both relations

• Finds tuples that are in the first relation but not the second

• Finds tuples that are in either relation

Which of the following is a binary operation?

• Insert

• Delete

• Join

• Select