Module 01b - Components of a Database System

Question 1

What are the components of a Database System with SQL

Answer 1

Applications DBMS Database

Question 2

What are applications (as a DB component)

Answer 2

Are the computer programs that users work with

Question 3

What is a DBMS

Answer 3

Database Management Systems, that creates, processes, and administers databases

Question 4

What is SQL

Answer 4

Structure Query Language, is a internationally recognized standard database language that is used by all commercial DBMSs.

Question 5

Which functions of the applications have?

Answer 5

* Create and process forms * Process user queries * Create and process reports * Execute application logic * Control application

Question 6

Which the functions the DBMSs have

Answer 6

*Create database and tables *Create supporting structures (e.g., indexes) *Read database data *Modify database data *Maintain database structures *Enforce rules *Control concurrency *Provide security *Perform backup and recovery

Question 7

Which are the parts of a database

Answer 7

*Tables of user data *Metadata *Indexes *Stored procedures *Triggers *Security data Backup/Recovery data

Question 8

What is the purpose of a database

Answer 8

Help people to track thing of interest to them

Question 9

Where data are stored

Answer 9

Into tables, which have rows and columns like a spreadsheet.