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?

Sign in or unlock 1Z0-873 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.

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

Unlock 1Z0-873 to see the answer

You've previewed enough free 1Z0-873 questions. Unlock 1Z0-873 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock 1Z0-873 - $49.99 / 30 days Sign in

Topics

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

Full 1Z0-873 Practice