Database Concepts Quiz

Data Types define how numbers are stored, where as Strings define how text is stored. True False

False

One database model considered in the pre-relational model era is

Hierarchical Model

If the text "Mississippi" is saved to a field with a data type of Char(5) the resulting saved value will be "Miss" "Mississippi" "Missi" Missi_____"

Missi

One Post-Relational DB is A. No SQL B. Data Mining C. Graphic SQL

No SQL

You are designing a table to track a companies fleet of vehicles, each vehicle needs a unique ID for the service department to track maintenance. They currently have about 72 cars and 12 trucks. They plan to add about 6-8 each year. Which DataType would work best to keep track of the ID's. Tiny Int Medium Int Big Int Small Int Integer

Small Int

DBMS

database management system

Records in a Relational table _________ (Select all that apply) do not have a guaranteed order are always named using a singular form must be unique

do not have a guaranteed order must be unique

Database components

major database systems

Database Engine

Determines how data is physically stored

Which DataType is best for whole numbers? Decimals Numeric Integers VarChar's

Integers

In a Relational Model, an entity is a collection of directly related data such as a person, place, object, etc. A. True B. False

True

In the Object-oriented model, tables (or entities) mimic the structure of objects within a program/application. A. True B. False

True

SQL (Structured Query Language)

a set of keywords for interacting with the database

Columns in a Relational table ___________ (Select all that apply) are stored in a fixed order also called fields define a data type must have unique names are the same thing as attributes

also called fields define a data type must have unique names are the same thing as attributes