Quizes

Question 1

Which of the following is important to do after you have identified all the requirements and business rules?

Answer 1

Review them with the relevant stakeholders to make sure they are complete and accurate

Question 2

When a developer tests a database, he or she should:

Answer 2

Test each database requirement to make sure the database meets it

Question 3

A requirement that refers to the attributes that must be stored in the database to fulfill business needs is called a:

Answer 3

Data requirement

Question 4

Which of the following represents an advantage of a surrogate key?

Answer 4

A surrogate key is always guaranteed to be unique
Surrogate keys are arbitrary and are not affected by changes in business rules

Question 5

Which of the following best defines the term requirement?

Answer 5

Something the database must do to meet its business purpose

Question 6

Which of the following best defines a surrogate key?

Answer 6

It is an arbitrary, random key with no business meaning

Question 7

A requirement that refers to data that must be present in the database to generate reports is called a:

Answer 7

Report requirement

Question 8

Which of the following best describes an attribute or combination of attributes that could be used as the primary key for an entity?

Answer 8

Candidate key

Question 9

A program that requests services from another program is called:

Answer 9

A client

Question 10

Which of the following is a permission that grants the user the right to enter new data?

Answer 10

Insert

Question 11

Which best describes a trigger?

Answer 11

A program usually written in SQL that is triggered by a database event such as an insert or delete

Question 12

Which of the following best defines the term problem domain?

Answer 12

The business problem the database is meant to solve

Question 13

Which of the following best describes an artificially generated attribute used as a key?

Answer 13

Surrogate key

Question 14

A small community organization takes in stray animals. Many of them are given out to foster families who take care of them until they are adopted by someone. They need a database that will track the animals, which foster families have the animals, and the adoption history of each animal. Which of the following best describes the “big themes” or the topics of the database?

Answer 14

Animals, Foster families, Adoptions

Question 15

The process of organizing data into tables and then defining the relationships among them is known as:

Answer 15

Relational design

Question 16

Which best defines the function of SQL in a database?

Answer 16

It is the language relational databases use to create database objects and to manipulate and retrieve data

Question 17

A nonprofit wants to talk to you about a database to track donors and potential donors. Which of the following best describes how you should prepare for the initial interview?

Answer 17

Don’t over anticipate. Remain open minded. Try to develop a few questions to get the client started describing the basic purpose and needs of the database.

Question 18

Which best defines the function of a primary key?

Answer 18

It uniquely identifies each record

Question 19

Which of the following best defines a statement of work?

Answer 19

A preliminary document that describes the work that needs to be done on a project

Question 20

Who first defined the principles of a relational database?

Answer 20

Edgar Codd

Question 21

A good definition for a database is:

Answer 21

A collection of related data

Question 22

Which of the following is the best way to begin identifying the topics of a database?

Answer 22

Look at the project notes and identify all the nouns, then group them into themes

Question 23

Which of the following is one of Codd’s principles?

Answer 23

Logical design must be kept separate from physical design

Question 24

Which best describes what the history section of a statement of work does?

Answer 24

It provides a background for the issues and problems that led to the decision to develop a new database

Question 25

Which of the following is the best definition for a database attribute?

Answer 25

Something that describes some part of an entity

Question 26

Which of the following are common functions of a relational database management system?

Answer 26

Providing for backup and security Providing for the creation of databases and database objects Providing for data retrieval and manipulation

Question 27

When determining who to interview, you should:

Answer 27

Interview everyone who has a stake in the database

Question 28

Which of the following should you use as part of your documentation of the data gathering process?

Answer 28

Copies of all forms and reports reviewed Notes from interviews Summaries of questionnaires

Question 29

Which of the following represents best practices for interviews?

Answer 29

Prepare questions beforehand Have someone other than the interviewer take notes Keep participants on task

Question 30

Interviews are good for asking what kind of questions?

Answer 30

Open ended questions

Question 31

Observing people at work to see how they interact with the data is called:

Answer 31

Work shadowing

Question 32

Which of the following is a type of database optimized for processing transactions in real time?

Answer 32

Transaction processing system

Question 33

Which best describes what is meant by the term stakeholder?

Answer 33

Anyone who is affected by the database

Question 34

Something a database must do to fulfill its purpose is called a:

Answer 34

Requirement

Question 35

Which of the following is a collection of various data sources including documents used for data mining?

Answer 35

Data warehouse

Question 36

A document that summarizes and displays data is called a:

Answer 36

Report

Question 37

Which best describes the function of a form?

Answer 37

A form is used to gather input from users