Interview Questions → DBA → DBA Questionnaire IIIDBA Questionnaire IIIWhat is Object Oriented model? This model is based on collection of objects. An object contains values stored in instance variables within the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.What is an Entity? It is a 'thing' in the real world with an independent existence.What is an Entity type? It is a collection (set) of entities that have same attributes.What is an Entity set? It is a collection of all entities of particular entity type in the databaseWhat is an Extension of entity type? The collections of entities of a particular entity type are grouped together into an entity set.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.What is an attribute? It is a particular property, which describes the entity.What is a Relation Schema and a Relation? A relation Schema denoted by R(A1, A2, …, An) is made up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples. Let r be the relation which contains set tuples (t1, t2, t3, ..., tn). Each tuple is an ordered list of n-values t=(v1,v2, ..., vn).What is degree of a Relation? It is the number of attribute of its relation schema.What is Relationship? It is an association among two or more entities.Posted By - Prayas Chaudhary Query/Feedback Your Email Id Subject Query/Feedback Characters remaining 250
Query/Feedback