Sql Interview Questions & Answers: part11



Sql Interview QUESTIONS AND ANSWERS :: part11 : 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.What is meaning of “REFERENCES” in table definition?

Primary key
NULL
Foreign Key
A ”foreign Key” belong to this particular table

2.What default value gets stored in columns of the table?

NULL
0
1
-1

3.Find out the logical error in the following query? CREATE TABLE person ( person_id varchar(20), Name varchar (20), Address Varchar (20), Mobile_no Smallint );

Lesser number of columns
Incorrect definition
Primary key is missing
None of these

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