WorksheetsIntroduction to MySQL
Total questions: 15
Worksheet time: 10mins
What is the full form of SQL
(a)
Identify the data type of data 78.3
int
float
char
varchar
To store a name the data type is given as char(10). The name entered is Diya. How many spaces will be used to store the name
4
8
10
Which format is correct for giving a date in MySQL
DD-MM-YYYY
DD-MM
YYYY-DD-MM
YYYY-MM-DD
Which is not a DDL command
Create
Alter
Delete
Drop
Which command is used to remove entire data from a table
delete
drop
DML stands for
(a)
write the command to open the database 'factory'
(a)
Write the command to view databases in a system
(a)
A table has 3 columns. patientno, name, department. I need to insert only patientno and name. Which command is true
insert into patient values(101,'Namitha')
insert into patient(patientno,name) values(101,'Namitha')
insert into patient(patientno,name) = (101,'Namitha')
Which of the following can add a row to a table?
Add
Insert
Update
Alter
SQL is not case sensitive. SELECT is the same as select.
TRUE
FALSE
The SQL statement that queries or reads data from a table is __________ .
USE
SELECT
READ
QUERY
SQL can be used to:
Create database structures only.
Query database data only.
Modify database data only.
All of the above can be done by SQL.
Select the data types which must be enclosed in quotes.
int
float
varchar
date
