Question

Question 1

Access to stored data enables knowledge workers to:

Group of answer choices

o copy, save, name and create files

o move, delete, retrieve, update and display files

o print, import and protect files

o all of the above

Question 2

Which of the following is an advantage of using a relational database rather than one large table?

Group of answer choices

o Data redundancy is maximised

o Only one user can access the information at a specific time

o Data is often repeated

o Data is easier to modify and update

Question 3

When making a comparison between databases and spreadsheets which of the following would NOT be considered an advantage of using a database?

Group of answer choices

o It is easier to perform complex calculations using a database.

o Unlike spreadsheets, databases organise data into records where each record has the same structure.

o Unlike spreadsheets, a relational database minimises data redundancy.

o None of the above. They are all advantages of using a database.

Question 4

The database object that is the best to use by end-users to display information is a:

Group of answer choices

o Table

o Form

o Query

o Report

Flag this question

Question 5

In a database, changing the input data properties such as data type, input masks and validation rules

Group of answer choices

o enables the enforcement of data and business rules

o is completed via the use of a form

o requires usage of the applications wizard

o all of the above

Question 6

1 pts

Pete purchases second hand cars, repairs them and sells them to customers. The diagram shown below is used to describe part of the database model used at Pete’s Car Yard. Refer to the diagram and indicate which of the following statements is TRUE

Group of answer choices

o This database model has only 3 attributes

o The relationship between cars and customer is one car to many customers

o Each car can have many repairs

o Each repair is for many cars

Question 7

Based on the diagram below, which of the following statement is TRUE?

Group of answer choices

o To create a dynamic query, the user needs to use the Sort row in the dynaset

o To execute a dynamic query, the user needs to use the Sort row in the dynaset

o To create a static query, the user needs to use the Criteria row in the dynaset

o To execute a static query, the user needs to use { } brackets

Question 8

The diagram below is used to describe a database model. Refer to the diagram and indicate which of the following statements is TRUE

Group of answer choices

o The database consists of three attributes

o The student table is a linking table

o Each student can be enrolled into many courses

o A student will be entered into the database many times

Flag this question

Question 9

1 pts

What is the cardinality between teacher and course tables?

Group of answer choices

o One to Many

o One to One

o Many to One

o Many to Many

Flag this question

Question 10

1 pts

Which of the following statements regarding a database report is FALSE?

Group of answer choices

o A report enables you to present data from tables and queries as information in a professional printed format.

o Reports can be modified using either datasheet or design view.

o Reports can include calculations, can be grouped and subtotalled.

o A report can be created using either the report wizard or in design view.

Answer 1

Question 1 : Access to stored data enables knowledge workers to:

a)copy, save, name and create files

b)move, delete, retrieve, update and display files

c)print, import and protect files

d)all of the above

Answer: option (d)

Question 2: Which of the following is an advantage of using a relational database rather than one large table?

a)Data redundancy is maximised

b)Only one user can access the information at a specific time

c)Data is often repeated

d)Data is easier to modify and update

Answer: option (d)

Question 3: When making a comparison between databases and spreadsheets which of the following would NOT be considered an advantage of using a database?

a)It is easier to perform complex calculations using a database.

b)Unlike spreadsheets, databases organise data into records where each record has the same structure.

c)Unlike spreadsheets, a relational database minimises data redundancy.

d)None of the above. They are all advantages of using a database.

Answer: option (a)

Question 4: The database object that is the best to use by end-users to display information is

a)Table

b)Form

c)Query

d)Report

Answer: option (c)

Question 5: In a database, changing the input data properties such as data type, input masks and validation rules

a) enables the enforcement of data and business rules

b) is completed via the use of a form

c) requires usage of the applications wizard

d) all of the above

Answer: option (d)