MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Mysql Database
Mysql Interview
Quiz 1
Solution
Q.1.
MySQL client runs on the machine containing the databases and servers connect to the client over a network.
a) True
b) False
Q.2.
The number of attributes in the following SQL table is ______________ CREATE TABLE employee ( emp_name CHAR(30), emp_id INT );
a) 30
b) 1
c) 2
d) 3
Q.3.
Which of the following options tells mysql to ask for entering the password?
a) -e
b) -p
c) -u
d) -h
Q.4.
What is the host name in the following MySQL command? mysql -h cobra.snake.net -p -u sampadam
a) cobra.snake
b) cobra.snake.net
c) sampadam
d) cobra
Q.5.
What is ‘tamp’ in the following MySQL command? mysql -h xyz.host.try.net -p -u tamp
a) user name
b) password
c) host name
d) table name
Q.6.
The query ‘SELECT NOW()’ shows the current _____________
a) table
b) time only
c) date only
d) date and time
Q.7.
Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?
a) SELECT DATABASE()
b) SELECT DATABASE sampledb
c) USE DATABASE sampledb
d) USE sampledb
Q.8.
What does ‘abc’ & ‘xyz’ specify in the following SQL statement? CREATE TABLE abc (xyz);
a) table name and column specs
b) column specs and table name
c) table name and number of columns
d) table name and number of rows
Q.9.
To see the table structure, which of the following SQL commands is issued?
a) DESCRIBE tbl_name
b) VIEW tbl_name
c) SELECT TABLE tbl_name
d) SELECT tbl_name
Q.10.
SHOW DATABASES lists the databases in the server to which you are connected.
a) True
b) False
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page