Backend Development with PHP and MySQL

Which of the following is not a valid SQL type?

• NUMERIC

• DECIMAL

• CHARACTER

• FLOAT

Which of the following SQL statement selects only unique values from ‘section’ column of table ‘school’?

• SELECT section FROM school;

• SELECT DISTINCT section FROM school;

• SELECT * FROM school;

• SELECT ALL section FROM school;

How many Primary keys can have in a table?

• Only 1

• Only 2

• Depends on no of Columns

• Depends on DBA

Which of the following is not a valid aggregate function?

• COUNT

• COMPUTE

• SUM

• MAX

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

• DESC

• ASC

• There is no default value

• None of the mentioned

When the wildcard in a WHERE clause is useful?

• When an exact match is required in a SELECT statement.

• When an exact match is not possible in a SELECT statement.

• When an exact match is required in a CREATE statement.

• When an exact match is not possible in a CREATE statement.

______ is NOT a type of constraint in SQL language?

• FOREIGN KEY

• PRIMARY KEY

• UNIQUE

• ALTERNATE KEY

Which of the following statement is correct to display all the cities with the condition, temperature, and humidity whose humidity is in the range of 60 to 75 from the 'whether' table?

• SELECT * FROM weather WHERE humidity IN (60 to 75)

• SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75

• SELECT * FROM weather WHERE humidity NOT IN (60 AND 75)

• SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75

A ___ is normalized after it has been organized.

• Table

• Database

• Row

• Column

What is the meaning of “EMPTY SET” in the following MySQL command?

SELECT fname, lname, person_id FROM person WHERE lname=’s’;

• No values

• Error

• Access denied

• None of the mentioned