Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part4 : 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 UNION SQL clause can be used with

SELECT clause only

DELETE and UPDATE clauses

UPDATE clause only

All oF the mentioned

2.What does DML stand for ?

Different Mode Level

Data Model Language

Data Mode Lane

Data Manipulation language

3.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

4.What is the purpose of the SQL AS clause ?

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

The AS clause is used with the JOIN clause only.

The AS clause defines a search condition.

All of the mentioned

5.With SQL, how can you return the number of not null records in the “Persons” table ?

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Too many of us are not living our dreams because we are living our fears.- Les Brown

Related Online Test