Which SQL function is used to count the number of rows in a SQL query?

Related MCQs

• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• 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?
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
• Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• 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.
• A           is a query that retrieves rows from more than one table or view: