WorksheetsINTRODUCTION TO MYSQL
Total questions: 10
Worksheet time: 5mins
What is the full form of SQL
(a)
DML stands for
(a)
Write TRUE or FALSE. Oracle is a Database Management System.
(a)
Write the command to view databases in a system
(a)
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
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.
'Patient' table has 3 columns. PatientNo, PatientName, Gender. I need to insert only PatientName and Gender. Which command is true
insert into Patient like('Siti','Female')
insert into Patient(PatientName,Gender) values('Siti','Female')
insert into Patient(PatientName,Gender) = ('Siti','Female')
Identify Data Manipulation Language command
Insert
Use
Update
Select
A set of one or more fields that describe a person, place or things is term for a (a)
