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

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

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

A.
myssq1. user

B.
‘mysq1. user’

C.
‘mysq1’. ‘user’

D.
Mysq1. ‘user’

E.
‘’mysq1. User’’



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Fred

Fred

C is the third

Vince

Vince

A and D are the two other valid identifiers.

Ram

Ram

ACD

Ray

Ray

I tried creating mysq1 database. The Answer A seems incorrect. Do you have some explanation why A is correct answer?

Jay

Jay

I think this is suppose to trick you up. It’s asking for a valid USER table in the database. I was able to create all of them except for E (I used “mysq1.user” I think `’ might be an error or I am just to new to MySQL).
So if 4 are correct then what does that mean! Well ‘mysq1. user’ table name that was created was mysq1.user and not USER.

Test for yourself:

create database mysq1;

use mysq1;

drop table user; #so you can test the other tables

drop table `mysq1.user`; #so you can see how it drops the not USER table

create table mysq1.user
(
something int
);

create table `mysq1.user`
(
something int
);

create table `mysq1`.`user`
(
something int
);

create table mysq1.`user`
(
something int
);

create table “mysq1.user”
(
something int
);