Excellent Sql Aptitude questions


Sql Apptitude Very neat collection

Q. What will be the output of the following query? SELECT  DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );
Answer :    NO.
Explanation : 
The query checks whether a given string is a numerical digit. 


 Q. What command is used to create a table by copying the structure of another table?  Q. What will be the output of the following query? 
 Q. What does the following query do?
Q. What is the difference between TRUNCATE & DELETE commands? For answers Go Here

For more Sql Questions we suggest you come back to the original site(mncplacement)& check out more sql questions asked in 2019/2020.

More C/C++ Aptitude Questions

More Excellent SQL QUESTIONS collection



Remember a lotta these questions with detailed explanation can be found At this Website

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