Intro 2 Database

15 Questions | By Rizsess | Last updated: Jul 30, 2011 | Total Attempts: 309

Questions

Settings

All about databases. Goodluck Sophomores.

Questions and Answers

1.

It is a collection of data that is related to a particular subject or purpose.
- A.
  
  Database
- B.
  
  List
- C.
  
  Table
- D.
  
  Group
2.

It stands for POS in a checkout counter.
- A.
  
  Point-of-System
- B.
  
  Proof-of-Sales
- C.
  
  Point-of-Sales
- D.
  
  None of the above
3.

What do you call the database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file?
- A.
  
  Relational database
- B.
  
  List database
- C.
  
  Flat file database
- D.
  
  None of the above
4.

It is a type of database where one or more tables are connected to other tables in the database, such as in the library system.
- A.
  
  Relational database
- B.
  
  List database
- C.
  
  Flat-file database
- D.
  
  None of the above
5.

It refers to a row in a database table.
- A.
  
  Record
- B.
  
  Column
- C.
  
  Vertical
- D.
  
  Horizontal
6.

A column in a table is called a ___________.
- A.
  
  Record
- B.
  
  Column
- C.
  
  Field
- D.
  
  Horizontal
7.

This is the stage in database design were one gathers and lists all the necessary fields for the database project.
- A.
  
  Data definition
- B.
  
  Data refinement
- C.
  
  Establishing relationships
- D.
  
  None of the above
8.

It is the stage where we break down some fields to more specific fields so we can store information in the smallest logical parts.
- A.
  
  Data definition
- B.
  
  Data refinement
- C.
  
  Establishing relationships
- D.
  
  None of the above
9.

It is an association established between common fields (columns) in two tables.
- A.
  
  Line
- B.
  
  Relationship
- C.
  
  Primary key
- D.
  
  Records
10.

This key uniquely identifies each record in a table.
- A.
  
  Primary key
- B.
  
  Key record
- C.
  
  Unique key
- D.
  
  Field name
11.

Data refinement is the stage when we analyze our tables more closely and create a relationship between tables.
- A.
  
  True
- B.
  
  False
12.

Compared to a manual database a computerized database is more flexible, compact, and faster.
- A.
  
  True
- B.
  
  False
13.

Computerized database is compact; since database records stored in filing cabinets can be stored in just a few floppy diskettes.
- A.
  
  True
- B.
  
  False
14.

A manual database is flexible; that is, it is possible to examine information from number of ways.
- A.
  
  True
- B.
  
  False
15.

Lack of planning has caused some programmers to be disappointed with the database they created.
- A.
  
  True
- B.
  
  False