One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #1943

SQL INTERVIEW QUESTIONS & ANSWERS by "A.maheshi" a.maheshi

Message

1 SQL INTERVIEW QUESTIONS & ANSWERS

Fri Jun 6, 2014 9:35 pm (PDT) . Posted by:

"A.maheshi" a.maheshi

________________________________

SQL INTERVIEW QUESTIONS

Download Free Interview Questions eBook of 500 Questions

(If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolInterview-Subscribe@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.)
SQL Interview Questions
* Explain UNION, MINUS, UNION ALL and INTERSECT?
http://www.coolinterview.com/interview/21868/

* Difference between decode and case. in which case we are using case and in which case we are using decode? with an example.
http://www.coolinterview.com/interview/10964/

* What are the advantages and disadvantages of primary key and foreign key in SQL?
http://www.coolinterview.com/interview/7702/

* what is the difference between replace and translate functions?
http://www.coolinterview.com/interview/11339/

* How to find out the 10th highest salary in SQL query?
http://www.coolinterview.com/interview/7704/

* How to find second maximum value from a table?
http://www.coolinterview.com/interview/10624/

* How can we delete records in a table using update table?
http://www.coolinterview.com/interview/28566/

* What is the default format of date in Oracle? How can I change my default date format?
http://www.coolinterview.com/interview/16320/

* What is the use of CASCADE CONSTRAINTS?
http://www.coolinterview.com/interview/163/

* What are the wildcards used for pattern matching.
http://www.coolinterview.com/interview/182/

* How we get second highest salary in database. Please show me this coding.
http://www.coolinterview.com/interview/15924/

* Which system table contains information on constraints on all the tables created?
http://www.coolinterview.com/interview/7749/

* Which command displays the SQL command in the SQL buffer, and then executes it
http://www.coolinterview.com/interview/7748/

* What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;
http://www.coolinterview.com/interview/161/

* What is the difference between cross product & Cartesian product?
http://www.coolinterview.com/interview/16377/

* How do I list all of my tables? How do I list all the indexed created for a particular table(say EMP)? How do I SELECT FROM DIFFERENT USERS TABLE?
http://www.coolinterview.com/interview/16319/

* What is the difference between varchar & varchar2?
http://www.coolinterview.com/interview/15683/

* When we give SELECT * FROM EMP; How does oracle respond:
http://www.coolinterview.com/interview/7729/

* How to programmatically find out when the SQL Server service started?
http://www.coolinterview.com/interview/15141/