FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
116. What is Magic Table in SQL?
  The Insert and Delete commands are known as magic tables in SQL.
Your Name Your Email-ID
Your Answer
 
117. What are the four types of string data types?
 
    String data types are :
  • Character strings
  • National character strings
  • Bit strings
  • Binary strings
Your Name Your Email-ID
Your Answer
 
118. Which keyword should you add to an ORDER BY clause to sort data in descending order?
  DESC
Your Name Your Email-ID
Your Answer
 
119. What is a pre–requisite for connection pooling?
  Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.
Your Name Your Email-ID
Your Answer
 
120. What are some major disadvantages of using indexes?
 
    Major disadvantages of an index include
  • Slowing batch jobs
  • Storage space on the disk
  • Maintenance upkeep on the index.
Your Name Your Email-ID
Your Answer