Sql Interview Questions & Answers: part5



Sql Interview QUESTIONS AND ANSWERS :: part5 : 1 to 5

Following SQL Multiple choice objective type questions and answers will help you in many software compnaies written examinations and inteview 2015 :

1.The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

In
Lateral
Having
With

2.SQL query to find all the cities whose humidity is 95 .

SELECT city WHERE humidity = 95
SELECT city FROM weather WHERE humidity = 95
SELECT humidity = 89 FROM weather
SELECT city FROM weather

3.The command to remove rows from a table ‘CUSTOMER’ is

DROP FROM CUSTOMER
UPDATE FROM CUSTOMER
REMOVE FROM CUSTOMER
DELETE FROM CUSTOMER WHERE..

4.What is the meaning of LIKE ‘%0%0%’ ?

Feature begins with two 0′s
Feature ends with two 0′s
Feature has more than two 0′s
Feature has two 0′s in it, at any position

5.Which TCL command undo all the updates performed by the SQL in the transaction ?

ROLLBACK
COMMIT
TRUNCATE
DELETE

More Sql Interview QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn