SQL BASICS

 

Which one will delete the table data as well as table structure?

• DROP

• TRUNCATE

• ALTER

• DELETE

Drag the options into the correct boxes to complete the query

To display the detail of employee having "e" in their name in descending order of salary

SELECT * ​ (a)   emp ​ (b)   ename ​ (c)   %e%" ​ (d)   SAL ​ (e)   ;

• FROM
• WHERE
• LIKE "
• ORDER BY
• DESC

(a)   is used to eliminate duplicate values

Match the following

• ALTER

• DCL

• ROLLBACK

• DML

• REVOKE

• TCL

• UPDATE

• DDL

Which operator is used to specify the RANGE of values

• RANGE from

• FROM .. TO

• Between .. and

• Between range

Reorder the following to get a correct query

display the username and password of all users

• password

• users

• from

• select

• username

 

A (a)   constraint enforces referential Integrity

 

A subquery in an SQL SELECT statement is enclosed in:

• Braces -- {...}

• Single Quotes ' ...'

• Parenthesis (...)

• brackets [..]

Reorder the following to get the correct order of clauses in select statement.

• HAVING

• WHERE

• FROM

• GROUP BY

• ORDER BY

Which type of join will automatically find the common column for joining tables?

• Inner Join

• Equi Join

• Outer Join

• Natural Join