GeekInterview.com
  I am new, Sign me up!
 

SQL Interview Questions


SQL Interview Questions

Questions: 140
Comments: 688
 SQL Tags
 Showing Questions 1-10 of 139 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 SQL Interview Questions
Sorting Options :  

Explain the difference between pairwise and non-pairwise comparisons in multiple column sub-queries. 
View Question | Asked by : vamsivishwa

What happens if we remove primary key from SQL table? 
Latest Answer: Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption. ...

Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same 
Latest Answer: select * from emp where substr(ename 1 1) like substr(ename -1 1) ...

if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1 
Latest Answer: select * Customer,Carwhere Customer.custID=Car.custID; ...

what is dual table which is used as a table in sql... 
Latest Answer: Every database contains only one dual table that is also called as dummy table dual is used to evaluate expressions example:select 3+4+6 from dual;  or select sysdate from dual ...

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ? 
Latest Answer: SHARE UPDATE EXCLUSIVE  This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, and CREATE INDEX CONCURRENTLYEXCLUSIVE This mode allows only concurrent ACCESS SHARE locks, i.e., ...

Why IN query not worked in inner join? 
Latest Answer: Inner Join is nothing but self join. In self join the system wil take one record from tabel (i.e. first objective) and compare with the same table but objective is different.so at a time your comparing one record of one table to another record of another ...
Read Answers (1) | Asked by : seemu123

I have a very unusual question, how can one check which is the recent row added to a table? 
Latest Answer: SCOPE_IDENTITY() would be a better option to get the most recently added row as the primary key for a table may not necessarily be an auto-incrementing variable. Therefore max(rowid) would not be the optimal solution in that case. ...
Read Answers (7) | Asked by : akbarali

Can any one guide me how can i import and export schema using SQL and OEM 
Latest Answer: In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename. When do import we can define if the original data should be kept or cleaned. Insert will keep the data, replace will clean the original ...
Read Answers (1) | Asked by : mishfaq

I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad  
Latest Answer: select top 3 names from tablenameTry this u'll definately get the answer ...

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape