1) What datatype is best used to store a postcode? a) Short Text b) Autonumber c) Currency d) Number e) Date & Time f) Hyperlink 2) The columns in a microsoft access table are also called _______ a) Rows b) Fields c) Keys d) Records e) Columns f) Tables 3) A ____________ is used as a unique identifier within the table. A table cannot have more than one  a) Primary Key b) Unique Key c) Unique Value d) Foreign Key e) Primary Field f) Variable 4) Which data type automatically generates a consecutive number? a) Autonumber b) Number c) Memo d) Text 5) What data type should be used to store 'age'? a) Short text b) Number c) Yes/No d) Long text e) Date/Time f) Currency 6) The Yes/No data type is also know as? a) Boolean b) Switch c) Float d) Number e) Balean f) Integer 7) What is used to create a relationship between two tables? a) Relational Database b) Foreign Key c) Boolean d) Hyperlink e) Open Key f) ADSL 8) What software is used to open and modify databases? a) Web server b) Presentation software c) DBMS d) Access software e) DRM f) DVLA 9) What does SQL stand for? a) Separated Question Language b) Serial Query Language c) Structured Query Language d) Sorted Query Language e) Structured Questioning Language f) Simplex Query Language

Database Questions

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?