Database

Question 1

Database characteristics

Answer 1

A store of interrelated data designed to be shared by a group of users

Data in a database is logically related but physically distributed, called a dataset

Question 2

What can be included in a data

Answer 2

Anything that can be measured or recorded like numbers, characters, strings, images, sound

Question 3

What should be expected of a database?

Answer 3

Secure, Reliable, Correct, Consistent, Technology Proof

Question 4

Four main components of database system?

Answer 4

Data
Hardware
Software
Users

Question 5

Database advantages

Answer 5

Compactness, Speed, Automation, Currency, Control

Question 6

What is SQL?

Answer 6

Survey Query Language, a standard language for accessing and manipulating databases.

Common tool for interaction with Relational databases

Question 7

What is ANSI?

Answer 7

American National Standards Institute, which the industry standards conforms to

Question 8

Advantages of SQL

Answer 8

Allows full control of database
Provides common language for use with different database systems