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’’
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’’
C is the third
A and D are the two other valid identifiers.
ACD
ACD
I tried creating mysq1 database. The Answer A seems incorrect. Do you have some explanation why A is correct answer?
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
);
A C D
A C D