The command to eliminate a table from a database is:
A. DROP TABLE CUSTOMER;
B. DELETE TABLE CUSTOMER;
C. REMOVE TABLE CUSTOMER;
D. UPDATE TABLE CUSTOMER;
Answer: Option A
Solution(By Examveda Team)
To eliminate or delete a table from a database in SQL, you use the command DROP TABLE followed by the table name, as shown in Option A. The DROP TABLE command is used to permanently remove a table and all of its associated data and structure from the database. Options B, C, and D do not represent the correct SQL syntax for removing a table.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
A command that's lets you change one or more fields in a records is