Mid Term Question
CS201 MID TERM SOLVED MCQs || PAST PAPERS || GROUP-1 || INTRODUCTION TO PROGRAMMING || VuTech Visit Website For More Solutions www.vutechofficial.blogspot.com …
______________________________
______________________________
Which of the following most certainly implies the need for an entire table to implement?
a) A binary relationship
b) A ternary relationship
c) A recursive relationship
d) An identifying relationship
Which of the following constraints enforces entity integrity?
a) PRIMARY KEY
b) FOREIGN KEY
c) CHECK
d) NOT NULL
Which of the following is not true about relational tables?
a) Column values are of the same kind
b) Each row is unique
c) Each column must have a unique name
d) The sequence of rows is significant
In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
a) 1:1
b) 1:M
c) M:M
d) Ternary
Controlling redundancy in a database management system DOES NOT help to
a) avoid duplication
b) avoid unnecessary wastage of storage space
c) avoid unauthorized access to data
d) avoid inconsistency among data
Which of the following functions are NOT performed by a database administrator?
a) Planning, designing and implementing database systems
b) Establishing standards and procedures for database systems
c) Communicating with database users
d) Allocation of storage locations and data structures
Select the correct statement about the ANSI/SPARC architecture.
a) The conceptual level is a level of indication between the internal level and the external level.
b) The internal level in a database system will definitely be relational.
c) Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
d) The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.
Which of the following is a correct way to implement one-to-many relationship while designing tables?
a) by splitting the data into two tables with primary key and foreign key relationships
b) using a junction table with the keys from both the tables forming the composite primary key of the junction table
c) by splitting each table into three
d) as a single table and rarely as two tables with primary and foreign key relationships
Which of the following is not a benefit of normalization?
a) Minimize insertion anomolies
b) Minimize deletion anomolies
c) Minimize updation anomolies
d) Maximize redundancy
The Entity Relation Model models
a) Entities, Relationships and Processes
b) Entities and Relationships
c) Relationships
d) Entities
About VuTech
Soratemplates is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design. The main mission of soratemplates is to provide the best quality blogger templates which are professionally designed and perfectlly seo optimized to deliver best result for your blog.
We provide Virtual University of Pakistan Study Materials such as Solution of Assignments, GDBs, Mid Term Solved Papers, Final Term Solved Papers, Mid Term Solved MCQs, and Final Term Solved MCQs. We also provide regular Semester Quizzes, Updated Handouts, and Short Questions and Answers. We help you with your research and many other educational-related topics, as far as we know. Furthermore, Share your problem with us and Please feel free to ask any related questions.
