Sql Interview Question and Answers

51. What is OLTP?
  Online Transaction Processing (OLTP) relational databases are optimal for managing changing data. When several users are performing transactions at the same time, OLTP databases are designed to let transactional applications write only the data needed to handle a single transaction as quickly as possible.
 
Your Name Your Email-ID
Your Answer
52. What is DDL (Data Definition Language)?
  A data base schema is specifies by a set of definitions expressed by a special language called DDL.
 
Your Name Your Email-ID
Your Answer

53. What is Weak Entity set?
  An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.
 
Your Name Your Email-ID
Your Answer
54. What is a deadlock?
  Two processes wating to update the rows of a table which are locked by the other process then deadlock arises.
 
Your Name Your Email-ID
Your Answer
55. What do you mean by flat file database?
  It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is user-friendly and provides user-interface management.
 
Your Name Your Email-ID
Your Answer