Advanced Database The Place For Free Online Training Courses 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. 1. What is an 'option group' in a form?A group of options that can be selected from a drop-down menuA list of options that is selected by clicking radio buttonsGrouped records within a formA list of options that can be selected in a combo box2. When you create a junction table you must…create two primary keys and relate them to two other tablescreate on primary key that relates to two tablescreate two primary keys that relates to one other tablecreate a primary and foreign key3. Bound controls limit…what can be entered in a tablewhat can be displayed in a reportthe results of a querywhat can be entered into a box in a form4. A relational database…uses a tree structurehas tables that are linked togetherhas no primary keysdoes not use SQL5. What does the SQL statement INSERT do?Inserts a new relationshipInserts a field into a tableInserts an inner join between two tablesInserts a record into a table6. How do you concatenate fields in LibreOffice Base?Create a query and use the SQL statement || ‘ ‘ ||Create a query and use the SQL statement MERGESelect 'merge fields' as an option in reportsSelect 'concatenate fields' as an option in reports7. 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.8. When is an 'Alias' used in a query?to create a new field, often the result of two fields combined arithmeticallyto rename other fields that may clash between joined tablesto ensure referential integrity between tablesto hide fields that you don't want to be displayed in a query result9. How do you modify an existing relationship between two tables?Select modify relationships from the main window toolbarPress CTRL-e in the relationships windowRight click the relationship line and select edit in the relationship windowDouble click the relationship line in the relationship window10. An input mask that uses: NaLAc stands for:Number, lower case letter, locked, upepr case letter, lower case characterNone, lower case letter, lower case character, upepr case letter, lower case characterNumber, letter, locked, letter, characterNumber, lower case character, letter, upper case character, criteria11. 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?FieldList optionsValuelistValues12. What does a 'subtract join' do?deletes records from a tablelinks the primary keys of two tablesreturns results that are in one table, but not in the othersubtracts a numerical values in one table from another13. Which character do we use to designate a parameter in SQL?@:v#14. What is a subform?A list of data that can be edited within a formA table that is displayed in a separate formA group of options within a formA form that automatically edits another form15. What is a 'combo box'?a way of entering data directly into a tablea data entry box in a form that allows you to type or choose data from a menua combination of a check box and a list boxa box that combines data in a report16. To change the tab order of a form which icon/command must you select?Tab orderForm orderEntry orderActivation order17. The '?' wildcard represents…one and only one characterany number of charactersthe results of a querynumerical characters only18. 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. How can use macros in a LibreOffice Base database?To modify formsTo modify reportsTo add or delete records in a tableTo select objects in the main window20. If you link data from a spreadsheet to a database…data changed in the spreadsheet will be updated in the databasedata changed in the database will be updated in the spreadsheetworkbooks added to the spreadsheet will add tables to the databaseall of the aboveBe sure to click Submit Quiz to see your results! Name Email Time is Up!