CS504- Software Engineering - I Finalterm Complete Solved Paper 2010

FINALTERM  EXAMINATION

Spring 2010

CS504- Software Engineering - I (Session - 3)

Ref No:

Time: 90 min

Marks: 58

Student Info
StudentID:
Center:
ExamDate:

http://www.allvupastpapers.blogspot.com/

    

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

 Quantitative methods for assessing the quality of proposed architectural designs

are readily available.

       ► True

       ► False

   

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

 A decision table should be used_______________________

       ► to document all conditional statements

       ► to guide the development of the project management plan

       ► only when building an expert system

       ► when a complex set of conditions and actions appears in a component

   

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

  Test cases should be designed long before testing begins.

       ► True

       ► False

   

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

 Which of the following are characteristics of testable software?

       ► observability

       ► simplicity

       ► stability

       ► all of the given

http://www.allvupastpapers.blogspot.com/

   

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

 Comparison testing is typically done to test two competing products as part of

customer market analysis prior to product release.

       ► True

       ► False

   

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

 By collecting software metrics and making use of existing software reliability

models it is possible to develop meaningful guidelines for determining when software testing is done.

       ► True

       ►  False

   

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

 Configuration reviews are not needed if regression testing has been rigorously applied during software integration.

http://www.allvupastpapers.blogspot.com/

       ► True

       ► False

   

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

 A change becomes ------------- because of close presence of data and fucntions

       ► Localized

       ► Private

       ► Global

       ► Accessible

   

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

 Requirement engineering mainly deals with the -------------- of the system

       ►  definition phase

  http://www.allvupastpapers.blogspot.com/

     ► development phase

       ► maintenance

       ► non of the above

   

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

 40-60% of all defects found in software projects can be traced back to poor -----------

       ► Requirements

       ► Design

       ► Coding

       ► Testing

   

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

 In the N-Tire Architecture  the idea is to enhance scalability and -------------- by distributing both the data and the application using multiple server machines.

       ► Performance

       ► Efficiency

       ► Usability

       ► non of the all

   

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

 MVC pattern was based on the --------------- pattern.

http://www.allvupastpapers.blogspot.com/

       ► Observer

       ► Structural

       ► Behavioral

       ► Non of them

   

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

 Classes should be declared in individual header files with the file name matching the

---------- name.

       ► class

       ► method

       ► object

       ► non of the all

   

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

 Unit testing is roughly equivalent to ----------  testing for hardware in which each chip is tested

thoroughly after manufacturing

 http://www.allvupastpapers.blogspot.com/

      ► Circuit level

       ► Chip Level

       ► component level

       ► system level

   

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

 Software should be tested more like hardware, with  Built-in self testing: such that each unit can be tested -------------

       ► freely

       ► independently

       ► dependtly

       ► completely

   

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

 A system -------------  is the period in which tremendous pressure is on developers end to fix the problem and make the system running again

       ► Uptime

       ► Downtime

       ► Currentime

       ► futuretimr

   

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

 Which one of the given below is not a symptom of memory overrun?

       ► Program crashes quite regularly after a given routine is called, that routine should be examined for a possible overrun condition.

http://www.allvupastpapers.blogspot.com/

       ► If the routine in question does not appear to have any such problem the most likely cause is that another routine, called in the prior sequence, has already

trashed variables or memory blocks.

       ► Checking the trace log of the called routines leading up to one with the problem will often show up the error.

       ► Compiler warnings.

   

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

 Software architecture elements are further divided into categories which in total are -----------

       ► 2

       ► 3

  http://www.allvupastpapers.blogspot.com/

     ► 4

       ► 5

   

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

 Three tier architecture contains ------------- layers

       ► Presentation

       ► Application

       ► Database

       ► All of the above

   

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

 1. Variables should be initialized where they are declared and they should be declared in

the -------------- scope possible.

       ► Smallest

       ► largest

       ► medium

       ► None of the given

   

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

 ------------------ are two important tools that can help in managing and mastering the complexity of a program.

       ► abstraction and encapsulation

http://www.allvupastpapers.blogspot.com/

       ► abstraction and Inheritence

       ► abstraction and Polymarhphism

       ► None of given

   

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

 Which of the following is a/are tool used in requirement analysis?

       ► Flow Graphs

       ► Data Flow Diagrams

       ► Activity Networks

       ► Module Dependency Diagrams

   

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

 Consider the following comment. “The software which I bought won’t run on windows and when it runs I can’t use WORD at the same time”. Which of the following do you think are violated by the newly bought software?

       ► dependability, interchangeability

     http://www.allvupastpapers.blogspot.com/

  ► platform independence, interoperability

       ► reliability, dependency

       ► interoperability, reliability

   

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

 ……………… is a diagramming technique used to identify the types of objects in the system and the static relationships that exist among them.

       ► Class Diagram

       ► Document flow diagrams

       ► Data flow diagrams

       ► Flow charts

   

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

 Which of the following interaction style best suit the design of an interface for visually impaired users?

       ► direct manipulation

       ► direct manipulation

       ► natural language

       ► command line

  http://www.allvupastpapers.blogspot.com/

 

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

 Which of the following testing involve purely black box testing?

       ► unit testing, beta testing

       ► acceptance testing, interface testing

       ► beta testing, acceptance testing

       ► integration testing, interface testing

   

Question No: 27    ( Marks: 2 )

  what does this mean” Object Creation and Life Time”?

   

Question No: 28    ( Marks: 2 )

 How one can avoid hazards caused by side effects while writing code. List the two guidelines.

http://www.allvupastpapers.blogspot.com/

   

Question No: 29    ( Marks: 2 )

  What is the greatest advantage of exception handling?

   

Question No: 30    ( Marks: 2 )

 Give 2 Unit Testing Tips.

http://www.allvupastpapers.blogspot.com/

Question No: 31    ( Marks: 3 )

  Write unit testing quantitative benefits.

    Question No: 32    ( Marks: 3 )

 How Comments should be indented relative to their position in the code? Give an example

   

Question No: 33    ( Marks: 3 )

 Consider the following code fragment.

while a

{

while b

c

d

}

If you were to test this code, what would be the test technique to adopt?

http://www.allvupastpapers.blogspot.com/

   

Question No: 34    ( Marks: 5 )

  Narrate the manner for the organization of Class and Interface declarations

   

Question No: 35    ( Marks: 5 )

 Discus the symptoms and an example of coding error bug class.

http://www.allvupastpapers.blogspot.com/

   

Question No: 36    ( Marks: 5 )

 Why Code portability is so important ? Give out 3 ways / Guide lines  to improve the code portability with examples

(5+5)

http://www.allvupastpapers.blogspot.com/

Complete Solved Finalterm Paper of CS403- Database Management Systems 2010

FINALTERM  EXAMINATION

Spring 2010

CS403- Database Management Systems

Time: 90 min

Marks: 58

Student Info
Student ID:
Center:
Exam Date:

http://www.allvupastpapers.blogspot.com/

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

Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?

       ►

       ►

       ►

       ►

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

http://www.allvupastpapers.blogspot.com/

Which of the following statements are Data Definition Language command?

       ► INSERT

       ► UPDATE

       ► GRANT

       ► TRUNCATE

http://www.allvupastpapers.blogspot.com/

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

Which of the following statements is true about the views?

       ► view is always a complete set of all the tables in a database

       ► View can not be used for retrieving data

       ► The results of using a view are not permanently stored in the database.

       ► Rows can not be updated or deleted in the view

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

How many clustered index(es) do each database table have?

       ► 2

       ► 3

       ► 5

       ► 1

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

 http://www.allvupastpapers.blogspot.com/

Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

       ► 24

       ► 20

       ► 18

       ► 15

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

Which of the following is not one of the properties of Transaction?

       ► atomicity

       ► consistency

       ► redundancy

       ► durability

http://www.allvupastpapers.blogspot.com/

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

Which of the following is INCORRECT about VIEWS?

       ► It is not possible to left out the data which is not required for a specific view.

       ► A database view displays one or more database records on the same page.

       ► Views can be used as security mechanisms

       ► Views are generally used to focus the perception each user

has of the database.

http://www.allvupastpapers.blogspot.com/

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

Which of the following gives all the fields from employee table named as EMP?

       ► select * from EMP;

       ► select emp* from EMP'

       ► select emp_id where EMP;

       ► select * where EMP;

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

Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)

and the following functional dependencies.

FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo

FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo

FD3 : StaffNo, InterviewDate -> RoomNo

Which of the following is correct?

       ► The relation Interview is in 3NF

http://www.allvupastpapers.blogspot.com/

       ► The relation Interview is in BCNF.

       ► The FD3 violates 3NF.

       ► The FD2 violates 2NF.

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

Which of the following types of partitioning reduces the chances of unbalanced partitions?

       ► vertical

       ► List

       ► Hash

       ► Range

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

Which of the following is one of the purposes of using DDL commands?

       ► inserting records into databases

       ► updating records into databases

       ► manipulating databases

       ► creating and destroying databases

http://www.allvupastpapers.blogspot.com/

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

Which of the following statements creates a database named COMPANY.

       ► CREATE DATABASE company

       ► CREATE DB company

       ► ADD DATABASE copmany

       ► CREATE company DATABASE

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

What is the impact of setting multiple indexes for the same key, in index sequential files?

       ► Multiple indexes for the same key can not be set

       ► It increases efficiency

       ► It decreases efficiency

       ► It will increase complexity as the access time will be increased

http://www.allvupastpapers.blogspot.com/

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

Consider a transaction which includes following operations

…

Z= Z + 10

Write Z

...

Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be

<Tn, Z, 33>

What does Z reflects in the above entry?

       ► Object being updated

       ► Identity of the transaction

       ► Object value

       ► Identity of the next transaction to be executed

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

http://www.allvupastpapers.blogspot.com/

Which of the following is not true regarding DB transactions?

       ► A set of database operations that are processed partly

       ► A database transaction is a logical unit of database operations

       ► A database transaction must be atomic

       ► A database transaction must contains the ACID property

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

Which of the following is not true about input forms?

       ► Provide an easy, effective, efficient way to enter data into a table

       ► Especially useful when the person entering the data is not familiar with the inner workings

       ► Provide different controls to add data into the tables

       ► One input forms can populate one table at a time

http://www.allvupastpapers.blogspot.com/

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

Which of the following is an example of volatile memory?

       ► RAM

       ► ROM

       ► Flash memory

       ► CPU

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

Which of following is NOT generally the aim of data partitioning and placement of data?

       ► Reduce Workload

       ► Balance Workload

       ► Merging different relations

       ► Speed up rate of useful works.

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

http://www.allvupastpapers.blogspot.com/

ALTER TABLE exams

            RENAME COLUMN  Q_description TO Question_Descp, Std_ID to Student_ID.

Syntax of ALTER TABLE is NOT correct.

       ► True

       ► False

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

Which of the following is Advantage of Re-Hashing technique to handle the collisions?

       ► Collisions don’t use primary table space

       ► Unlimited number of elements

       ► Fast access through use of main table space

       ► Overhead of multiple linked lists

http://www.allvupastpapers.blogspot.com/

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

Materialized views and Indexes are NOT similar by the following way(s).

       ► They consume storage space

       ► They must be refreshed when the data in their master tables changes.

       ► They can be accessed directly using a SELECT statement

       ► All of the Given

http://www.allvupastpapers.blogspot.com/

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

Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order
By
CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where
REGION = 'E' Order By CUSTOMER
The above statement:

       ► Has an error - the string should be in double quotes.

       ► Has an error - ORDER BY clause.

       ► Does not have an error.

       ► Has an error - the string in single quotes 'NORTH' and 'SOUTH'.

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

 http://www.allvupastpapers.blogspot.com/

A software package designed to store and manage databases

       ► Database

       ► DBMS

       ► Data model

       ► Data

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

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

       ► Database Designers

http://www.allvupastpapers.blogspot.com/

       ► Database Administrators

       ► End Users

       ► Application Programmers

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

A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

       ► candidate key

       ► primary key

       ► superkey

       ► secondary key

http://www.allvupastpapers.blogspot.com/

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

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

       ► strong  

       ► weak

       ► business

       ► relationship

Question No: 27      ( Marks: 2 )

What is the “data type”?

http://www.allvupastpapers.blogspot.com/

Question No: 28      ( Marks: 2 )

Which DML statement changes the values of one or more columns based on some conditions.

Question No: 29      ( Marks: 2 )

Name the two types of caching that are commonly used  in personal computers?

Question No: 30      ( Marks: 2 )

What is ‘Serial Execution’?

Question No: 31      ( Marks: 3 )

Write three benefits of using VIEWS.

Question No: 32      ( Marks: 3 )

Shortly explain BYTE data field?

http://www.allvupastpapers.blogspot.com/

Question No: 33      ( Marks: 3 )

State the main purpose of index in relation with the queries executions.

Question No: 34      ( Marks: 5 )

Dhttp://www.allvupastpapers.blogspot.com/

ifferentiate between the cluster index and non cluster index ?

Question No: 35      ( Marks: 5 )

http://www.allvupastpapers.blogspot.com/

Consider the two relations,

Department (Dept_Code, Dep_Name,Dept_Head) and

Employee(Emp_ID,Emp_Name, Designation, DoB, Dept).

Write SQL statement to drop the primary key of Department relation? The fields in

Employee should reflect the removal in Department table.

Question No: 36      ( Marks: 5 )

Briefly explain rollback and rollforward.

http://www.allvupastpapers.blogspot.com/