FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
46. Define data models?
  Underlying the structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints.
Your Name Your Email-ID
Your Answer
 
47. What are the different types of data models?
 
    There are different types of data models are :
  • Relational model
  • Network model
  • Entity relationship model
  • Hierarchical model
  • Object oriented model
  • Object relational model
Your Name Your Email-ID
Your Answer
 
48. Which option must be used to drop a schema that still contains database objects?
  The CASCADE option allows the schema to be dropped if there are still objects under that schema.
Your Name Your Email-ID
Your Answer
 
49. What is an authorization identifier?
  An authorization identifier is an object in the SQL environment that represents a user or group of users that are granted specific access privileges to objects and data within the SQL environment.
Your Name Your Email-ID
Your Answer
 
50. How does a referential constraint differ from a unique constraint?
  Referential constraints are concerned with how data in one table relates to data in another table, ensuring referential integrity between the two tables. Unique constraints ensure the integrity within a table by blocking duplicate values.
Your Name Your Email-ID
Your Answer