Home / Programming MCQs / MySQL MCQs / Question
J
Q. If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?
To only remove the data of the table without disturbing the definition of the table we use the TRUNCATE statement, this statement helps us to delete all the data of a table.
You must be Logged in to update hint/solution
Which of the following is not considered to be type of database client?
Which statement is used to show the server’s current character set and collation settings?
What is the clause that filters JOIN results called?
Which server mode value enables use of double quotes to wrap identifier names?
"CREATE TABLE..." Command is used to create which type of table in Mysql ?
Oracle predefined errors are not associated with specific error codes.
The keyword used with UNION that does not retain duplicate rows is ________
Discusssion
Login to discuss.