Font size
S
M
L
XL
WorksheetsMySQL revision tour
Total questions: 10
Worksheet time: 16mins
Name
Class
Date
1.
Which command is used to open an existing database?
(a)
2.
Command to view structure of the table named ‘STUDENT ‘.
(a)
3.
A key which allows unique or null values.
a)
Unique
b)
Null key
c)
Primary key
d)
Alternate key
4.
To destroy the table named ‘STUDENT ‘.
(a)
5.
Delete * from empl;
a)
Deletes all tuples.
b)
updates the table emp with null.
c)
Destroys the table.
6.
DML commands are:-
a)
INSERT
b)
UPDATE
c)
DELETE
d)
GRANT
7.
TCL commands are:-
a)
DEFAULT
b)
GRANT
c)
REVOKE
d)
ROLLBACK
8.
DDL commands are:-
a)
UPDATE
b)
CREATE
c)
DROP
d)
DELETE
9.
Pattered matching in SELECT command can be done using:-
a)
@
b)
&
c)
_
d)
%
10.
Examples of DBMS software are:-
a)
MySQL
b)
ORACLE
c)
JAVA
d)
FOXPRO
Reset
