Introduction to MySQL

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')