Advanced Database

This quiz is designed to test your knowledge of the contents of the Understanding Databases Course, part of the Office Software Suite series. These quizzes are designed to improve your database skills.

There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.

Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.

You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.

A relational database…

uses a tree structure

has tables that are linked together

has no primary keys

does not use SQL

What is a 'combo box'?

a way of entering data directly into a table

a combination of a check box and a list box

a box that combines data in a report

An input mask that uses: NaLAc stands for:

Number, lower case letter, locked, upepr case letter, lower case character

None, lower case letter, lower case character, upepr case letter, lower case character

Number, letter, locked, letter, character

Number, lower case character, letter, upper case character, criteria

To change the tab order of a form which icon/command must you select?

Tab order

Form order

Entry order

Activation order

How do you modify an existing relationship between two tables?

Press CTRL-e in the relationships window

Right click the relationship line and select edit in the relationship window

Double click the relationship line in the relationship window

When you create a junction table you must…

create two primary keys and relate them to two other tables

create on primary key that relates to two tables

create two primary keys that relates to one other table

create a primary and foreign key

What does a 'subtract join' do?

deletes records from a table

links the primary keys of two tables

returns results that are in one table, but not in the other

subtracts a numerical values in one table from another

What does the SQL statement INSERT do?

Inserts a new relationship

Inserts a field into a table

Inserts an inner join between two tables

Inserts a record into a table

To append records from one table to another using SQL you must…

Use the statement INSERT specifying a table, followed by SELECT and FROM to choose fields from another table.

Use the statement INSERT INTO, specifying a table, followed by SELECT and FROM to choose fields from another table.

Use the statement APPEND, specifying a table, followed by SELECT and FROM to choose fields from another table.

Use the statement INSERT INTO, specifying a table, followed by the other table name.

10.

Which character do we use to designate a parameter in SQL?

11.

The '?' wildcard represents…

one and only one character

any number of characters

the results of a query

numerical characters only

12.

When is an 'Alias' used in a query?

to create a new field, often the result of two fields combined arithmetically

to rename other fields that may clash between joined tables

to ensure referential integrity between tables

to hide fields that you don't want to be displayed in a query result

13.

Bound controls limit…

what can be entered in a table

what can be displayed in a report

the results of a query

what can be entered into a box in a form

14.

If we want to create a list of options that can be selected for a list box, what do we select for the 'Type of list contents' in the control properties?

Field

List options

Valuelist

Values

15.

What is an 'option group' in a form?

A list of options that is selected by clicking radio buttons

Grouped records within a form

A list of options that can be selected in a combo box

16.

What is a subform?

A list of data that can be edited within a form

A table that is displayed in a separate form

A group of options within a form

A form that automatically edits another form

17.

How do you concatenate fields in LibreOffice Base?

Create a query and use the SQL statement || ‘ ‘ ||

Create a query and use the SQL statement MERGE

Select 'merge fields' as an option in reports

Select 'concatenate fields' as an option in reports

18.

How can you make sure each grouped record appears on a new page in a report?

Select properties for the 'Detail' section of the report and change 'Force new page' option to 'Before selection'

Select properties for the 'Group' section of the report and change 'Force new page' option to 'Before selection'

Select properties for the 'Group' section of the report and change 'Force new page' option to 'After selection'

Select properties for the 'Header' section of the report and change 'Force new page' option to 'Before selection'

19.

If you link data from a spreadsheet to a database…

data changed in the spreadsheet will be updated in the database

data changed in the database will be updated in the spreadsheet

workbooks added to the spreadsheet will add tables to the database

all of the above

20.

How can use macros in a LibreOffice Base database?

To modify forms

To modify reports

To add or delete records in a table

To select objects in the main window

Be sure to click Submit Quiz to see your results!

Name

The Place For Free Online Training Courses

Improve Your Career Prospects

Comments

Advanced Database — No Comments

Leave a Reply Cancel reply