Name:
Set 2| Time: 20 min
MySQL
1) Which
commend/function is used to list table information in a database:
a.
Show tables; b. Mysql_list_tables
();
c.
List tables; d. Mysql_show_tables
();
2)
MySQL is
a)
A Programming language b) A
Programming language
c)
A technique for writing reliable programs
d)
A Relational Database Management System
3) Which of the following commands should be used to create a database named “student”?
a)
CREATE? I student b) CREATE
DATABASE student
c)
DATABASE /student d) DATABSE
student
4) How much storage space does DATETIME require?
a. 4 bytes b. 2 bytes
c. 8 bytes d. 1 bytes
5) Which of these field types would be best to hold a .jpg image?
a) blob b) text c)
nchar binary d) char
binary
6) Which SQL statement is used to insert new data in a database?
a) INSERT NEW b)
INSERT INTO
c) ADD NEW
d) ADD ROW
7) Which Numeric Data type has the largest range?
a. Mediumint b. Smallint c. Int d. Tinyint
8) Which of the following ways below are the correct way to get the current date?
a. SELECT CURTIME(); b.
SELECT CURDATE();
c. SLELCT CURRRENT_TIME() d.
All of the above
9) What is the default format for “Datetime” data type?
a.
YYYY-MM-DD HH:MM:SS b. MM-YYYY-DD
HH:MM:SS
c.
DD-YYYY-MM MI:HH:SS d. None of these
10) The
number of indexes allowed per table in MYSQL are:
a. 16 b. 32 c.
64 d. 84
11) Mysql supports both signed and unsigned data types.
a) True b) False
13) Create a database named FruitDB and create table tbl_fruit in that database as follows (Use appropriate data type).Also insert any 2 values.
Fruit_id,
name, color, cost - 4 marks
