Sql Interview Question and Answers:
119. What are cursors?
Cursors allow row-by-row prcessing of the result sets.
120. What is a weak entity types?
The entity types that do not have key attributes of their own are called weak entity types. Rests are called strong entity types .The entity that gives identity to a weak entity is called owner entity. And the relationship is called identifying relationship. A weak entity type always has a total participation constraint with respect to its identifying relationship.
121. What are defaults?
A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them.
122. What is specialization?
It is the process of defining a set of subclasses of an entity type where each subclass contain all the attributes and relationships of the parent entity and may have additional attributes and relationships which are specific to itself.
119. What are cursors?
Cursors allow row-by-row prcessing of the result sets.
120. What is a weak entity types?
The entity types that do not have key attributes of their own are called weak entity types. Rests are called strong entity types .The entity that gives identity to a weak entity is called owner entity. And the relationship is called identifying relationship. A weak entity type always has a total participation constraint with respect to its identifying relationship.
121. What are defaults?
A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them.
122. What is specialization?
It is the process of defining a set of subclasses of an entity type where each subclass contain all the attributes and relationships of the parent entity and may have additional attributes and relationships which are specific to itself.
ReplyDeleteio jogos net
friv school Games to play
a10 best free online game
Since Saturday I decided to take my training for the next few weeks into my own hands as the current training and nutrition style was a little too much. I have 15 weeks to go, so not feeling the need to be so drained so far out.