MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following statement(s) is/are true for UPDATE in SQL?1. You can update only a single table using UPDATE command2. You can update multiple tables using UPDATE command3. In UPDATE command, you must list what columns to update with their new values (separated by commas).4. To update multiple targeted records, you need to specify UPDATE command using the WHERE clause.
A
1, 3 and 4
B
2, 3 and 4
C
3 and 4
D
1 only
Explanation: 

Detailed explanation-1: -Q16) Which of the following statement(s) is/are true for UPDATE in SQL? In UPDATE command, you must list what columns to update with their new values (separated by commas). To update multiple targeted records, you need to specify UPDATE command using the WHERE clause.

Detailed explanation-2: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.

Detailed explanation-3: -What is true about the UPDATE command? Answer: C. An UPDATE can update multiple rows in one or more rows at a time based on the WHERE clause conditions.

Detailed explanation-4: -The UPDATE statement in SQL is used to update the data of an existing table in database.

There is 1 question to complete.
Previous
Next