Monday, May 16, 2011

[discussion_vu] Fwd: [ vuZs.net ] CS403 S2 Fall 2010 solved by me please check



---------- Forwarded message ----------
From: mc100400229 Rizwan Ahmed <mc100400229@vu.edu.pk>
Date: Sun, May 15, 2011 at 6:05 AM
Subject: Re: [ vuZs.net ] CS403 S2 Fall 2010 solved by me please check
To: vuzs@googlegroups.com


How much fee does student has to pay when he just Take his Project. He has to pay tuition fee of 6 credit hours or of 3 credit hours initially and bros and sisters what we have to do in the Project


On Sun, May 15, 2011 at 6:03 PM, Zubair Hussain <zubair@vuzs.net> wrote:
To my best knowledge all are correct as usual. Great going. 

Regards

Zubair Hussain
www.vuzs.net



On Sun, May 15, 2011 at 1:54 PM, R@ïñßøwßrïgh± <dngdng101@gmail.com> wrote:

MIDTERM EXAMINATION

FALL 2010

CS403- DATABASE MANAGEMENT SYSTEMS

 

Question No: 1 ( Marks: 1 ) - Please choose one

Which of the following is not a benefit of normalization?

► Minimize insertion anomolies

► Minimize deletion anomolies

► Minimize updation anomolies

Maximize redundancy

 

Question No: 2 ( Marks: 1 ) - Please choose one

Controlling redundancy in a database management system DOES NOT help to

► avoid duplication

► avoid unnecessary wastage of storage space

avoid unauthorized access to data

► avoid inconsistency among data

 

Question No: 3 ( Marks: 1 ) - Please choose one

In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?

► StudentID

► StudentID, CourseID

► StudentID, CourseID, InstructorID

StudentID, CourseSectionID

 

Question No: 4 ( Marks: 1 ) - Please choose one

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

► Join

► Union

Cartesian Product

► Set Difference

 

Question No: 5 ( Marks: 1 ) - Please choose one

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

► Physical data independence.

► Concurrency control.

Logical data independence.

► Functional dependency

 

Question No: 6 ( Marks: 1 ) - Please choose one

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.

 

Question No: 7 ( Marks: 1 ) - Please choose one

Identify the constraint that limits the values that can be placed in a column.

► Not null

► Check

► Foreign Key

► Unique

 

Question No: 8 ( Marks: 1 ) - Please choose one

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.

 

Question No: 9 ( Marks: 1 ) - Please choose one

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

 

Question No: 10 ( Marks: 1 ) - Please choose one

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 X Y then Y -> X

► If X -> Y then (X, Z) -> (Y,W).

 

Question No: 11 ( Marks: 1 ) - Please choose one

Which of the following is not a benefit of normalization?

► Minimize insertion anomolies

► Minimize deletion anomolies

► Minimize updation anomolies

► Maximize redundancy

 

Question No: 12 ( Marks: 1 ) - Please choose one

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

 

Question No: 13 ( Marks: 1 ) - Please choose one

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

 

Question No: 14 ( Marks: 1 ) - Please choose one

A________is used to maintain a connection between the users of the database system.

Select correct option:

►Mail server

File Server

►Client-server

►None of the given.

 

Question No: 15 Give types of relations (02 Marks)

 

Question No: 16 Briefly explain what is Partial Dependency (02 Marks)

 

Answer:

In database terminology, a partial functional dependency occurs when the value in a non-key attribute of a table is dependent on the value of some part of the table's primary key (but not all of it).

 

 

Question No: 17 Give at least 03 types of Anomalies which Normalization handles (03 Marks)

Answer:

 

  • Redundancy
  • Insertion Anomaly
  • Deletion Anomaly
  • Updation Anomaly

 

Question No: 18 What is Data Definition Language (DDL) ? (03 Marks)

 

Answer:

The language is used to translate physical design to actual data object

Creat

Alter

Drop

Modify

Used for table and columns

 

Question No: 19 Briefly explain what is a primary key and give example. (05 Marks)

 

Answer:

The primary key uniquely identifies the entity instance in entity type.

The primary key uniquely identifies the record in table

 

Candidate key selected to uniquely identify the record in the table.

This is also called the successful candidate key.

 

Question No: 20 What are the benefits of using default values? (05 Marks)

Answer:

If we don't give value to a particular attribute it will automatically give a value to that attribute. Default value constraint is used for efficiency purpose in data entry process.

For example at the time of admission at same class level all students have same age except some exceptions.

 

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
You received this message because you are subscribed to the Google Groups "Virtual University of Pakistan" group.
To post to this group, send email to discussion_vu@googlegroups.com.
To unsubscribe from this group, send email to discussion_vu+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/discussion_vu?hl=en.

No comments:

Post a Comment

PAID CONTENT