CS-403 Final Term Exams Preparation Virtual University With Answers

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 Structural constraints of a relationship type refer to identifying the owner entity type relevant to a given entity type whether the existence of an entity depends on it being related to another entity via the relationship type. the role that a participating entity from the entity type plays in each relationship instance the constraints applicable in granting access to tables, columns and views in a database schema.
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 Which of the following is correct regarding Dataflow diagram? Single DFD is required to represent a system The dataflow must be bidirectional Created at increasing levels of detail Used to represent the relationships among the external entities
4 Which of the following is INCORRECT with respect to file systems? At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data independence at the user level. A logical record is concerned with efficient storage of information in the secondary storage devices. Some physical organisations use pointers to record blocks to locate records on disk. The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file.
5 DML commands are used for: inserting data into databases creating databases destroying databases creating DB objects
6 Which of the following types of partitioning reduces the chances of unbalanced partitions? vertical List Hash Range
7 Which of the following is incorrect with respect to indexed sequential files? New records are added to an overflow file Record in main file that precedes it is updated to contain a pointer to the new record The overflow is merged with the main file during a batch update Multiple indexes for the same key field cannot be setup
8 Which of the following is not true with respect to denormalization ? A denormalized data model is not the same as a data model that has not been normalized Denormalization takes place before the normalization process It is an attempt to optimize the performance of database Denormalization process can not be initiated before the Database design
9 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 dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.
10 Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI? SELECT * FROM CUST WHERE last_name='ALI'; SELECT * FROM CUST WHERE last_name=ALI; SELECT * FROM CUSTOMER WHERE name=ALI; SELECT * FROM CUSTOMER WHERE last_name=ALI;
Download This Set

Is this page helpful?