[Solved] The UPDATE SQL clause can _____________

McqMate

Q.	The UPDATE SQL clause can _____________
A.	update only one row at a time
B.	update more than one row at a time
C.	delete more than one row at a time
D.	delete only one row at a time
Answer» B. update more than one row at a time

4.2k

0

Do you find this helpful?

31

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

The UNION SQL clause can be used with _____________
dump, writes out SQL DDL statements and SQL insert statements to a ﬁle, which can then be reexecuted to re- create the database.
The clause allows us to select only those rows in the result relation of the clause that satisfy a speciﬁed predicate.
SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
What is the purpose of the SQL AS clause?
‘AS’ clause is used in SQL for
Which SQL function is used to count the number of rows in a SQL query?
View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?