QUIZ ON SQL

Which of the following is not a DDL command?

• UPDATE

• TRUNCATE

• ALTER

• None of the Mentioned

Which of the following are TCL commands?

• UPDATE and TRUNCATE

• SELECT and INSERT

• GRANT and REVOKE

• ROLLBACK and SAVEPOINT

________________ is not a category of SQL command.

• TCL

• SCL

• DCL

• DDL

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

• SELECT * FROM Persons WHERE FirstName=’a’

• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

• SELECT * FROM Persons WHERE FirstName=’%a%’

What does the ALTER TABLE clause do?

• The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

• The SQL ALTER TABLE clause is used to insert data into database table

• THE SQL ALTER TABLE deletes data from database table

• The SQL ALTER TABLE clause is used to delete a database table

The UNION SQL clause can be used with _____________

• SELECT clause only

• DELETE and UPDATE clauses

• UPDATE clause only

• All of the mentioned

Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

• Left outer join

• Right outer join

• Full outer join

• None of the above

Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition?

• Outer Join

• Cross Join

• Inner Join

• None of the above

Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2?

• Retrieves all the unmatched rows of Table1

• Retrieves all the unmatched rows of Table2

• Retrieves both matched and unmatched rows of Table1 and Table2

• Retrieves only matched rows of table1 and Table2

Which of the following statements are true?

• INNER JOIN only retrieves those rows from Cartesian Product that satisfy the JOIN condition

• FULL OUTER JOIN is same as CROSS JOIN

• SELF JOIN is a special type of OUTER JOIN

• Both A and C