SQL single table query

Which of the following are some common RDBMS in use?

• Oracle

• MySQL

• HeidiSQL

• All of the above

What is the full form of SQL?

• Structured Query List

• Structure Query Language

• Sample Query Language

• None of these.

Which of the following is not a valid SQL type?

• FLOAT

• NUMERIC

• DECIMAL

• CHARACTER

How many Primary keys can have in a table?

• Only 1

• Only 2

• Depends on no of Columns

• Depends on DBA

Which operator is used to compare a value to a specified list of values?

• ANY

• BETWEEN

• ALL

• IN

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

Which of the following is true about the SQL AS clause?

• The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.

• The SQL AS clause can only be used with the JOIN clause.

• The AS clause in SQL is used to defines a search condition.

• All of the mentioned

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

Which statement is used to get all data from the student table whose name starts with p?

• SELECT * FROM student WHERE name LIKE '%p%';

• SELECT * FROM student WHERE name LIKE 'p%';

• SELECT * FROM student WHERE name LIKE '_p%';

• SELECT * FROM student WHERE name LIKE '%p';

Which of the following matches the definition given below: It is an artificial key that aims to uniquely identify each record.

• Primary Key

• Foreign Key

• Synthetic/Surrogate Key

• Composite Key