FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
121. What are the types of normalization forms?
 
    Different types of normalization forms are :
  • First normal form(1NF)
  • Second normal form(2NF)
  • Third normal form(3NF)
  • Boyce-Codd normal form(BCNF)
  • Fourth normal form(4NF)
  • Fifth normal form(5NF)
Your Name Your Email-ID
Your Answer
 
122. Define BCNF?
  BCNF stands for Boyce-COdd normal form.
A relation is said to be in Boyce-COdd normal form. If it is already in the third normal form and every determinant is a candidate key. It is a stronger version of 3NF.
Your Name Your Email-ID
Your Answer
 
123. What statement is used to remove a database privilege?
  The REVOKE statement is used to remove database privileges.
Your Name Your Email-ID
Your Answer
 
124. What are the differences between exact numeric data types and approximate numeric data types?
  With exact numeric data types, permitted values have a precision and scale. With approximate numeric data types, permitted values have a precision but no scale.
Your Name Your Email-ID
Your Answer
 
125. What clause is used to order data when creating a view?
  The GROUP BY clause functions in a view much as the ORDER BY clause (or GROUP BY clause) does in a regular query.
Your Name Your Email-ID
Your Answer