ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2040)
 SQL Server interview questions  SQL Server Interview Questions (1079)
 MS Access interview questions  MS Access Interview Questions (25)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (775)
 Databases AllOther interview questions  Databases AllOther Interview Questions (107)
Question
In a table i have columns A,B,C and i have a composite index 
on columns A,B if so will the following query uses index or 
not?
SELECT sal,name
FROM <table_name>
WHERE A=<value> AND B=<value> AND C=<value>;
 Question Submitted By :: SQL-PLSQL
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
index range scan
 
Is This Answer Correct ?    0 Yes 0 No
Kishore Vakiti
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy. TCS 2
Give the structure of the function ?   1
write the Sql query for creating database backup? TCS 7
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms? Polaris 2
what is the forward decleration in packages?   1
Wat is SGA ? ABB 3
Can a view be updated/inserted/deleted?If Yes under what conditions?   3
What is RAC in oracle?   7
Can you have multiple SPs with the same name on a database? CGI 2
What are the types of SQL Statement?   3
What is a database link?   2
what is overloading procedure or overloading function ? Genpact 3
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com