Lecture 1: Intro to DBMS

Question 1

Database types (Hint: 4)

Answer 1

• traditional database
  -multimedia
  GIS (graphical information systems )
  data warehouses
  real time

Question 2

database is

Answer 2

collection of related data

Question 3

data is

Answer 3

known facts that can be recorded and have an implicit meaning

Question 4

transaction is

Answer 4

executing process that includes one or more database accesses

Question 5

Database Management System is

Answer 5

Software system facilitates the creation and maintenance of a computerized database

Question 6

Database System

Answer 6

DBMS together with the database itself is the database system sometimes the application can also be included

Question 7

A database has a specific size? (t or f)

Answer 7

f , a database can be of any size

Question 8

Mini World is

Answer 8

A representation aspects in the real world has to be accurate and reliable

Question 9

traditional database consists of

Answer 9

numerical and textual data

Question 10

multimedia database contains weather images and satellite images (t or f)

Answer 10

nope. multimedia contains videos ad audio clips and video streams

GIS is the one that has weather images and satellite images

Question 11

DBMS defines a database by defining …. …. and ….

Answer 11

datatypes, constraints, structures

Question 12

DBMS cant construct nor load the database contents (t or f)

Answer 12

false

Question 13

Manipulating the database is (hint: 3 forms of manipulating )

Answer 13

Retrieval : Querying, generating reports
Modification :inserting , deleting and updating the content
Accessing the database through web application

Question 14

DBMS functionality consists of processing and sharing by set of concurrent users and applications programs ( t or f )

Answer 14

true

Question 15

DBMS provides means of security means it

Answer 15

prevents unauthorized access

Question 16

From DBMS functionality is presentation and visualization of data (t or f)

Answer 16

true

Question 17

Active processing means

Answer 17

means it takes internal action (triggers)

Question 18

Mention the bad properties of a file approach (Hint: 4 )

Answer 18

Inconsistency
Redundancy
Waste Storage
Much efforts to maintain updates

Question 19

What do we mean by database has a self describing nature

Answer 19

a DBMS catalog stores the description of a particular database (Meta-data)

Question 20

Isolation Property is

Answer 20

ensures that each transaction appears to execute in isolation from other transactions , even though hundreds of transactions may be executing concurrently

Question 21

The atomicity property is

Answer 21

ensures that either all transactions are executed or none are

Question 22

Database users are divided into

Answer 22

• actors on the scene

- workers behind the scene

Question 23

Actors on the scene are divided

Answer 23

• database administrators
• database designers
• end users

Question 24

Database administrators are responsible for

Answer 24

for authorizing access
monitoring of database
efficiency off operators
acquiring the software and resources

Question 25

Database designers Are responsible

Answer 25

Define and control the content of the database | And makes the application that access this database

Question 26

End-Users are responsible for

Answer 26

They use the data for queries , reports and some of them update the database content

Question 27

End users are divided into

Answer 27

Casual end users naive end users sophisticated stand alone

Question 28

Causal end users access the database how?

Answer 28

when needed they know the least about the database

Question 29

Naïve end users uses the database how

Answer 29

runs operations already made (larger section of the end users / parametric )

Question 30

How does sophisticated end users

Answer 30

these include engineers , scientists etc.. they are more familiar with the dbms users tools in form of the software packages

Question 31

how do stand alone end users use database

Answer 31

creates the database for himself and knows the most about databases.