Relational Database Management System

What SQL clause is used to restrict the rows returned by a query ?

• WHEN

• HAVING

• FROM

• WHERE

To remove duplicate rows from the result set of a select use the following keyword(s).

• NO DUPLICATES

• DISTINCT

• UNIQUE

• None of the above

MySQL runs on which operating systems ?

• Linux and Mac OS-X only

• Any operating system at all

• Unix , Linux , Windows and others

• Unix and Linux only

Which of the following can add a row to a table ?

• Add

• Insert

• Update

• Alter

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

• INSERT INTO

• UPDATE

• ADD

• INSERT NEW

In a LIKE clause , you can could ask for any value ending in "qpt" by writing.

• LIKE"%qpt"

• LIKE"*ton"

• LIKE"ton$"

• LIKE^"ton$"

A NULL value is treated as a blank or 0.

• True

• False

• None of the above

MySQL is

• A Programming language

• A Markup language

• A technique for writing reliable programs

• A Relational Database Management System

In a LIKE clause , you can ask for any 6 letter value by writing

• LIKE ??????

• LIKE .{6}

• LIKE ...... (that's six dots)

• LIKE ______ (that's six underscore characters)

The result of a SELECT statement can contain duplicate rows .

• False

• True

• None of the above