R

Ritu Singhal • 4.36K Points
Extraordinary 

Q. Which clause is used to rename the existing table?

  • (A) RENAME
  • (B) sql_config
  • (C) ALTER
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 18
  • Filed under category MySQL
Explanation by: Ritu Singhal 
This question is about changing the name of a table in MySQL. Think of it like renaming a file on your computer.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. The non handle array representing a row of values is . . . . . . . .

Q. What does CGI stand for?

Q. The privilege that must be given to the database to create a stored function or procedure is . . . . . . . .

Q. The server is told to accept spaces after function names by

Q. What performs administrative operations?

Q. Numbers of operand used by Binary Operators are?

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject. Intern_id= {1, 2, 3, 4, 5, 6} Subject= {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject NOT IN (c, c++);

Q. What is the SQL mode to check for divide by zero error?

Q. Which datatype is used for a fixed length binary string?

Q. What can be used to check for views that have been invalidated by DROP or ALTER operations?

Learn All MySQL MCQs

Question analytics