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?

Related MCQs

• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• 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?
• Which of the following SQL clauses is used to DELETE tuples from a database table?
• 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.
• Which of the following commands do we use to delete all the tuples from a relation (R)?
• In a                            operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.