[JobsAssist] Top 50 SQL Interview Questions & Answers

 

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/    What is the difference between "select * from table name" and "select column_name from table name" The above quiries are simple select quiries without having any "where" clause. Secondly which query will be performed faster and why??  http://www.coolinterview.com/interview/29181/    How to programmatically find out when the SQL Server service started?  http://www.coolinterview.com/interview/15141/    What is the parameter substitution symbol used with INSERT INTO command?  http://www.coolinterview.com/interview/184/    given a table of student(rollno,name,dno,dateofadmission,city) and department(dno,dname)...How u will found the rollno,class,deptname of students in ascending order of their departments?  http://www.coolinterview.com/interview/29182/    How to find out the database name from SQL*PLUS command prompt?  http://www.coolinterview.com/interview/7736/    What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP;  http://www.coolinterview.com/interview/170/    Which of the following is not a feature of a cursor FOR loop?  http://www.coolinterview.com/interview/21892/    What is cluster.cluster index and non cluster index  http://www.coolinterview.com/interview/7714/    In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?????  http://www.coolinterview.com/interview/7710/    Explain normalization with examples.  http://www.coolinterview.com/interview/7737/    Explain about XML related specifications?  http://www.coolinterview.com/interview/22673/    Explain the concept of joins and list out the different type of joins?  http://www.coolinterview.com/interview/15714/    Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table.  http://www.coolinterview.com/interview/7708/    What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );  http://www.coolinterview.com/interview/171/    How to retrieving the data from 11th column to n th column in a table.  http://www.coolinterview.com/interview/10963/    What is denormalization and difference between normalization and denormalization?  http://www.coolinterview.com/interview/16350/    What is a default TCP/IP socket assigned for SQL Server?  http://www.coolinterview.com/interview/15135/    Which command executes the contents of a specified file?  http://www.coolinterview.com/interview/185/    How to save the output of a query/ stored procedure to a text file using T-SQL?  http://www.coolinterview.com/interview/15143/    Difference between Stored Procedure and Trigger  http://www.coolinterview.com/interview/10628/    Which system tables contain information on privileges granted and privileges obtained?  http://www.coolinterview.com/interview/177/    How can i hide a particular table name of our schema.  http://www.coolinterview.com/interview/7712/    How to Select last N records from a Table?  http://www.coolinterview.com/interview/21893/    What is output of following query Select 2 from employee;  http://www.coolinterview.com/interview/12611/    Which date function is used to find the difference between two dates?  http://www.coolinterview.com/interview/169/    Write a SQL statement to draw the second highest salary in Employee Table (Using Sub query) Table structure is: Employe ID Name Salary  http://www.coolinterview.com/interview/15137/    What is the use of DESC in SQL?  http://www.coolinterview.com/interview/164/    Why does the following command give a compilation error? DROP TABLE &TABLE_NAME;  http://www.coolinterview.com/interview/168/    State true or false. !=, <>, ^= all denote the same operation.  http://www.coolinterview.com/interview/180/    What will be the output of the following query? SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;  http://www.coolinterview.com/interview/172/    What command is used to create a table by copying the structure of another table?  http://www.coolinterview.com/interview/173/    How to generate OIDS ?  http://www.coolinterview.com/interview/12794/

__._,_.___

---

Posted by: Megha <a.maheshi@yahoo.in>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Improvements in Yahoo Groups Search

Searching for new groups to join is easier than ever. We've honed our algorithm to bring you better search results based on relevance and activity. Try it today!

---

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FREE JOB RESOURCES
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

http://www.vyoms.com/

EMPLOYERS SEARCH FROM OVER LAKHS OF FRESH QUALITY RESUMES FOR FREE
http://www.vyoms.com/employers/

Get Thousands Of Relevant Fresher Jobs FREE OF COST
http://www.vyoms.com/jobs/job-types/details/freshers-jobs-1.asp

Get Thousands Of Relevant Experienced Jobs FREE OF COST
http://www.vyoms.com/jobs/job-types/details/experienced-jobs-2.asp

Get Thousands Of Relevant Walk-Ins FREE OF COST
http://www.vyoms.com/jobs/job-types/details/walk-ins-4.asp

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___