Consider the following query: DELETE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'world' AND table_name = 'Country' What would be the result of executing this query?

The correct answer is A. An error would be issued. INFORMATION_SCHEMA is read-only. Its tables cannot be modified with statements such as INSERT, DELETE, or UPDATE. If you try, an error occurs.

MySQL Information Schema

Question

Consider the following query:

DELETE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'world' AND table_name = 'Country' What would be the result of executing this query?

Options

AAn error would be issued
BA warning would be issued
CThe row would be deleted from the INFORMATION_SCHEMA.TABLES table, and the table
DThe row would be deleted from the INFORMATION_SCHEMA, but the table Country in the world

How the community answered

(60 responses)

A
73% (44)
B
17% (10)
C
7% (4)
D
3% (2)

Explanation

INFORMATION_SCHEMA is read-only. Its tables cannot be modified with statements such as INSERT, DELETE, or UPDATE. If you try, an error occurs.

Topics

#INFORMATION_SCHEMA#read-only views#DELETE restriction#metadata immutability

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice