1. Question 1 of 30

   The most common type of relationship between tables in a database is:

   A Many-to-none B One-to-zero C One-to-many D Many-to-nothing
2. Question 2 of 30

   Which SQL clause is used to filter records according to a condition?

   A ORDER BY B WHERE C GROUP D FROM
3. Question 3 of 30

   Which Access object gives a user-friendly screen for entering and viewing records?

   A Table B Form C Query D Module
4. Question 4 of 30

   Which SQL command is used to retrieve data from a table?

   A INSERT B DELETE C SELECT D CREATE
5. Question 5 of 30

   The older Access database file extension (before 2007) was:

   A .accdb B .docx C .sql D .mdb
6. Question 6 of 30

   Which keyword is used in SQL to remove duplicate values from the results?

   A UNIQUE ROW B DISTINCT C REMOVE D SINGLE
7. Question 7 of 30

   Which Access view is used to define field names and data types of a table?

   A Datasheet view B Print Preview C Design view D Layout view
8. Question 8 of 30

   Which Access object stores the data in rows and columns?

   A Table B Query C Form D Report
9. Question 9 of 30

   A foreign key is used to:

   A Delete a table B Print a table C Link a table to another table D Sort a table
10. Question 10 of 30

    In Access, a Macro is used to:

    A Automate tasks B Store records C Print tables D Link tables
11. Question 11 of 30

    Microsoft Access is a:

    A Word processor B Presentation program C Relational database management system D Operating system
12. Question 12 of 30

    A primary key is a field that:

    A Stores only text B Uniquely identifies each record in a table C Can contain duplicate values D Links to a report
13. Question 13 of 30

    Which SQL command is used to modify existing records?

    A ALTER ROW B UPDATE C CHANGE D MODIFY
14. Question 14 of 30

    An organised collection of related data stored for easy access is called a:

    A Spreadsheet B Folder C Database D Network
15. Question 15 of 30

    In a database table, a column is also called a:

    A Record B Field C Report D Form
16. Question 16 of 30

    Which Access object is used to present data in a formatted, printable layout?

    A Form B Table C Macro D Report
17. Question 17 of 30

    Which SQL command is used to add a new record to a table?

    A INSERT INTO B SELECT C UPDATE D DROP
18. Question 18 of 30

    The process of organising data to reduce redundancy is called:

    A Formatting B Normalization C Encryption D Compilation
19. Question 19 of 30

    Which SQL command is used to remove records from a table?

    A DELETE B REMOVE C ERASE D CLEAR
20. Question 20 of 30

    The AutoNumber data type in Access:

    A Generates a unique number automatically for each new record B Stores a phone number C Stores only decimal values D Holds long text
21. Question 21 of 30

    Which SQL clause is used to sort the result set?

    A SORT B ARRANGE C GROUP D ORDER BY
22. Question 22 of 30

    Data redundancy means:

    A Loss of data B Encryption of data C Backup of data D Unnecessary duplication of data
23. Question 23 of 30

    SQL stands for:

    A Structured Query Language B Simple Question Language C System Query Logic D Sequential Query Language
24. Question 24 of 30

    Which Access object is used to retrieve or filter data from one or more tables?

    A Form B Query C Report D Macro
25. Question 25 of 30

    In a database table, a row is also called a:

    A Record B Field C Key D Query
26. Question 26 of 30

    Which data type is used for fields that can hold only Yes or No values?

    A Short Text B Number C Currency D Yes/No
27. Question 27 of 30

    In the query SELECT * FROM Students; the symbol * means:

    A All columns B All tables C Only the first column D Multiplication
28. Question 28 of 30

    DBMS stands for:

    A Data Base Machine Software B Digital Base Management System C Data Backup and Management Service D Database Management System
29. Question 29 of 30

    The Short Text data type in Access can store up to how many characters?

    A 50 B 1,024 C 65,535 D 255
30. Question 30 of 30

    What is the default file extension of a Microsoft Access 2007 and later database?

    A .mdb B .xlsx C .accdb D .dbf

You can practise as a guest, but sign in to save your score and track your progress.