FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Follow Us
 
96. What are some of the reasons differences in SQL exist?
  Differences exist in SQL among the vendors because of storage requirements, advantages over competitors, ease of use, and performance considerations.
Your Name Your Email-ID
Your Answer
 
97. What statement must you include in your CREATE TRIGGER statement if the trigger definition includes more than one triggered SQL statement?
  BEGIN...END statement
Your Name Your Email-ID
Your Answer
 
98. Describe the three levels of data abstraction?
 
    The are three levels of abstraction :
  • Physical level : The lowest level of abstraction describes how data are stored.
  • Logical level : The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
  • View level : The highest level of abstraction describes only part of entire database.
Your Name Your Email-ID
Your Answer
 
99. What type of view does the WITH CHECK OPTION clause apply to?
  The WITH CHECK OPTION clause applies to updatable views that include a WHERE clause in the SELECT statement.
Your Name Your Email-ID
Your Answer
 
100. What is XML?
  XML is a general-purpose markup language used to describe documents.
Your Name Your Email-ID
Your Answer