FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
91. What are the conditions to achieve the normalization?
 
    There are few conditions to achieve the normalization :
  • There should be a unique row identifier.
  • A table should store only data for a single type of entity.
  • A table should avoid columns which can be null–able.
  • A table should avoid duplication of data and columns.
Your Name Your Email-ID
Your Answer
 
92. Can a trigger be altered?
  No, the trigger must be replaced or re–created
Your Name Your Email-ID
Your Answer
 
93. Which clauses in an UPDATE statement can contain a subquery?
  WHERE and SET
Your Name Your Email-ID
Your Answer
 
94. What option can be used when creating a view from a view to check integrity constraints?
  The WITH CHECK OPTION
Your Name Your Email-ID
Your Answer
 
95. What is the difference between Count and Count (*)?
 
  • Count : Counts the number of non-null values.
  • Count (*) : Counts the number of rows in the table, including null values and duplicates.
Your Name Your Email-ID
Your Answer