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 (1080)
 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
 
Can a view be updated/inserted/deleted?If Yes under what conditions?   3
how to find the second highest salary from emp table? Wipro 200
What does “select count(1) from tab” result? IBM 9
scope of exception handling in plsql Wipro 3
What are the return values of functions SQLCODE and SQLERRM ? PreVator 2
write a query to delete similar records in different tables with same structure   4
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS). IBM 2
Where the Pre_defined_exceptions are stored ?   1
What is Raise_application_error ?   1
what is the main difference between join and subqurey? Oracle 3
Can we use more than one null value for unique key? A1-Technology 31
What are the difference between Functions/Stored Procs and Triggers and where are they used. CGI 1
 
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