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 (2035)
 SQL Server interview questions  SQL Server Interview Questions (1075)
 MS Access interview questions  MS Access Interview Questions (24)
 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 (768)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
Question
1. what is the exact use of hint in sql.

2. How we can avoid index scan in sql even though index is 
there in the table.
 Question Submitted By :: Durgesh Kumar Behera
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
Answer
# 1
1. Hints instructs the optimizer to generate the explain
plan as hinted rather than the optimizer choosing its own
explain plan..

2. There are many ways like disabling the index usage by
implementing a function or an operation on the indexed
column OR giving a FULL hint in the query for that
particular table etc
 
Is This Answer Correct ?    6 Yes 0 No
Karkuvelrajan Muthusamy
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
overloading of stored procedure is possible in oracle? Nelco 3
what is difference b/w pravite procedures and public procedures? Wipro 3
pl/sql testing means what ...... explain process how to find pl/sql bugs Zensar 1
What is the Difference between Procedure and Function.Can we call a Function in a DML? TCS 2
what is difference between pass by value and eference by value in oracle plsql   1
Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')   1
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --   4
What are different types of refreshment techniques of materialised view   2
what is purge command explain about oracle performance tuning Accenture 2
can i use global variables in stored procedure or function L&T 1
Find out the 3rd highest salary? BirlaSoft 50
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman Satyam 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