Vidyalelo
MySQL · Q1001

MySQL

Programming · MySQL · question 1001

Q1001

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

A.
CHANGE
B.
ALTER
Answer
C.
ALTERNATE
D.
UPDATE

Answer: Option B

Solution

Answer: Option B
Solution:
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.