Practice Mysql Multiple Choice Questions with Answers Quiz-3

Q.1.

SQL can be used to:

Q.2.

What does SQL stand for?

Q.3.

Function TRIM() can remove leading and trailing text from a string

Q.4.

The functions that work with one row at a time are called __________________ functions

Q.5.

Date() and Day() return the same thing

Q.6.

Which of the following functions returns the substring from a given string?

Q.7.

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

Q.8.

Which will input data into a table?

INSERT INTO table(name, height, weight) VALUES('strand', '6ft 2in', '165')
INPUT INTO table(name, height, weight) VALUES('strand', '6ft 2in', '165')
INSERT INTO table CATEGORIES(name, height, weight) VALUES('strand', '6ft 2in', '165')
INSERT INTO table CATEGORIES(name, height, weight) ('strand', '6ft 2in', '165')

Q.9.

Which statement can be used to select the database?

Q.10.

USE keyword is used to select a ____________________