Oracle Database MySQL 5.6 Developer — Question 15

Which three are valid identifiers for the user table in the mysq1 database?

Answer options

• A. myssq1. user
• B. ‘mysq1. user’
• C. ‘mysq1’. ‘user’
• D. Mysq1. ‘user’
• E. ‘’mysq1. User’’

Correct answer: A, C, D

Explanation

The options A, C, and D are valid because they correctly use the database and table naming conventions in MySQL. Option A is a straightforward reference, while option C uses separate quotes for the identifiers, and option D has a different case for the database name but is still valid. Options B and E are incorrect due to improper usage of quotes, which makes them invalid identifiers.