FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
26. Mention the advantages of using DBMS?
 
    The advantages of using DBMS are :
  • Controlling Redundancy
  • Enforcing Integrity Constraints so as to maintain the consistency of the database
  • Providing Backup and recovery facilities
  • Restricting unauthorized access
  • Providing multiple user interfaces
  • Providing persistent storage of program objects and data structures
Your Name Your Email-ID
Your Answer
 
27. Define entity?
  An entity is an object with a physical existence.
Your Name Your Email-ID
Your Answer
 
28. What is a view?
  A view is a virtual table that is created when the view is invoked (by calling its name). The table doesn't actually exist, only the SQL statement that defines the table.
Your Name Your Email-ID
Your Answer
 
29. What are the three types of data types that SQL supports?
 
    There are three types of data types that sql supports are :
  • Predefined
  • Constructed
  • User–defined
Your Name Your Email-ID
Your Answer
 
30. What is a set function?
  A set function is a type of function that processes or calculates data and returns the appropriate values.
Your Name Your Email-ID
Your Answer