Query Quizz

My SQL is a __________ ?

• English

• A structured query language

• Swedish

• Your Choice From Perl, PHP, Java Or Some Other Languages

My SQL runs on which operating system

• Unix and Linux only

• Unix, Linux, Windows

• Linux and Mac OS only

• Any operating system at all

Which statement is used to insert a new data in a database?

• INSERT NEW

• INSERT INTO

• Add New

• UPDATE

The SQL keyword BETWEEN is used ?

• As a wildcard

• To limit columns displayed

• For ranges

• All of the above

Can I define multiple unique key in a MySQl table?

• Yes

• No

Which is the default MySQl ORDER BY clause?

• Ascending

• Descending

Is a NULL value treated as a blank or 0?

• True

• False

Which one of the following can be treated as a primary key?

• Id

• Semester

• Sec_id

• Year

SELECT *

FROM teachers

WHERE Sec_id = ‘CS-101’

• 1003

• 1001

• None

• Error Message appears

How can the values in the relation teaches be deleted?

• DROP TABLE teachers

• DELETE FROM teachers

• PURGE TABLE tables

• DELETE FROM teachers WHERE Id= “Null”