Database - SQL 2

Which data manipulation command is used to combines the records from one or more tables?

• SELECT

• PROJECT

• JOIN

• PRODUCT

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

• ANY

• BETWEEN

• ALL

• IN

What operator tests column for absence of data

• NOT Operator

• Exists Operator

• IS NULL Operator

• None of the above

In which of the following cases a DML statement is not executed?

• When existing rows are modified.

• When a table is deleted.

• When some rows are deleted.

• All of the above

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 statement is true?

• TRUNCATE free the table space while DELETE does not.

• Both TRUNCATE and DELETE statements free the table's space.

• Both TRUNCATE and DELETE statement does not free the table's space.

• DELETE free the table space while TRUNCATE does not.

What is returned by INSTR ('JAVAT POINT', 'P')?

• 6

• 7

• POINT

• JAVAT

A command that lets you change one or more field in a table is:

• INSERT

• MODIFY

• LOOK-UP

• All of them

Which of the following is also called an INNER JOIN?

• SELF JOIN

• EQUI JOIN

• NON-EQUI JOIN

• None of them

Which of the following is true about the HAVING clause?

• Similar to the WHERE clause but is used for columns rather than groups.

• Similar to WHERE clause but is used for rows rather than columns.

• Similar to WHERE clause but is used for groups rather than rows.

• Acts exactly like a WHERE clause.