test 4 info 311

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.​

third

Which of the following is NOT a standard reason for initiating a system development project.​

to reduce staffing requirments

Which of the following is NOT one of the major activities of the support phase?​

training the users

Which of the following is not a synonym of the others?​ field, column, attribute, or tuple

tuple

In a relational database, a row can be referred to as a(n) ____.​

tuple​

The first XP development activity is creating ____.​

user stories

The _____ approach is an SDLC approach that assumes the output of each phase are frozen before moving on to the next phase.​

waterfall model

Which of the following is not a synonym of the others?​ : row, tuple, field ,or record

field

Usually the highest cost for the development and deployment of a new system is _____.​

salaries of the development team

A(n) ____ describes the structure, content, and access controls of a physical data store or database.​

schema

Which of the following is NOT a common question asked by the client before giving project approval?​

who is the project manager

Which is NOT one of the responsibilities of the database administrator?​

​Determine data confidentiality

Which is NOT an activity associated with establishing the project environment?​

​Identify staffing requirements.

In Agile modeling what are the two important reasons for building models?​

​To understand what you are building and to communicate the solution

In Scrum, the ____ maintains the product backlog list.​

​product owner

An adaptive approach to a development project is best used when _______.​

​the requirements are uncertain

A Scrum sprint is a firm ____ time box, with a specific goal or deliverable.

30 day

Which of the following statements best defines what a project is?​

A planned undertaking with a start and stop and that produces a result.

The term "_______" is used to separate out some aspect of the real world that is important to understand when we build a model.​

Abstraction

Which of the following is completed in the transition phase of the UP?​

Complete beta test

Which of the following is NOT an Agile Modeling principle?​

Maintain core models to verify past decisions

Which of the following is completed in the inception phase of the UP?​

Produce rough estimates of cost and schedule​

​In a many-to-many association, the primary key of the created table consists of which of the following?

The primary keys of the associated tables

Which of the following is a basic value of agile software development

Working software over comprehensive documentation

Which of the following is a basic value of agile software development?​

Working software over comprehensive documentation

Which of the following is NOT one of the external responsibilities of a project manager?​

access project risk

A(n) _____ approach to the SDLC is used when the exact requirements of a system or needs of users are not well understood.​

adaptive

One column of a table in a relational database is called a(n) ____.

attribute

​One column of a table in a relational database is called a(n) ____.

attribute

​The UP ____ discipline involves setting up the guidelines to manage releases and versions.

configuration and change management

Referential integrity is normally enforced by the ____.​

database management system

Which is NOT one of the primary areas for risk and feasibility analysis?​

deployment risks

What is the primary goal in Agile Modeling?​

developing software

A relational database table is in ____ normal form if it has no repeating fields or groups of fields, and hence all rows have the same columns.​

first

A(n) ____ is a field or set of fields stored in one table that also exists as a primary key in another table.​

foreign key

UP disciplines are involved in each iteration, which is typically planned to span ____.​

four weeks

___________ is where the value in one field determines the value in another field in the same record.​

functional dependancy

​What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID, Name, Major, CreditsCompleted, GPA, AcademicStanding

in first and second normal form

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)​ CourseSectionID, StudentID, Grade, StudentName

in first normal form

The term ____ refers to an approach that completes parts of a system in one or more iterations and puts them into operation for users.​

incremental development

The term "____" means that work activities are done once, then again, and yet again.​

iteration

____ are a critical element of relational database design because they are the bases for representing relationships among tables.​

keys

Which of the following is NOT a component or function of a typical database management system (DBMS)?​

low level process management

​A separate relation must be created to store the attributes of a ____ relationship among two other classes.

many to many

An approach to the SDLC where the phases overlap is often referred to as the _______ approach.​

modified waterfall

Which of the following is NOT an XP practice?​

no required coding standards

The fear of using a computer (computer phobia) is a type of _______ risk.​

organiational risk

Which of the following is also called a steering committee?​

oversight commitee

The UP life cycle model includes all of the following:​

phases, disciplines, and iterations​

The first release-level activity in an XP development approach is ____.​

planning series of iterations

A(n) ____ is a field or set of fields used to uniquely identify each row.​

primary key

The organization and direction of other people to achieve a planned result within a predetermined schedule and budget is called what?​

project management

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.​

referential integrity

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.​

rows

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key

second

The objective of the ____ is to keep the system running productively during the years following its initial installation.​

support phase

In XP development, a(n) ____ can guide members toward a vision and help them understand the system.​

system metaphor

Each class on an class diagram is represented by a(n) ____ in a relational database.​

table

Data elements in a relational database are organized into ____.​

tables

Scrum focuses primarily on the ____ level

team

A(n) "_______" is a guideline to help an analyst complete a specific task and often includes step-by-step instructions to do something such as how to create a model.​

technique

Which of the following is NOT a question that is asked in a Scrum meeting?​

Are you meeting your scheduled deliverables?

Which of the following contains both global and local schemas with distinct DBMSs?​

Heterogeneous distributed database