The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
Answer: Option C
Solution (By Examveda Team)
Option A: REMOVE FROM CUSTOMER ... - There is no SQL command called REMOVE. This option is incorrect.Option B: DROP FROM CUSTOMER ... - The DROP command is used to remove entire tables or other database objects, not rows from a table. This option is incorrect.
Option C: DELETE FROM CUSTOMER WHERE ... - The DELETE command in SQL is used to remove rows from a table. You specify the table name (CUSTOMER) and use WHERE clause to specify which rows to delete based on a condition.
Option D: UPDATE FROM CUSTOMER ... - The UPDATE command is used to modify existing rows in a table, not to remove rows. This option is incorrect.
Conclusion:
To remove rows from a table 'CUSTOMER' in SQL, you use the DELETE statement with a WHERE clause to specify the condition for deletion. Therefore, the correct answer is Option C: DELETE FROM CUSTOMER WHERE ....
You can add a row using SQL in a database with which of the following?
A. ADD
B. CREATE
C. INSERT
D. MAKE
The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
A. limits the column data that are returned.
B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.
Which of the following is the original purpose of SQL?
A. To specify the syntax and semantics of SQL data definition language
B. To specify the syntax and semantics of SQL manipulation language
C. To define the data structures
D. All of the above

Join The Discussion