Examveda

The statement that makes changes to the global attributes of the database is . . . . . . . .

A. CHANGE

B. ALTER

C. ALTERNATE

D. UPDATE

Answer: Option B

Solution (By Examveda Team)

This question is about how to change the overall settings of your MySQL database. Think of it like changing the rules of the game!

Out of the options given, the one that changes the database's "big picture" settings is ALTER.

Let's break down why the other options aren't the right fit:

* CHANGE: This is used to modify the structure of a table (like adding or removing columns), not the database itself.
* ALTERNATE: This isn't a valid MySQL command.
* UPDATE: This command is for modifying the data within a table, not the database's settings.

So, the correct answer is Option B: ALTER.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous