1) Often the front end database file is stored on a server for increased securit

ID: 3919926 • Letter: 1

Question

1) Often the front end database file is stored on a server for increased security.

True or False?

2) Which of the following is not a type of analysis result given by the Performance Analyzer tool?

Ideas

Suggestions

Recommendations

Required

3) Which is not a benefit of normalization?

It allows more than one person to use the data at the same time.

It accommodates future growth of the database.

It minimizes data redundancy.

It improves referential integrity enforcement.

4) Which of the following are typically not stored in the front-end database file?

Queries

Tables

Reports

Forms

Answers:

1.True

If Front end database file is stored in server,it will increase security.

2. d) required

Performance Analyser gives recommendation optimisations,suggestion optimisations,

idea optimisations.It wont give required optimisations as it doenst know your requirement.

3.a)It allows more than one person to use the data at the same time.

Benefits of normalisation:

1.Data redundancy,

2.Improves referential integrity enforcement

3.It improves the furture growth of db

It wont give allowing of morethan one person to use the data at the same time.

4.a)Queries are not stored in front end database.

We have to form the queries to view the data according to our need in the system.

Tables,forms,reports are components of database which are stored in it.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.