BIS 245 Week 2 Quiz Answers

Score for this attempt: 40 out of 40

 

 Question 1

4 / 4 pts

(CO 2) When building a database, you should first

create and input the design of the table and reports at the same time.

determine the input and then design the tables.

Correct!

determine the output and then design the tables.

 

   

input the data and then design the reports. 

Question 2

4 / 4 pts

(CO 2) Which of the following does NOT describe a many-to-many relationship?

Correct!

There must be at least two tables.

Many matching records exist in each direction between the tables.

A junction table is used.

You can connect to tables in other databases, such as Oracle

Question 3

4 / 4 pts

(CO 2) Primary keys can be created

   

as computer-generated fields.

 

   

from an existing single field.

 

   

from several existing fields.

 

Correct!

   

All of the above

 

 

Question 4

4 / 4 pts

(CO 3) An associative table is which of the following?

Correct!

   

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

 

   

A child of a parent table that is in a one-to-many relationship

 

   

A child of a parent table that is in a one-to-one relationship

 

   

None of the above

 

 

Question 5

4 / 4 pts

(CO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?

   

11/12/2011

 

   

12/11/2011

 

   

#12/11/2011#

 

Correct!

   

Between #10/01/2011# And #11/12/2011#

 

 

Question 6

4 / 4 pts

(CO 3) Which data type will increment automatically each time a new record is entered into a table?

Correct!

   

AutoNumber

 

   

Currency

 

   

Date/Time

 

   

Number

 

 

Question 7

4 / 4 pts

(CO 3) All of the following are true about the indexed property except

   

an example of a setting is yes (duplicates OK).

 

Correct!

   

indexed records are scanned sequentially.

 

   

indexing a table speeds the retrieval time.

 

   

primary keys must be indexed.

 

 

Question 8

4 / 4 pts

(CO 4) Which of the following is NOT true of a hire date field?

   

A hire date is considered a constant.

 

   

A hire date would be defined as a date/time field.

 

   

Date arithmetic can be applied to a hire date field.

 

Correct!

  

The years of service field, which shows how long an employee has been with the company.

 

Question 9

4 / 4 pts

(CO 4) To ensure that a value of 15 or greater was entered into a field, you would use a

   

field size.

 

   

field type.

 

   

Sarbanes-Oxley Act.

 

Correct!

   

validation rule.

 

 

Question 10

4 / 4 pts

(CO 2) What is the special character called to represent one or more characters in the criteria area of a query?

   

Delimiter

 

   

Operand

 

Correct!

   

Wildcard

 

   

Operator

 

 

SmartExpert

(118)

Status NEW Posted 02 Mar 2019 05:03 PM My Price 5.00

BIS----------- 24-----------5 W-----------eek----------- 2 -----------Qui-----------z A-----------nsw-----------ers-----------

Attachments

file 1551546668-BIS 245 Week 2 Quiz Answers.docx preview (355 words )

B-----------IS -----------245----------- We-----------ek -----------2 Q-----------uiz----------- An-----------swe-----------rs ----------- Sc-----------ore----------- fo-----------r t-----------his----------- at-----------tem-----------pt:----------- 4-----------0 -----------out----------- of----------- 40----------- S-----------ubm-----------itt-----------ed -----------Jan----------- 20----------- at----------- 11-----------:55-----------am ----------- Th-----------is -----------att-----------emp-----------t t-----------ook----------- 11----------- mi-----------nut-----------es.----------- Â-----------  -----------Que-----------sti-----------on -----------1 -----------4 -----------/ 4----------- p-----------ts ----------- (C-----------O 2-----------) W-----------hen----------- bu-----------ild-----------ing----------- a -----------dat-----------aba-----------se,----------- yo-----------u s-----------hou-----------ld -----------fir-----------st -----------  ----------- c-----------rea-----------te -----------and----------- in-----------put----------- th-----------e d-----------esi-----------gn -----------of -----------the----------- ta-----------ble----------- an-----------d r-----------epo-----------rts----------- at----------- th-----------e s-----------ame----------- ti-----------me.----------- Â-----------  ----------- Â-----------  -----------det-----------erm-----------ine----------- th-----------e i-----------npu-----------t a-----------nd -----------the-----------n d-----------esi-----------gn -----------the----------- ta-----------ble-----------s. -----------  ----------- C-----------orr-----------ect-----------! ----------- Â-----------  -----------det-----------erm-----------ine----------- th-----------e o-----------utp-----------ut -----------and----------- th-----------en -----------des-----------ign----------- th-----------e t-----------abl-----------es.----------- Â-----------  ----------- Â-----------  -----------inp-----------ut -----------the-----------

Not Rated(0)

• Buy Answer