Question

What does a fully qualified table name consist of?

(a) only the table name

(b) only the database name

(c) table name followed by database name

(d) database name followed by table name

This question was addressed to me in a national level competition.

My question comes from MySQL Identifier Syntax and Naming Rules in division Using SQL to Manage Data of MySQL

Answer 1

Correct answer is (d) database name followed by table name

Easy explanation: MySQL identifiers use qualifiers. An element of a database has a fully qualified name. A database table in MySQL has the fully qualified name as the database name followed by the table name.