Question 11 Pts Name Given Column Data Stored Database Record See Diagram Table Record Fie Q31607820

Question 11 pts

What is the name given to each column of data stored in adatabase record? (see diagram below)

Customer Table.jpg

Table
Record
Field
Entity

Flag this Question

Question 21 pts

To reduce input error in a database it is possible to have thecomputer check that the data that is entered in each field musthave certain properties.
For example, if the phone number of a customer always has the samelayout (e.g. (03) 9888 1234), it is possible to have the computerautomatically prompt the user to use this layout (e.g. (__) ________ ) .
This is termed:

a Default Value
a Format
an Input Mask
a Field Size

Flag this Question

Question 31 pts

The illustration below shows a database table. With reference tothis table which of the following statements is true?

designview customers.png

The table has twelve attributes
The table is shown in datasheet view
The name of the table is CID
The CPhone field has been incorrectlydesignated as a text file.

Flag this Question

Question 41 pts

Based on the query below which of the following statements isFALSE?

eg dynamic query.jpg

This query would require the user to input data before thequery could run.
The dynaset of this query would return all the venues of aparticular customer.
This query is an example of a dynamic query.
All the selected fields will be shown in the resultingdynaset.
None of these statements. They are all true.

Flag this Question

Question 51 pts

The illustration below shows the tables and relationships for adatabase showing the clients, the students that clients send tocourses and the courses which are available to attend. In terms ofdatabase design, this illustration is an example of:

ER DIAGRAM DATABASE.png

an IPO chart
an ER diagram
a flowchart
a database model

Flag this Question

Question 61 pts

Traditional file management systems tended to store data in onetable rather than several related tables. The problem a relationaldatabase is designed to overcome is:

table structures that are too complex
too many fields in the table
problems in relation to data integrity and redundancy
All of the suggestions are correct

Flag this Question

Question 71 pts

When designing the field data for each table in a database whichof the following is NOT a design guideline?

Store data in its smallest component parts.
Store calculations in tables.
Identify a primary key field.
Do not include fields that have already been stored in anothertable.

Flag this Question

Question 81 pts

Colin, the owner of Hammer Wines, is concerned that hoteldrinkers are unaware of his beer brands which are sold on tap atvarious hotels. As a result the marketing department has developeda number of different advertisements which will appear in both ‘TheAge’ and ‘The Sun’ newspapers. If Colin was to extend his databaseto include tables about advertisements and the newspapers in whichthey appear, the cardinality of the relationship would need tobe:

one-to-one
one-to-many
many-to-one
many-to-many

Flag this Question

Question 91 pts

Table design is an important aspect of setting up a database.Which of the following is an example of a fieldproperty that can be altered in ‘design view’?

Lookup wizard
Input mask
Autonumber
Field name

Flag this Question

Question 101 pts

Fred Jones owns an electrical appliance store. He sells a widerange of electric appliance models (e.g. LG Model X Refrigerator,Pfaff Model Y Oven, …) to customers which he buys directly from asmall number of manufacturers (e.g. LG, Pfaff, …). He has createda relational database showing customers, appliances andmanufacturers. In this database, the relationship betweenmanufacturers and appliances would need to be:

one-to-one
one-to-many
many-to-one
many-to-many

Flag this Question

Question 111 pts

In a database, table the primary key must:

not be a ‘required’ value
be unique
contain both numbers and letters
be an autonumber

Flag this Question

Question 121 pts

Which of the following fields in a table containing records ofstudent details could be used as a primary key for that table?

Class
Family name
Student number
Course ID

Flag this Question

Question 131 pts

Which of the following statements regarding a database query isTRUE?

A query is an example of a database object used to inputdata.
A query is used to view subsets of attributes and/or subsets ofrecords.
A query can be edited in data sheet view.
Queries enable you to present data from your tables asinformation in a professional, printed format.

Flag this Question

Question 141 pts

Which of the following statements regarding a dynamic query isTRUE?

A dynamic query returns data from one table at a time.
A dynamic query requires the user to input data before thequery can run.
A dynamic query is used to select fields from a form(s).
A dynamic query can be created using layout view.

Flag this Question

Question 151 pts

Which of the following statements regarding referentialintegrity is true?

Every primary key value must match a primary key value in anassociated table.
Every primary key value must match a foreign key value in anassociated table.
Every foreign key value must match a primary key value in anassociated table.
Every foreign key value must match a foreign key value in anassociated table.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *