0417 Data Manipulation Chapter 18 Quiz

What are the main objects of a database?

• Tables, queries, forms, reports

• Columns, indexes, Relationship, Fields

• Primary keys, foreign keys, stored, records,

• Data, information, keys, records

A single piece of data item in a databses

• record

• Field.

• Row

• Cell

A teacher planning for a school trip enters the criteria shown in a query. explain the criteria.

• those who paid more than $500 but smaller than $1000

• those who paid less or equal to $500, or less or equal to $1000

• those who paid between $500 and $1000 inclusive

• those who paid Equal to or more than $500 or equal to or less than $1000

Describe the concept of a database in your own words.

• A random collection of unorganized data which can be viewd online

• organised data held in computers for making reports

• organised information held in tables in Computers

• A structured collection of data organized and stored for easy access, management, and retrieval.

What is the difference between data and information?

• Data is qualitative, while information is quantitative

• Data is held up in databses and information is printed

• Data is always accurate, while information can be misleading

• Data is raw facts and figures, while information is processed data that has meaning and context.

What is the definition of a database?

• A group of related rows and columns

• A series of interconnected databases

• A structured set of data held in a computer

• A collection of tables in a computer

Two main types of databases are the

• flat Analog and relational digital databases

• Relational and unrelational databases

• Large and small databases

• Flat file and Relational databases

What type of field would be best to store the following data : 11-00-67#

• Data/Time

• Boolean

• Text

• Real

The two wild cards used in searching in databases are

• @

  *

• ?

  *

• /

  ?

• \

  @

What are the different data types used in databases?

• integer, real, text, date, boolean,

• data, text, information, boolean

• Text, alphanumeric, analog, digital

• OLE, Long text, analog, currency