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 Identify which of the above statements is/are correct. Only A Only B Only B and C Only A and B
2 Identify the correct statement with respect to normalization Normalization is a formal technique that can be used only at the starting phase of the database design Normalization can be used as a top-down standalone database design technique The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed. The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
3 Consider two sets A and B. A contains 3 elements and B contains 4. How many elements do their Cartesian product contains? 12 9 16 7
4 Controlling redundancy in a database management system DOES NOT help to avoid duplication avoid unnecessary wastage of storage space avoid unauthorised access to data avoid inconsistency among data
5 Which of the following is CORRECT about database management system's languages? Data definition languages are used to specify the conceptual schema only. Data manipulation languages are used to create the databases Data manipulation languages are used for retrieval, insertion, deletion and modification of data Data definition langauges are only used to update data in the DBMS.
6 Which of the following is NOT a component of a DFD? Dataflow Datastore External entities Relationship between external entities
7 A ______ is used to maintain a connection between the users of the database system. Mail server File Server Client-serve None of the given.
8 Incase of Context-level Diagram, the system is represented by
Select correct option:
 One process atleast Two processes atleast One process only Any number of processes
9 A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a superkey candidate key primary key secondary key
10 If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct? If (X, Z) -> Y then X -> Y and Z -> Y. If X -> Y and X -> Z then X -> (Y, Z) If XY then Y -> X If X -> Y then (X, Z) -> (Y,W).
Download This Set
×