Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

Devry bis245 week 3 Quiz latest (2016)

Question

1. Question : (TCO 2) In a relational database, entities are

events.

persons.

things.

All of the above

Question 2. Question : (TCO 2) Which of the following is NOT a step in the Database Life Cycle?

Database Design

Maintenance and Redevelopment

Performance

Testing

Question 3. Question : (TCO 3) All of the following explain index usage EXCEPT

a primary field uses an index.

adding an index to a table might decrease overall database performance slightly.

an index can reduce the amount of time it takes for Access to run queries and reports.

indexes are created using the Index property type.

Question 4. Question : (TCO 2) A domain is a

group of data types that describe what kind of information that may be stored in a field.

model of the database.

set of values.

the set of primary and foreign keys in a database.

Question 5. Question : (TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

a junction (associative) table is used.

many matching records are found in each direction between tables.

may be used to connect to Oracle and other databases.

there must be at least two tables.

Question 6. Question : (TCO 2) An associative table is

used to identify primary keys between tables.

a child of two parent tables that are in a many-to-many relationship.

an integrity element within a table relationship.

a tool that allows you to locate an excel file.

Question 7. Question : (TCO 3) Which of the following does NOT describe data redundancy?

The same data exists in multiple tables.

The data is always in linked tables.

Data updating must be done in multiple table locations.

Data redundancy can result in data anomalies.

Question 8. Question : (TCO 4) To which of the following does the term cascading refer?

Data changes travel from one table to another.

Data is put in sequential order.

Queries can retrieve data at a faster rate.

Records are arranged in order.

Question 9. Question : (TCO 4) Validation text

changes the way text data is formatted.

determines the maximum length of a Text field.

requires correct text data input.

specifies the error message when a rule is violated.

Question 10. Question : (TCO 4) All of the following are examples of primary keys EXCEPT

employee ID.

social security number.

ISBN number on a textbook.

last name.

Show more
  • @
  • 177 orders completed
ANSWER

Tutor has posted answer for $10.00. See answer's preview

$10.00

*********

*

Question : (TCO ** ** * ********** database ******** **** *******

********

*******

***

**

***

******

Question

2 Question * ****

2)

***** ** *** ********* ** *** a **** in the Database **** Cycle? ******** ******* *********** *** ************** ************

********

Question *

********

* **** **

All

**

***

*********

*******

index usage EXCEPT * ******* ***** **** ** ****** ****** an ***** ** *

*****

***** ******** ******* ******** *********** *********

**

index *** reduce the ****** ** **** ** ***** *** Access **

***

queries *** ******** ******* are ******* ***** *** ***** ******** type ******** 4 ******** : **** **

*

****** ** ** ***** of **** ***** ****

********

what **** ** *********** **** may ** stored ** *

******

model ** *** ********* *** ** ******* *** *** of ******* *** ******* **** ** * *********

********

5 ******** * (TCO

**

*** ** ***

*********

******** a ************ ************ ** ****** EXCEPT * ******** *************

*****

is used many ******** records are ***** in each direction between ******* may be used to *******

**

****** *** ***** databases there ****

**

** least *** tables ******** * ******** * **** **

**

*********** ***** *** **** ** identify ******* keys ******* *******

a

child ** *** ****** ****** **** ***

**

* many-to-many relationship ** ********* ******* within * ***** *************

*

**** **** allows you ** ****** **

excel

***** ******** * ******** * (TCO ** ***** ** *** following ****

NOT

******** **** redundancy? The **** data ******

**

******** ******* *** data is always in ****** ******* ****

********

must ** done in ******** table ********** **** ********** can ****** ** data ********** ********

*

******** : **** ** ** which **

***

********* does *** **** ********* ******* Data

*******

travel **** *** table to another Data is ***

**

********** ****** Queries *** ******** **** **

a

faster ***** ******* *** ******** ** ****** Question * Question * (TCO ** Validation ***** *******

***

*** text **** ** ********** ********** the *******

length

of a **** ****** ******** *******

****

data ****** specifies the ***** ******* when a

rule

** ********* ******** ** ********

:

**** ** *** of *** following *** ********

**

primary keys ******* ******** ID ****** ********

number

ISBN ****** on * textbook **** ****

Click here to download attached files: devry bis245 week 3 Quiz latest 2016 may.docx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question