The command to remove rows from a table 'CUSTOMER' is:
A. DROP FROM CUSTOMER ...
B. UPDATE FROM CUSTOMER ...
C. REMOVE FROM CUSTOMER ...
D. DELETE FROM CUSTOMER WHERE ...
Answer: Option D
Solution(By Examveda Team)
The command to remove rows from a table in SQL is DELETE FROM CUSTOMER WHERE .... Option D is the correct choice for deleting rows from the 'CUSTOMER' table based on specific conditions specified in the WHERE clause. Options A, B, and C do not represent the standard SQL syntax for removing rows.Join The Discussion
Comments ( 1 )
Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
CD