SQL QUERIES REVISION 2

Which of the following requirement can be implemented using a CHECK constraint?

• (a) Student must be greater than 18 years old.

• (b) Student must be form a BRICS Country (Brazil, Russia, India, China, South Africa)

• (c) Student’s roll number must exist in another table(say, namely Eligible)

• (d) None of these 1

What is the maximum value that can be stored in NUMBERIC(4,2)

• (a) 9999.99

• (b) 99.9999

• (c) 99.99

• (d) 9.99

. What should be the data type for the column Pricestoring values less than Rs.1000 e.g. 200.21

• (a) VARCHAR(50)

• (b) NUMBER

• (c) NUMBER(5,2)

• (d) NUMBER(6)

All aggregate functions ignore NULLs except for the __________ function.

• (a) Distinct

• (b) Count(*)

• (c) Average()

• (d) None of these

To remove a character from the right side of a string, _____ function is used

The functions that work with one row at a time are _____ _____ functions

The ______ _______ clause is used to divide result of SELECT query in groups.

Issue ______ command to make changes to table permanent.

A database can be opened with _________ command.

To get a substring of a string other than Substr() function ______ is also used