CS-403 Final Term Exams Preparation Virtual University With Answers

image
image
image

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 Select the correct statement among the following. Role names are not technically necessary in relationship types when all the participating entity types are distinct When different entity types participate only once in a single relationship type it is called a recursive relationship. 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 Which of the following is true about NOT NULL constraint? enforce domain integrity limit the values that can be placed in a column prevents any actions that would destroy links between tables with the corresponding data values enforces the uniqueness of the values in a set of columns
3 The ER- data model is an example of: Physical database Logical database Relational database Conceptual database
4 A database system allows the following EXCEPT management and control of data towards an efficient working of an organisation more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased. any user to access all its data integration of data across multiple applications into a single application.
5 Which of the following concepts is applicable with respect to 2NF? Full functional dependency Any kind of dependency Transitive dependency Non-transitive dependency
6 Database management systems, operating systems, applications and utilities are all examples of ____. hardware software computer infrastructure input and output
7 The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype specialization uniqueness inheritance completeness
8 A collection of concepts that can be used to describe the structure of a database Database DBMS Data model Data
9 Identify the INCORRECT statement among the given. An entity may be an object with a physical existence like a car, a house or an Employee One cannot consider something which has conceptual existence like a course in a degree program as an entity Age can be considered as a single value attribute of a person. An entity type describes the schema or intension for a set of entities which share the same structure.
10 Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies. FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo FD3 : StaffNo, InterviewDate -> RoomNo Which of the following is correct? The relation Interview is in 3NF The relation Interview is in BCNF. The FD3 violates 3NF. The FD2 violates 2NF
Download This Set
×