Sql Interview Question and Answers

31. What are the types of SQL Commands?
 
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
 
Your Name Your Email-ID
Your Answer
32. What is an attribute?
 
    An entity is represented by a set of attributes.
    Attributes are descriptive properties possessed by each member of an entity set.
    There are different types of attributes.
  • Simple
  • Composite
  • Single-valued
  • Derived
 
Your Name Your Email-ID
Your Answer
33. What are the different types of data models ?
 
  • Entity relationship model
  • Relational model
  • Hierarchical model
  • Network model
  • Object oriented model
  • Object relational model
 
Your Name Your Email-ID
Your Answer
34. What is an active database?
  Active database is a database that includes active rules, mostly in the form of ECA rules(Event Condition rules).
Active database systems enhance traditional database functionality with powerful rule processing cabalities, providing a uniform and efficient mechanism for database system applications.
 
Your Name Your Email-ID
Your Answer
35. Define Self Join?
  Self join means joining one table with itself.
The self join can be viewed as a join of two copies of the same table.
 
Your Name Your Email-ID
Your Answer
123456789101112131415


16171819202122232425 Page 7 of 25