Sql Interview Question and Answers

116. What are the different types of cursors?
 
    Types of cursors :
  • Static
  • Dynamic
  • Forward-only
  • Keyset-driven
 
Your Name Your Email-ID
Your Answer
117. What is a Catalog?
  A catalog is a table that contain the information such as structure of each file ,the type and storage format of each data item and various constraints on the data .The information stored in the catalog is called Metadata . Whenever a request is made to access a particular data, the DBMS s/w refers to the catalog to determine the structure of the file.
 
Your Name Your Email-ID
Your Answer
118. What is a view?
  A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored.
 
Your Name Your Email-ID
Your Answer
119. What are different types of end users?
 
  • Casual end-users
  • Casual end-users
  • Sophisticated end users
  • Stand alone users
 
Your Name Your Email-ID
Your Answer
120. Compare DBMS versus object oriented DBMS?
  DBMS consists of a collection of interrelated data and a set of programs to access that data.
The object oriented DBMS is one of the type of dbms in which information is stored in the form of objects.
 
Your Name Your Email-ID
Your Answer