VU CS-403 Online Test Preparation

CS-403 Final Term Exams Preparation Virtual University

Sr. #	Questions	Answers Choice
1	Select the correct statement among the following	When different entity types participate only once in a single relationship type it is called a recursive relationship Role names are not technically necessary in relationship types when all the participating entity types are distinct Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship .
2	Select the correct statement among the following on proper naming of schema constructs:	Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type. In the narrative description of the database requirements, verbs tend to indicate the names of relationship types. The nouns arising from a database requirement description can be considered as names of attributes Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.
3	Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of	Physical data independence Concurrency control. Logical data independence. Functional dependency
4	Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?	Join Union Cartesian Product Set Difference
5	In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?	StudentID StudentID, CourseID StudentID, CourseID, InstructorID StudentID, CourseSectionID
6	Which one is true regarding relation?	Every attribute value Non atomic Attribute in table may not have unique name table order of the column is relevant the order of the rows is irrelevant
7	Description on particular collection of data using data model	Schema Relation Data base None of the above
8	Which of the following concepts is applicable with respect to 3NF	Full functional dependency Any kind of dependency Transitive dependency Partial functional dependency
9	Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?	Join Union Cartesian Product Set Difference
10	Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?	6 9 5 4

Download This Set