SQL - Refining the result

Which signs are used for string pattern in SQL?

• % and _

• % and #

• _ and #

• # and #

Choose output for following sql statement.

Select * from employee where fname LIKE 'a%';

• Give all the data from emplyee table

• Give all the data from employee table in which fname end with 'a'

• Give all the data from employee table in which fname start with 'a'

• None

what is the output of sql statement,

Select * form t1 where t1 Like '_t%'

• Give all the data from t1 table

• Give all the data from t1 table in which t1 column has second position data with t.

• Give all the data from t1 table in which t1 column has first position data with t.

• None

Which operator is used to select the values within the ranges?

• LIKE

• RANGES

• BETWEEN

• NONE

Select correct sql statement for given information.

"all the data from product table in which price of the product will within the 10 and 20."

• None

• SELECT * FROM ProductsWHERE Price BETWEEN 10 AND 20;

• SELECT * FROM Product where price 10 and 20;

• SELECT * FROM ProductsWHERE Price BETWEEN 10 OR 20;

Which keyword is used to sort the data in sql?

• LIKE

• Order by

• Group by

• none

By default, in which sorted form sql will will sorting the data If we used order by?

• Ascending

• Descending

• Do not allow to sort

• None

What is the correct format for sql statement?

• Select...from...where...orderby...groupby

• Select...from...where...groupby...orderby

• both

• none

Which sign is used for single line comment in sql?

• double dash

• double inverted comma

• semicolon

• None

DOUBLE is most common useful datatype for creation of database in sql.

• True

• False