Score for this attempt: 40 out of 40

 

Question 1

 

(CO 1) Entity attributes are represented as

 

   

fields or columns.

 

   

files.

 

   

records or rows.

 

   

tables.

 

 

Question 2

 

(CO 2) When constructing criteria for a query, you should use

 

   

no delimiters for number data types.

 

   

quotes to enclose date/time data types.

 

   

single quotes for number data types.

 

   

the pound sign to enclose text data.

 

 

Question 3

 

(CO 2) Which of the following is NOT true of a single-table query?

   

It can be created using the simple query wizard.

 

   

Queries can be created using the query design tool.

 

   

You can overwrite table data using the datasheet view of a query.

 

 

  

The top portion of the query design view displays the fields and criteria for two tables.

 

Question 4

 

(CO 2) Which of the following is not a recommended practice for designing multitable queries?

   

Include only related tables in your query.

 

   

Remove join lines in query design to speed up query processing.

 

  

Related tables should be established before you design a multitable query.

   

Print a relationship report to guide you in selecting related tables.

 

 

Question 5

 

(CO 2) The command language used with relational databases is

   

PNPI.

 

   

RDBMS.

 

 

   

SQL.

 

   

tuple.

 

 

Question 6

 

(CO 2) Which of the following statements is true about queries?

   

Forms and queries are actually the same thing.

   

Queries can only be based on one table.

   

Queries can be based on one or more related tables.

   

The instructions to create a query are not stored in the database.

 

Question 7

 

(CO 2) When building a calculated field, formulas can be created using the

   

form wizard.

   

expression builder.

   

report builder

   

table wizard.

 

Question 8

 

(CO 2) You can add records through the

 

   

datasheet view of a table.

 

   

design view of a table.

 

   

report view.

 

   

All of the above

 

 

Question 9

 

(CO 6) An expression can be built to

   

locate a record.

 

 

   

complete a calculation or function.

 

   

summarize a data source, such as a table or query.

 

   

build only calculations.

 

 

Question 10

 

(CO 6) Which of the following is NOT an action query?

   

Append

 

   

Delete

 

   

Make table

 

 

   

Summarize

 

 

SmartExpert

(118)

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

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

Attachments

file 1551550524-BIS 245 Week 4 Quiz Answers.docx preview (302 words )

S-----------cor-----------e f-----------or -----------thi-----------s a-----------tte-----------mpt-----------: -----------40Â----------- ou-----------t o-----------f 4-----------0 -----------Sub-----------mit-----------ted----------- Fe-----------b 2----------- at----------- 12-----------:06-----------pm ----------- Th-----------is -----------att-----------emp-----------t t-----------ook----------- 25----------- mi-----------nut-----------es.----------- Â-----------  -----------Que-----------sti-----------on -----------1 -----------4 -----------/ 4----------- p-----------ts ----------- (C-----------O 1-----------) E-----------nti-----------ty -----------att-----------rib-----------ute-----------s a-----------re -----------rep-----------res-----------ent-----------ed -----------as ----------- Co-----------rre-----------ct!----------- Â----------- Â ----------- f-----------iel-----------ds -----------or -----------col-----------umn-----------s. -----------  ----------- Â----------- Â ----------- f-----------ile-----------s. -----------  ----------- Â----------- Â ----------- r-----------eco-----------rds----------- or----------- ro-----------ws.----------- Â-----------  ----------- Â-----------  -----------tab-----------les-----------. -----------  -----------  ----------- Q-----------ues-----------tio-----------n 2----------- 4----------- /----------- 4Â----------- pt-----------s -----------(CO----------- 2)----------- Wh-----------en -----------con-----------str-----------uct-----------ing----------- cr-----------ite-----------ria----------- fo-----------r a----------- qu-----------ery-----------, y-----------ou -----------sho-----------uld----------- us-----------e -----------Cor-----------rec-----------t! -----------  -----------  ----------- no----------- de-----------lim-----------ite-----------rs -----------for----------- nu-----------mbe-----------r d-----------ata----------- ty-----------pes-----------. -----------  -----------  -----------  -----------

Not Rated(0)

• Buy Answer