MYSQL

Which SQL statement is used to delete an existing row ?

• DROP

• REMOVE

• DELETE

• UPDATE

What does DML stand for?

• Data Migration Language

• Data Markup Language

• Data Modelling Language

• Data Manipulation Language

Which statement will return different values?

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT DIFFERENT

• SELECT ALL

What is the default sort order in ORDER BY clause?

• Ascending

• Descending

_________ statement is used to delete a table

• DELETE TABLE

• REMOVE TABLE

• DROP TABLE

• MODIFY TABLE

Which of the following is not an aggregate function?

• DATE

• AVG

• COUNT

• MAX

Which clause is used to filter out unwanted data?

• SELECT

• FROM

• WHERE

• ORDER BY

In LIKE clause, you can search for 4 letter word by saying

• LIKE ' .... ' (4 dots)

• LIKE '????' (4 question marks)

• LIKE ' {6}'

• LIKE ' _ _ _ _' (4 underscores)

Which SQL statement is used to modify data in a database table?

• MODIFY

• CHANGE

• ALTER

• UPDATE

What will be the output for SELECT LENGTH("HELLO")

• 5

• 7

• HELLO

• ERROR