Sql Interview Questions & Answers: part8



Sql Interview QUESTIONS AND ANSWERS :: part8 : 11 to 15

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

11.Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Data Definition Language(DDL)
Data Manipulation Language(DML)
DDL and DML
None of the Mentioned

12.A command that lets you change one or more fields in a record is

Insert
Modify
Look-up
All of the Mentioned

13.Can “SELECT” clause be used without the clause “FROM”?

YES
NO
DEPENDS
May be?

14.What will be the output of a query given below? SELECT person_id, Fname, lname FROM person;

Show only columns (person_id, Fname, lname) and rows related to these columns.
Show only columns (person_id, Fname, lname)
Show all rows
Show all columns except (person_id, Fname, lname)

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