NEW
Font size
S
M
L
XL
WorksheetsMysql set 1
Total questions: 21
Worksheet time: 11mins
Name
Class
Date
1.
MySQL is freely available and is open source.
a)
True
b)
False
c)
Not sure
d)
Private
2.
What represents a tuple in relational database?
a)
Table
b)
Row
c)
Column
d)
Object
3.
How is communication established with MySQL?
a)
SQL
b)
Network calls
c)
A programming language like C++
d)
APIs`
4.
The MySQL server used in its client/server architecture is _______________
a)
a) mysqla
b)
b) mysqlb
c)
c) mysqlc
d)
d) mysqld
5.
Which of the following clauses is used to display information that match a givenpattern?
a)
LIKE
b)
WHERE
c)
IS
d)
SAME
6.
What column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE ‘%name’;
a)
suffixed with ‘name’
b)
prefixed with ‘name
c)
suffixed with ‘%name’
d)
prefixed with ‘%name’
7.
The special database that always exists after setting up MySQL in a computer is__________
a)
sampdb
b)
mysql
c)
information_schema
d)
readme_db
8.
In the following SQL code, InnoDB is __________
CREATE TABLE student (
name CHAR(30),
student_id INT,
PRIMARY KEY(student_id)) ENGINE = InnoDB;
a)
database name
b)
table name
c)
reference engine
d)
storage engine
9.
Identify the table name in the following SQL statement.
INSERT INTO student VALUES(‘Kyle’,’M’,NULL);
a)
Student
b)
b) Values
c)
c) Kyle
d)
d) M
10.
What is 'xyz' in the following statement
select abc from xyz
a)
row name
b)
b) column name
c)
c) table name
d)
d) database name
11.
Which operator is used to perform integer divisions in MySQL?
a)
/
b)
b) \
c)
c) DIV
d)
d) //
12.
The NULL value also means ___________
a)
value equal to zero
b)
unknown value
c)
c) negative values
d)
d) a large value
13.
What does comparing a known value with null result into
a)
zero
b)
positive value
c)
negative value
d)
null
14.
Which clause is used to sort query elements?
a)
GROUP
b)
b) GROUP BY
c)
c) ORDER
d)
d) ORDER BY
15.
Which of the following options tells mysql to ask for entering the password?
a)
-e
b)
-p
c)
-u
d)
-h
16.
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
17.
The query ‘SELECT NOW()’ shows the current _____________
a)
table
b)
b) time only
c)
c) date only
d)
d) date and time
18.
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
19.
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
20.
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
21.
The command to move the cursor to the beginning of line in MySQL input editor is?
a)
Ctrl-A
b)
Ctrl-E
c)
Ctrl-D
d)
ESC a
Reset
