Ch3 Practise Q's - Database Concepts 1

Question 1

Information is:(LO1)

A the same as data.
B data that is processed in a meaningful form.
C less useful than data.
D raw facts describing an event.

Answer 1

B data that is processed in a meaningful form.

Question 2

Conceptual database models:(LO1)

A focus on a logical view of what is represented in the database.
B focus on a physical view of what is represented in the database.
C focus on neither a logical or physical view.
D are currently being designed to replace the relational model of databases.

Answer 2

A focus on a logical view of what is represented in the database.

LOGICAL

Question 2

The particular values for a customer are stored in the ____ of a ____ within the customer ________.(LO2)

A fields, record, table
B record, fields, table
C fields, record, entity
D fields, table, database

Answer 2

A fields, record, table

Question 3

Data anomalies:(LO3)

A are inconsistencies or errors that exist in a database because of entry or changes.
B are useful in ensuring the integrity of data.
C provide a useful backup function in a database.
D none of the options are correct.

Answer 3

A are inconsistencies or errors that exist in a database because of entry or changes.

Question 4

Relational databases typically store data:(LO2)

A in a number of files.
B in a number of tables.
C in a number of fields.
D none of the options are correct.

Answer 4

B in a number of tables.

Question 5

What is a primary key?(LO2)

A An attribute that uniquely identifies a particular row.
B An attribute that uniquely identifies a particular object.
C An attribute that identifies a row.
D An attribute that identifies a tuple.

Answer 5

B An attribute that uniquely identifies a particular object.

OBJECT

Question 6

Which of the following elements form part of a database system?(LO4)

A Hardware, software, people, procedures and information
B Hardware, software, people, procedures and data
C Hardware, software, people, vapourware and data
D Hardware, software, people, procedures, vapourware and data

Answer 6

B Hardware, software, people, procedures and data

Question 6

Data redundancy occurs when:(LO3)

A we keep data that has not been used by an organisation for a number of years.
B the same data is stored in multiple locations.
C emails are stored by an organisation for longer than six months.
D when we have the wrong information stored on a customer file.

Answer 6

B the same data is stored in multiple locations.

Question 7

The DMBS contains a number of useful functions including:(LO4)

A communication interfaces
B multiuser access control
C data integrity management
D all of the options are correct.

Answer 7

D all of the options are correct.

Question 8

The database model of choice for the development of most new information systems today is:(LO4)

A relational.
B hierarchical.
C network.
D object oriented.

Answer 8

A relational.

Question 9

The entity–relationship model is:(LO5)

A currently being designed to replace existing database models.
B the least widely used database model.
C the most widely used database model.
D a model that utilises a physical representation of database structures.

Answer 9

C the most widely used database model.

Question 9

The cardinality of the relationship between a student table and a university subject table is most likely to be:(LO5)

A one-to-one.
B one-to-many.
C many-to-many.
D many-to-one.

Answer 9

C many-to-many.

Question 9

To implement a one-to-one relationship between two entities:(LO6)

A it is not necessary to have any foreign keys.
B the two entities should be combined into a single table.
C the primary key of each table should be stored in the other table as a foreign key.
D the primary key of either table can be used as a foreign key in the other table.

Answer 9

D the primary key of either table can be used as a foreign key in the other table.

Question 10

To implement a many-to-many relationship between two entities:(LO6)

A requires a different sort of database model than relational.
B requires the introduction of an additional entity.
C requires the primary key of each table to be stored in the other table as a foreign key.
D inevitably leads to data redundancy.

Answer 10

B requires the introduction of an additional entity.

Question 11

How is the design of a relational database determined in an organisation?(LO6)

A Each department is given an allocation of tables.
B Senior management decide how many tables are needed.
C IT professionals advise on the best design.
D By modelling the rules that describe how the business works.

Answer 11

D By modelling the rules that describe how the business works.

Question 12

Which of the following statements is false?(LO1)

A Good decision making and reporting are vital for organisational performance.

B Good decision making and reporting require accurate information.

C Accurate information comes from quality data capture, storage and use.

D None of the above.

Answer 12

D None of the above.

Question 13

The limitations of poor file systems come from:(LO3)

A) data management.

B) structural independence.

C) database redundancy.

D) all of the above.

Answer 13

A) data management.

Question 13

Database modelling is used for:(LO3)

A) describing and representing complex real-world data structures.

B) improving understanding of an organisation’s existing database.

C) providing a blueprint for developing new database structures.

D) all of the above.

Answer 13

D) all of the above.

Question 14

Which of the following statements is true?(LO5)

A) Implementation models show how the data are represented in the database.

B) Conceptual models focus on what is represented in the database.

C) Implementation and conceptual models can be either logical or physical.

D) All of the above.

Answer 14

D) All of the above.

Question 15

The advantage of a relational database is:(LO4)

A) structural dependence.

B) its powerful and flexible query language.

C) a data dictionary.

D) all of the above.

Answer 15

B) its powerful and flexible query language.

Question 16

Which of the following is a step to developing an ER diagram?(LO5)

A) Develop a general narrative of a business’s operations.

B) Construct a working version of the ER diagram for review by the business.

C) Make the necessary modifications for newly discovered entities or relationships.

D) All of the above.

Answer 16

D) All of the above.

Question 17

Which of the following statements is true?(LO5)

A) Normalisation should eliminate all redundancies every time.

B) Controlled redundancies should not be allowed in database design.

C) Data anomalies cause data integrity problems.

D) All of the above.

Answer 17

C) Data anomalies cause data integrity problems.