Docstoc

CS403 MID TERM PAPER

Document Sample
CS403 MID TERM PAPER Powered By Docstoc
					CS403 MID TERM PAPER

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


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.



Question No: 2 ( 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: 3 ( Marks: 1 ) - Please choose one

A database system allows the following EXCEPT

management and control of data towards an efficient working of an
organisation.
more critical functions in organisations to be computerised and the need to keep
a large
volume of data available in an up to the minute current state increased.

any user to access all its data.

integration of data across multiple applications into a single application.



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

Which of the following is true regarding relations?
Every attribute value is non-atomic.

Attributes in tables may not have unique names

The order of the columns is relevant.

The order of the rows is irrelevant.



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

Which of the following concept is applicable with respect to 2NF?

Non-transitive dependency
Full functional dependency
Partial dependency
Transitive dependency


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

Consider the following relation and its sample data. (Consider that these are the
only tuples for the given relation)


Which of the following statements is NOT correct?
The functional dependency (EmpNo, DeptNo) -> ProjNo holds over R.
The functional dependency EmpNo -> DeptNo holds over R.
The functional dependency ProjNo -> DeptNo holds over R.

The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.



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

Which of the following enforces a relation into 1st normal form?
The domain of attribute must include only atomic values.

Every non-key attribute is fully functionally dependent on primary key
non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key



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

Which of the following concepts is applicable with respect to 3NF?
Full functional dependency
Any kind of dependency

Transitive dependency
Partial functional dependency



Question No: 9 ( 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: 10 ( Marks: 1 ) - Please choose one

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


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

Which of the following is NOT a component of a DFD?

Dataflow

Datastore

External entities

Relationship between external entities



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

Consider the relations given below. The relations given in (i) and (ii)
respectively have been
achieved by normalising the relation Person(NID, {Car_Lic#}, {Phone#})
(i) Person(NID, Car_Lic#, Phone#)
(ii) Person1(NID, Car_Lic#) ; Person2(NID, Phone#)
Which of the following statements is correct with respect to solutions (i) and
(ii)?

Solution (i) is considered as the better solution since solution (ii) introduces
new relations.
Solution (ii) is considered as the better solution since solution (i) results in an
all-key
relation.

Solution (ii) suffers from redundancy.
Only solution (i) holds dependency preservation property.


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

Which of the following statements is correct with respect to entity integrity?
Entity integrity constraints specify that primary key values can be composite.
Entity integrity constraints specify that no primary key value can be null.
Entity integrity constraints are specified between weak entities.
When entity integrity rules are enforced, a tuple in one relation that refers to
another relation must refer to an existing tuple.



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

Consider the following diagram depicting a kind of a relationship type where X
and Z are entities and Y is a relationship type:

Select the correct statement among the following on the above diagram.

The relationship type Y is of cardinality ratio 1 : N.
The diagram depicts existence dependencies.
The participation of X in the Y relationship type is total.
The participation of Z in the Y relationship type is partial.


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

Identify the factor which enforces a relation in 3NF?
Every non-key attribute is fully functionally dependent on primary key
Every non-key attribute is partially dependent on super key

The domain of attribute must include only atomic values.

Every non-key attribute is non-transitively dependent on primary key.
Question No: 16 ( Marks: 1 ) - Please choose one

Consider the given relations Student and Instructor as given below. Please note
that
Fname and Lname also denote the First Name and Last Name respectively.



Which of the following statements is correct with respect to the two relations
given above?

The two relations are not union-compatible since their attribute names differ.




cs 615 midterm


Question No: 1 ( Marks: 1 ) - Please choose one
________ identifying which quality standards are relevant to the project and
determining how to satisfy them.
► Quality Planning
► Communications Planning
► Organization Planning

► Staff Acquisition

Question No: 2 ( Marks: 1 ) - Please choose one
These all are outputs of Initiating Process except
► Project Manager Assignments
► Constraints
► Selection Criteria

► Assumptions
Question No: 3 ( Marks: 1 ) - Please choose one
Project management processes can be organized into _____________ groups
► Four
► Five
► Six

► Seven


Question No: 4 ( Marks: 1 ) - Please choose one
Product quality depends on its conformance to ______
► Software requirements
► Development standards
► Implicit requirements

► All of given


Question No: 5 ( Marks: 1 ) - Please choose one
_______is the technical kernel of software engineering
► Design
► Implementation
► Requirements analysis

► Testing


Question No: 6 ( Marks: 1 ) - Please choose one
Mode of specification has a great impact on quality of solution. Forcing SWE
to work with incomplete, inconsistence, or misleading specifications result in
frustration and confusion affecting:

► Quality
► Timeliness and
► Completeness of SW product

► All of given
Question No: 7 ( Marks: 1 ) - Please choose one
Finally, the specification includes a ________
► Bibliography
► Appendix
► Both Bibliography and Appendix

► Reference


Question No: 8 ( Marks: 1 ) - Please choose one
Cognitive model describes a system as perceived by its _________

► User community
► Developer
► Top level management

► Manager


Question No: 9 ( Marks: 1 ) - Please choose one
A review of the Software Requirements Specification is conducted by
________

► Software developer
► Customer
► Both the software developer and the customer

► Top level management


Question No: 10 ( Marks: 1 ) - Please choose one
A meeting is conducted at a _________ and attended by both software
engineers and customers.

► Software engineer site
► Neutral site

► Customer site
► Company site


Question No: 11 ( Marks: 1 ) - Please choose one
The model serves as the basis for the creation of ________ for the Software.
► Design
► Maintenance
► Testing

► Specifications


Question No: 12 ( Marks: 1 ) - Please choose one
Throughout evaluation and solution synthesis, the analyst's primary focus is on
► "What, not "how."

► Model
► Evaluation and Synthesis

► Specification


Question No: 13 ( Marks: 1 ) - Please choose one
In problem evaluation area of effort, once problems have been identified, the
___________determines what information is to be produced by the new
system and what data will be provided to the system.
► Analyst
► Designer
► Coder

► Manager


Question No: 14 ( Marks: 1 ) - Please choose one
Requirements are refined and analyzed to assess their clarity, completeness,
and_______
► Correctness
► Consistency
► Concurrency

► None of given


Question No: 15 ( Marks: 1 ) - Please choose one
A software project that meets all the stated objectives is a success of
_________


► Project quality
► Project fundamental purpose
► Project management myth

► Project requirement


Question No: 16 ( Marks: 1 ) - Please choose one
All of the following describe the activity list except:
► It’s an extension of the WBS
► It include all activities of the project
► It describe the WBS update

► It include a description of project activities


Question No: 17 ( Marks: 1 ) - Please choose one
Software project are carried out sequentially and that each phase is
completed before the next is taken up.
► The Prototyping Model
► The Incremental Model
► The Waterfall model
► The Spiral model

Question No: 18 ( Marks: 1 ) - Please choose one
Project management is a _________of constant communication and
negotiation.
► Process
► Concept
► Practice
► None of given


Question No: 19 ( Marks: 1 ) - Please choose one
These all are design phase activities except
► Output Design
► Input Design
► The software test plan
► Software Selection


Question No: 20 ( Marks: 1 ) - Please choose one
Which organization has set the de facto standards for project management
techniques?
► PMBOK
► PMI
► PMA

► PMO
PMA


Question No: 21 ( Marks: 2 )
Give the name of configuration control tools?

Question No: 22 ( Marks: 3 )
Software requirements analysis a bridge between system engineering and
software design, show it by diagram.

Question No: 23 ( Marks: 5 )
Write down the software process player’s names and their roles in projects.

Question No: 24 ( Marks: 10 )
Explain the following terms regarding project characteristics and project
dimensions.
· Temporary,
· Unique,
· Aims,
· People,
· Process

				
DOCUMENT INFO
Shared By:
Categories:
Tags: CS403
Stats:
views:79
posted:3/10/2011
language:English
pages:12
Description: CS403 HELPING MATERIALS