Which of the following SQL clauses is used to DELETE tuples from a database table?

Related MCQs

• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• In a                            operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
• Which of the following commands do we use to delete all the tuples from a relation (R)?
• Which of the following SQL command can be used to modify existing data in a database table?