×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You want to create two databases, test and Test. Which of the following statements is true?
2.
Which of the following are a valid identifier for the user table in the mysql database?
3.
Is the following statement true or false? "Each database corresponds to a single directory under data directory,
regardless of what storage engine table uses in the database"
4.
Which of the following statements are true? Databases don't have a default character set or collation.
5.
Ignoring any warnings that may be issued, which of the following statements will delete the `world` database
and its entire contents on execution, but return no error if it doesn't exist?
6.
Which of the following statements will return a list of all of the databases with a name that starts with 'pro'?
7.
Which of the following statements will provide a list of all of the databases with a name that starts with 'world'?
8.
Which of the following are true in relation to character set and collation relationships in MySQL?
9.
In non-strict mode, assuming that the table city does not already exist and you execute the following sequence
of commands: CREATE TABLE city (city_name CHAR(5)) INSERT INTO city (city_name) VALUES ('NEW
YORK'), ('TOKYO'), (23+345), ('LONDON') -- Ignoring any errors or warnings that may be issued, which values
are now in the table?
10.
Consider the following:
Which of the quoted values below will be returned for the name field in the SELECT results?