VU CS-403 Online Test Preparation

CS-403 Final Term Exams Preparation Virtual University

Sr. #	Questions	Answers Choice
1	A relation (from the relational database model) consists of a set of tuples, which implies that	all tuples in a relation must be distinct. relational model supports multi-valued attributes whose values can be represented in sets for any two tuples, the values associated with all of their attributes may be the same all tuples in a particular relation may have different attributes.
2	User rights information is stored in	Physical database Catalog Logical database Buffer
3	As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.	primary key foreign key index determinant
4	The Entity Relation Model models	Entities, Relationships and Processes Entities and Relationships Relationships Entities
5	Which of the following is not a benefit of normalization?	Minimize insertion anomolies Minimize deletion anomolies Minimize updation anomolies Maximize redundancy
6	Which of the following is a correct way to implement one-to-many relationship while designing tables?	by splitting the data into two tables with primary key and foreign key relationships using a junction table with the keys from both the tables forming the composite primary key of the junction table. by splitting each table into three as a single table and rarely as two tables with primary and foreign key relationships
7	Select the correct statement about the ANSI/SPARC architecture	The conceptual level is a level of indication between the internal level and the external level. The internal level in a database system will definitely be relational. Any given database has many conceptual schemas and one physical schema, but it has only one external schemas. The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.
8	Which of the following functions are NOT performed by a database administrator?	Planning, designing and implementing database systems Establishing standards and procedures for database systems Communicating with database users Allocation of storage locations and data structures
9	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
10	In a conceptual model for a university, what type of relationship exists between Grade and Student entities?	1:1 1:M M:M Ternary

Download This Set