Here`s an sql aptitude questions collection ( quite easy)


Here Are More Sql aptitude questions



as we were asked by several of our readers for Sql related questions for aptitude preparations & sql questions are asked a lot in placement papers so if u have any requests email us (kusumm14@yahoo.com)



Q. What is the use of the DROP option in the ALTER TABLE comm&?


It is used to drop constraints specified on the table.



Q. What is the value of ‘comm’ & ‘sal’ after executing the following query if the initial


value of ‘sal’ is 10000?


UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;


sal = 11000, comm = 1000 .


Q. Why does the following comm& give a compilation error?


DROP TABLE &TABLE_NAME;


Variable names should start with an alphabet. Here the table name starts with an '&' symbol.



Q. What is the advantage of specifying WITH GRANT OPTION in the GRANT comm& in sql?


The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.



Q. What is the use of DESC in SQL?


Answer :


DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.


Explanation :


The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.



Q. What is the use of CASCADE CONSTRAINTS?


When this clause is used with the DROP comm&, a parent table can be dropped even when a child table exists.



 

No comments:

Take Advantage Of 25 of the finest Articles to help u prepare for the Placement Papers and Interview questions
You’d Never Guess How easy it is to get a job after reading these placement preparation articles

Here are 25 Placement Preparation Articles


"IMPORTANT NOTE"
We Update our site frequently and we want to keep you guys informed so enter your email in the top left hand box and click subscribe,so that whenever we post new papers it gets delivered right to your mail.



 

© New Placement papers | Latest Placement Papers