DB 1- Database Terms

Question 1

What is data?

Answer 1

Single items that are stored in database either individually or as a set

Question 2

What is field?

Answer 2

Data structure for a piece of data

Question 3

What is records?

Answer 3

Combination of data in the same row

Question 4

What are the 5 types of SQL?

Answer 4

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Query Language (DQL)
• Data Control Language (DCL)
• Transaction Control Language (TCL)

Question 5

What is Data Definition Language (DDL)?

Answer 5

Used to describe and name (EX: entities, attributes, entity relationship)

Question 6

What is Data Manipulation Language (DML)?

Answer 6

-Provides basic data manipulation operations on data held in the database

Question 7

What is the purpose of data model?

Answer 7

To represent data in an understandable way