Cs312 objective part 2 midterm

Wrong requirements issues mean ------------.

Select the correct option

Reload Math Equations
Misinterpreted of requirements among different people

Software requirements

Unable to explain the fact properly

Change occur in data over a period of time

Change requirements issues mean ------------.

Select the correct option

Reload Math Equations
Any transition occur in data over a period of time

Unable to explain the fact properly

Misinterpreted during requirement gathering phase

 Software requirements

In requirement gathering phase ,if requirement gathering person is unable to explain the fact

properly.This type of issue is called ------------------.

Select the correct option

Reload Math Equations
Wrong Requirements

Missing Requirements

Changing Requirements

Outstanding Requirements

The attribute of software requirement will be considered as ------- if there is some

process through which a person or a machine can check that the software product

meets the requirement.

Select the correct option

Reload Math Equations
 Completeness

Traceability

Consistent

Verifiable

Loading time of a software should be two second, this requirement is considered to be —----------- from all
stakeholders.

Select the correct option

Reload Math Equations
Traceability

Completeness

Verifiable

Consistent

The ------------ should be communicated in such a way so the testing team should

be able to verify it.

Select the correct option
Reload Math Equations
Service

Product

Scenario

Requirement

A --------- requirements specification must precisely define all the real world

situations that will be encountered and the system’s responses to them.

Select the correct option

Reload Math Equations
Verifiable

Complete

Consistent

Traceability

In the completeness attribute of the software requirement , Which of the following should not be included?
Select the correct option
Reload Math Equations
Specific

Verifiable

With in scope

Non-verifiable

In software requirement gathering process , there is no room for --------- work in

documenting the requirements.

Select the correct option

Reload Math Equations
Buzz

Hard

Phrases
 Guess

The software requirement is said to be ---------- if it is not in conflict with any other

existing requirements.

Select the correct option

Reload Math Equations
Traceability

Verifiable

Completeness

Consistent

------------ may arise due to variation in language patterns, use of different vocabulary or multiple descriptions of a
single requirement.

Select the correct option

Reload Math Equations
Vague

Conflict
 Transform

Consent

Consider a scenario : the requirement says perform function Z after both X and Y

has occurred, or perform function Z after X or Y has occurred. The requirement

stated in such a way may leads to ----------.

Select the correct option

Reload Math Equations
Consistency

Failure

Success

Traceability

------------- of the origin can help to understand what modifications have been

made to the requirement to bring the requirement to its current state.

Select the correct option

Reload Math Equations
 Completeness

Verifiable

Consistent

Traceability

Traceability of ------------ is used to aid the modification of future documents by stating where a requirement has
been referenced.

Select the correct option

Reload Math Equations
Design

Falsity

Fabrication

Reference

A requirement is ---------- if both the origins and the references of the requirement

is available.
Select the correct option
Reload Math Equations
Lack consistency

Incomplete

Traceable

Non-Verifiable

Requirements engineering emphasizes the use of systematic and repeatable

techniques that ensure the completeness, ------------, and relevance of the system

requirements .

Select the correct option

Reload Math Equations
Infinite needs

Consistency

Redundancy
 Out of scope

------------- is a set of activities concerned with identifying and communicating the

purpose of a software-intensive system, and the contexts in which it will be used.

Select the correct option

Reload Math Equations
Research and development

System Analysis

Project management

Requirement engineering

Requirement development is further divided into the following -------------.

Select the correct option

Reload Math Equations
Verifiable ,Completeness,specification and verification

Elicitation, analysis, specification and verification

 Verifiable ,Completeness ,Consistent ,Traceability

Elicitation, analysis,Completeness ,Consistent

Requirement management discipline takes into account different strategies to keep

the project with in -------------.

Select the correct option

Reload Math Equations
Deviation

Tangible

Scope

Intangible

------------- is the process of scheduling, coordinating, and documenting the

requirements engineering activities.

Select the correct option

Reload Math Equations
 System Analysis

Data Managements

Requirement Management

Research and Development

Which of the following disciplines will monitor and control the scope of the project?

Select the correct option

Reload Math Equations
System Analysis

Requirement Management

Research and Development

Data Managements

The most fundamental aspect of requirements management is the need to -------------

effectively.
Select the correct option
Reload Math Equations
Analysis

Communication

Validate

Commitment

------------------ is the process of identifying and then monitoring the needs of all stakeholders involved in a project,
and making sure that these goals/needs are met.

Select the correct option

Reload Math Equations
Data Managements

System Analysis

Research and Development

Requirement Management

The ---------- defines the agreed goals, requirements, deliverable of a project

 among stakeholders.

Select the correct option

Reload Math Equations
External Scope

Broader Scope

Internal Scope

Baseline scope

The artifact of the requirement development(RD) process is the -----------

requirements.

Select the correct option

Reload Math Equations
Hard

Baseline

Soft
 Broadline

------------ is a part in which the requirements are gathered and then turned into

specification of what the system must do, or the scope or features of the software

system.

Select the correct option

Reload Math Equations
Requirement Development

System Analysis

Data Managements

Research and Development

Which of the following is Not an activity of requirement development?

Select the correct option

Reload Math Equations
Elicitation
 Specification

Analysis

Complexity

Requirement ------------- is all about gathering the system’s requirement.

Select the correct option

Reload Math Equations
Elicitation

Analysis

Consistency

Verification

Interview, questionnaire, observation are the techniques of -------------------.

Select the correct option

Reload Math Equations
 Requirement Elicitation

Deployment Techniques

System Analysis

Data Managements

Which of the following techniques are frequently used for collecting/gathering the

requirements of a system from user,customer and other stakeholders?

Select the correct option

Reload Math Equations
Feedback, FAQ’s

Interview,Questionnaire

Research articles, use cases

Taking notes,Written test

The ----------- of the scope is to be defined along with the baseline to deliver.
Select the correct option
Reload Math Equations
Priority

Efficiency

Requirement

Time

After prioritizing the features, development team is capable to schedule project activities to deliver with in
------------ .

Select the correct option

Reload Math Equations
Boundary

Target

Budget

Time

In order to manage the scope of a project in a proper manner, which of the following
 must be met?

Select the correct option

Reload Math Equations
Borderline

Barrier

Baseline

Boundary

--------- -- at the time of requirement elicitation stage may leads to project failure.

Select the correct option

Reload Math Equations
Lack of resources

Lack of stakeholder

Lack of user involvement

 Lack of interest

User involvement is a key to get good ----------------- .

Select the correct option

Reload Math Equations
User feedback

Project management

Validation

Requirement documentation

To get good after prioritizing the features, development team is capable to schedule project activities to deliver
within ------------ .

Select the correct option

Reload Math Equations
Target

Budget

Boundary
 Time

Consider a program is developed for a Web server with the failure intensity

objective of 2 failure/200,000 transactions. During testing, the program runs for 48

hours, handling 20,000 transactions per hour on average with no failures occurring.

How you can categorize the above given scenario?

Select the correct option

Reload Math Equations
User Friendliness

Reliability

Robustness

Consistency

------------ is the ability of an algorithm to continue operating despite abnormalities in

input, calculations.

Select the correct option

Reload Math Equations
 Reliability

User Friendliness

Robustness

Consistency

Which of the following requirements should be considered in Quality metrics?

Select the correct option

Reload Math Equations
Non-functional requirements

Functional requirements

Hardware requirements

User requirement

Requirement analysis identifies the conflict with the ------------- as the prototype is

made and the further development needs are clear at this stage.
Select the correct option
Reload Math Equations
Top management

Border line

Lower management

Base line

--------------- breaks down functional and non-functional requirements to a basic design view to provide a clear
system development process framework.

Select the correct option

Reload Math Equations
Requirement analysis

Hardware requirements

User requirement

Conflict analysis

-------------- is a process of checking that the software meets the specification.

Select the correct option
Reload Math Equations
Testing

Verification

Evaluation

Validation

------------- is used in Software product management for determining which candidate

requirements of a software product should be included in a certain release.

Select the correct option

Reload Math Equations
Requirement prioritization

Requirements Verification

Requirement analysis

Requirement Specification
 ----------- is defined as the wrong definition of the client’s requirements.

Select the correct option

Reload Math Equations
Error

Bugs

Interrupt

Defect

------------------ document enlists enough and necessary requirements that are

required for the project development.

Select the correct option

Reload Math Equations
Design Document

Software Document

Entity Relationship diagram

 Software Requirement Specification

----------- can be defined as the noncompliance with the agreed behavior, or software

is not doing what it is supposed to do.

Select the correct option

Reload Math Equations
Error

Bugs

Interrupt

Defect

Later we find out the problem ,the more --------- we bear.

Select the correct option

Reload Math Equations
Cost

Time
 Bugs

Hardship

Each and every datum (atomic value) is guaranteed to be logically accessible by

resorting to a combination of table name, primary key value, and column name. It is

------------.

Select the correct option

Reload Math Equations
Codd Rule No. 04: Active Online Catalogue

Codd Rule No. 02: Guaranteed Access Rule

Codd Rule No. 03: Systematic Handling of Null

Codd Rule No. 01: The Information Rule

All information in the relational database is represented in exactly one and only one

way by values in tables.This is ----------.

Select the correct option

Reload Math Equations
 Codd Rule No. 04: Active Online Catalogue

Codd Rule No. 02: Guaranteed Access Rule

Codd Rule No. 01: The Information Rule

Codd Rule No. 03: Systematic Handling of Null

---------------is based on the relational model of data in which all the data is presented

in the forms of tuple.

Select the correct option

Reload Math Equations
Key-value database

Graph databases

Relational database

Wide-column databases

----------- cannot be considered as zero or empty.

Select the correct option
Reload Math Equations
Binary

Null

Numaric

String

NULL values are supported in the fully relational RDBMS for representing ----------

information in a systematic way,independent of data type.

Select the correct option

Reload Math Equations
Available

Misinterpreted

Accurate
 Missing

Data Dictionary and database description must be available in database.It is

------------.

Select the correct option

Reload Math Equations
Codd Rule No. 04: Active Online Catalogue

Codd Rule No. 03: Systematic Handling of Null

Codd Rule No. 02: Guaranteed Access Rule

Codd Rule No. 01: The Information Rule

-------------------- are special character or sequence of characters signifying the end

of a line of text and the start of a new line.

Select the correct option

Reload Math Equations
Feed-forward and feed-back word
 Line-feed and carriage-return

Line-forward and border line

Last-in and first-out

A database can only be accessed using a language having ----------- that supports

data definition, data manipulation, and transaction management operations.

Select the correct option

Reload Math Equations
Compound syntax

Language syntax

Linear syntax

Complex syntax

A --------------- can be defined as a language which is parsed from left to right which implies the ability to write
code without the use of line-feed or carriage-return characters.

Select the correct option

Reload Math Equations
 Compound syntax

Complex syntax

Linear syntax

Language syntax

Which of the following rule deals with views, which are virtual tables used to give

various users of a database different views of its structure?

Select the correct option

Reload Math Equations
Active Online Catalogue Rule

View Updation Rule

Systematic Handling of Null Rule

Information Rule

User can be given access to selected______ as per rights and privileges.

Select the correct option
Reload Math Equations
Columns

Database

Rows

Tables

Views are created on the basis of________.

Select the correct option

Reload Math Equations
Rows

Columns

Database

Tables
 Which of the following operation is not supported by Relational Level Operation

rule?

Select the correct option

Reload Math Equations
Intersection

Minus

Union

Power

In case of _____________Rule, insert, update, and delete operations should be

supported for any retrievable set rather than just for a single row in a single table.

Select the correct option

Reload Math Equations
Relational Level Operation

Active Online Catalogue Rule

 Information Rule

View Updation Rule

Insert, update, and delete operations ______ supported for any retrievable set rather

than just for a single row in a single table.

Select the correct option

Reload Math Equations
Should be

Partially

Should not be

May be

Which of the following statement is correct according to “Physical Data

Independence” rule?

Select the correct option

Reload Math Equations
 Users shouldn’t be concerned about how the data is stored or how it’s accessed.

Users should be concerned about how the data is stored or how it’s accessed.

System should be concerned about how the data is stored or how it’s accessed.

System shouldn’t be concerned about how the data is stored or how it’s accessed.

Which of the following statement is correct according to “Physical Data

Independence” rule?

Select the correct option

Reload Math Equations
Changes to the physical level must require a change to an application based on the
structure.

User views data should not change when the logical structure (tables structure) of the
database changes.

Changes to the physical level must not require a change to an application based on the
structure.

User views data should change when the logical structure (tables structure) of the
database changes.

Which of the following statement is representing “Physical Data Independence”?

Select the correct option
Reload Math Equations
“All views that are theoretically updateable are also updateable by the system.”

“Insert, update, and delete operations should be supported for any retrievable set rather
than just for a single row in a single table.”

“Changes to the logical level (tables, columns, rows, and so on) must not require a
change to an application based on the structure.”

“The way the data is stored physically must be independent of the logical manner in
which it’s accessed.”

Which of the following statement is correct according to “Logical Data

Independence” rule?

Select the correct option

Reload Math Equations
User views data should change when the logical structure (tables structure) of the
database changes.

Changes to the physical level must not require a change to an application based on the
structure.

User views data should not change when the logical structure (tables structure) of the
database changes.
 Changes to the physical level must require a change to an application based on the
structure.

Which of the following statement is representing “Logical Data Independence”?

Select the correct option

Reload Math Equations
“All views that are theoretically updateable are also updateable by the system.”

“The way the data is stored physically must be independent of the logical manner in
which it’s accessed.”

“Insert, update, and delete operations should be supported for any retrievable set rather
than just for a single row in a single table.”

“Changes to the logical level (tables, columns, rows, and so on) must not require a
change to an application based on the structure.”

The type of data independence in which the schema can be altered on conceptual

level without altering external level is ______.

Select the correct option

Reload Math Equations
Logical data independence.

Conceptual level independence.

 Physical data independence.

External level independence.

Integrity rules should be stored in the data _____

Select the correct option

Reload Math Equations
Rows

Dictionary

Context

Table

Consider the following statement and identify the relational database rule which is

represented by this statement.

“All its integrity constraints can be independently modified without the need of any

change in the application.”

Select the correct option

 Reload Math Equations
Logical Data Independence

Integrity Independence

Physical Data Independence

Distribution Independence

Which of the following constraints should be stored in the data dictionary?

Select the correct option

Reload Math Equations
Primary key constraints

Union constraints

Check constraints

Foreign key constraints

The database _____ must enable application programs and terminal activities to

remain logically unimpaired whether and whenever data are physically centralized
 or distributed.”

Select the correct option

Reload Math Equations
Management system

Language

Logical design

Physical design

Which of the following rule says that the database language must be able to

manipulate data located on other computer systems?

Select the correct option

Reload Math Equations
Distribution Independence

Logical Data Independence

Integrity Independence
 Physical Data Independence

In case of _____________Rule, the database language must enable application

programs and terminal activities to remain logically unimpaired whether and

whenever data are physically centralized or distributed.

Select the correct option

Reload Math Equations
Physical Data Independence

Integrity Independence

Distribution Independence

Logical Data Independence

According to ________, there should be no backdoor to disable the integrity and

constraints defined.

Select the correct option

Reload Math Equations
Integrity Independence
 Non-Subversion Rule

Distribution Independence

Logical Data Independence

In case of _____________, a relational system has or supports a low-level language,

that low- level language cannot be used to bypass the integrity rules or constraints

expressed in the higher-level relational language.

Select the correct option

Reload Math Equations
Logical Data Independence

Non-Subversion Rule

Distribution Independence

Integrity Independence

Which of the following has a violation of this Non-Subversion Rule.

Select the correct option
Reload Math Equations
SQL

MariaDB

Oracle

MongoDB

The _______ can also be referred as a blueprint of how the database is constructed or

the structure of the database.

Select the correct option

Reload Math Equations
Database entity

Database Schema

Database relation

Database instance

Which of the following is a logical way of grouping database objects like tables, indexes and views?
Select the correct option
Reload Math Equations
Database relation

Database entity

Database instance

Database Schema

Which of the following has privileges to has authorized access to Objects and users

can be assigned a username and password to have authorized access?

Select the correct option

Reload Math Equations
Database instance

Database relation

Database entity
 Database Schema

The logical design of the database, is also known as

Select the correct option

Reload Math Equations
Database Schema

Database instance

Database entity

Database relation

Which of the following is better explained as the group of database objects like

tables, indexes, triggers and constraints that are related to each other?

Select the correct option

Reload Math Equations
Database relation

Database instance
 Database Schema

Database entity

Overall design of the database is known as _________.

Select the correct option

Reload Math Equations
Database entity

Database instance

Database Schema

Database relation

A Row in a “Student” table is also known as____.

Select the correct option

Reload Math Equations
Structure
 File

Field

Record

Each record is assigned a _____ number to manage the record reference which is

known as a key.

Select the correct option

Reload Math Equations
Common

Identical

Unique

Duplicate

This key equips each database record with a unique ______ which can be easily

tracked.
Select the correct option
Reload Math Equations
Documentation

Identification

Database

Table

What is the full form of SQL?

Select the correct option

Reload Math Equations
Structured Query Language

Structured Query List

Simple Query Language

Sample Query Language

Which of the following is not a subset of SQL.

Select the correct option
Reload Math Equations
Data Manipulation Language

Data Context Language

Data Definition Language

Data Retrieval Language

There are ____ subsets of SQL.

Select the correct option

Reload Math Equations
2

1
 Which of the following DDL (Data Definition Language) statement can be used to

modify an existing database object?

Select the correct option

Reload Math Equations
ALTER

CREATE

UPDATE

DROP

Which of the following language is a standard for commands that define the

different structures in a database and is responsible for creating database objects.

Select the correct option

Reload Math Equations
Data Control Language

Data Definition Language

 Data Retrieval Language

Data Manipulation Language

Which of the following is not a DDL (Data Definition Language) statement?

Select the correct option

Reload Math Equations
CREATE

DROP

INSERT

ALTER

Which of the following DML (Data Manipulation Language) command can be used to

change existing values in a table?

Select the correct option

Reload Math Equations
DELETE
 UPDATE

INSERT

ALTER

Which of the following language is used for selecting, inserting, deleting and

updating data in a database.

Select the correct option

Reload Math Equations
Data Definition Language

Data Manipulation Language

Data Control Language

Data Retrieval Language

Which of the following is not a DML (Data Manipulation Language) command?

Select the correct option

Reload Math Equations
 DELETE

INSERT

UPDATE

ALTER

Which of the following is a DCL (Data Control Language) command?

Select the correct option

Reload Math Equations
INSERT

UPDATE

GRANT

ALTER

Which of the following DCL (Data Control Language) command can be used to withdraw the access rights?

Select the correct option

Reload Math Equations
 COMMIT

SAVEPOINT

REVOKE

ROLLBACK

Which of the following language is used to create privileges to allow users access

and manipulation of the database?

Select the correct option

Reload Math Equations
Data Manipulation Language

Data Retrieval Language

Data Control Language

Data Definition Language

Which of the following is a DRL (Data Retrieval language) command?

Select the correct option
Reload Math Equations
SELECT

UPDATE

GRANT

INSERT

Which of the following command allows us to specify the type of information which

we want to retrieve?

Select the correct option

Reload Math Equations
SAVEPOINT

REVOKE

SELECT
 COMMIT

Which of the following language is used to retrieve data from a database object in

the desired format?

Select the correct option

Reload Math Equations
Data Manipulation Language

Data Retrieval Language

Data Definition Language

Data Control Language

Which of the following diagram only visualize the business data instead of defining

the business process?

Select the correct option

Reload Math Equations
Entity diagram
 Sequence diagram

Database diagram

Entity relationship diagram

Which of the following is a graphical representation of the relationships between data in a database?

Select the correct option

Reload Math Equations
Database diagram

Sequence diagram

Entity relationship diagram

Entity diagram

An Entity relationship diagram can express the overall __________of a database

graphically.

Select the correct option

Reload Math Equations
 Architectural structure

Logical Structure

Model Structure

View Structure

Which of the following diagram in database design, which gives a higher level

description of the system and actually visualizes the system requirements?

Select the correct option

Reload Math Equations
Sequence diagram

Entity relationship diagram

Database diagram

Entity diagram

In Entity relationship diagram, data is represented as ________ that are linked with
 each other by relationships that express the dependencies and requirements

between them.

Select the correct option

Reload Math Equations
Attributes

Relationships

Cardinalities

Entity

There are _____ main components of ERD (Entity relationship diagram).

Select the correct option

Reload Math Equations
4

3
 1

The word entity is rooted from the Latin word “en” which means_______.

Select the correct option

Reload Math Equations
Important

Useless

Nothingness

Being

All these entities have some ______ that give them their identity.

Select the correct option

Reload Math Equations
Entities

Attributes

Relationships
 Cardinalities

An entity set is a collection of similar types of ______.

Select the correct option

Reload Math Equations
Attributes

Relationships

Cardinalities

Entities

Which of the following is the smallest storage unit of any database?

Select the correct option

Reload Math Equations
Entities

Attributes
 Cardinalities

Relationships

Entities are represented by means of their properties, called______.

Select the correct option

Reload Math Equations
Entity sets

Cardinalities

Relationships

Attributes

A(n) ________ describes a property or characteristics of an entity.

Select the correct option

Reload Math Equations
Relationships

Cardinalities
 Attributes

Entities

Let suppose that you are collecting and storing information about a music collection

in the form of an album. In this scenario an album would be considered as a(n)

_____.

Select the correct option

Reload Math Equations
Entity

Attribute

Relation

Instance

In ERD, _______ represents how data is connected among entities in a given System.

Select the correct option

Reload Math Equations
Relationships
 Entity sets

Instance

Attributes

In ERD, interaction among entities is captured by using _______.

Select the correct option

Reload Math Equations
Attributes

Cardinalities

Entities

Relationships