Data Processing Practice Test – Data Modeling (Questions with Answers and Explanations)

Which of the following must be created before anything could be done with a database? (NECO 2015)

A. Designs   B. Domains   C. Graphs   D. Tables

Column 2 and 3 in the table above cannot be used as primary key because both fields contain ______ (WASSCE 2023)

A. the same datatype
B. only strings and numbers respectively
C. duplicate values
D. different datatypes

A ______ enables you to view data from a table based on a specific criterion. (NECO 2016)

A. form     B. module     C. query     D. report

The logical and physical structural arrangement of database to accommodate information needed by the user is called ______ (NECO 2015)

A. Conceptual design.
B. Database design.
C. Entity-relationship.
D. Relationship model.

Computer stores data as _______ (WASSCE 2016)

A. folder   B. file   C. documents  D. directories

Data model is the technique for _____ a system’s data. (NECO 2014)

A. retrieving and organizing
B. organizing and documenting
C. organizing and retrieving
D. retrieving and documenting

A relational database model is designed according to set rules known as ______ (WASSCE 2018)

A. normalization      B. isolation     C. grouping     D. enumeration

Which of the following is not a database object? (NECO 2016)

A. Forms  B. Formulae  C. Queries  D. Reports

Which of the following is not associated with database? (NECO 2015)

A. Forms   B. Graphs   C. Queries    D. Reports

The database tool that allows the user to select and filter data from multiple tables is referred to as _______

A. form   B. query   C. report   D. table

Why is it a mistake to use a text data type to store money values? (NECO 2015)

A. Calculation cannot be performed
B. Decimal place cannot be displayed
C. Currency sign cannot be displayed
D. Data cannot be sorted

A _______ is a conceptual representation of the data structures that are required by a database. (NECO 2015)

A. Conceptual design
B. Database design
C. Database Management System
D. Data model

The part of the object in the figure above labelled II are called _______ (WASSCE 2019)

Which of the following models is organized into a tree-like structure and allows record in a particular order? (NECO 2014)

A. Hierarchical model
B. Network model
C. Object-relational model
D. Relational model

In Microsoft Access, how much storage capacity can date and time hold in data types? (NECO 2014)

A. 1 byte      B. 2 bytes     C. 4 bytes     D. 8 bytes

What are the columns in Microsoft Access table called? (NECO 2016)

A. Drafts   B. Fields   C. Records   D. Reports

The following are examples of data types in data modeling, except _____ (NECO 2014)

A. data/time.   B. currency.   C. held.   D. memo.

A data model can be described as a diagram or flowchart that illustrates the relationship between _____ (NECO 2016)

A. attributes   B. data  C. entities  D. entries

Arrange the following steps in the correct order for editing data type in data sheet view of a Microsoft Access database

I. Choose the type of data that will be entered into the fields
II. Click the data sheet tab on the ribbon
III. Click the field you wish to define
IV. Click the ‘down’ arrow next to the data type (WASSCE 2022)

A. I, III IV and II
B. IV, III, II and I
C. II, III, I and IV
D. III, II, IV and I

Which of the following is used to retrieve specific information from database tables? (WASSCE 2017)

A. Index   B. Query   C. Report   D. Tables

A field in a database table is also known as _______ (WASSCE 2015)

A. index   B. relation   C. attribute   D. key

Which of the following allows you to control the look and see the screen report generated in data modeling? (NECO 2014)

A. Design      B. Form       C. Table       D. Query

The arrangement that give the correct order of magnitude of the database elements is _____ (WASSCE 2019)

A. character, field, record, table, database, file
B. character, field, record, table, file, database
C. database, table, file, record, field, character
D. database, record, file, field, table, character

What is a vertical entity in a table that contains all information associated with a specific field in a table called? (NECO 2014)

A. Column      B. Field      C. Row      D. Record