Chapter 7

Question 1

What is data persistence?

Answer 1

Data is permanently available.

Question 2

A user is granted permission to access a database. What is this an example of?

Answer 2

Data definition

Question 3

What type of database stores images?

Answer 3

Non relational database (dbms)

Question 4

Is document database is what type of database?

Answer 4

Non relational database

Question 5

Pictures with meta data are classified ad what type of data?

Answer 5

Semi-structured data

Question 6

What are csv files used for?

Answer 6

Reporting

Question 7

What dimension is a flat file?

Answer 7

2 dimensions

Question 8

What would drive the need to use Database?

Answer 8

Multiple users
Scalability
Speed
Holding variety of data
Number of records
Data persistence

Question 9

What happens when a user tries to write to a flat file?

Answer 9

The file is locked

Question 10

How can speed be increased when using databases?

Answer 10

By placing the database and their log file on SSD rather than HDD

Question 11

True or false

With databases all changes are saved after each cell of data is edited

Answer 11

True

Question 12

Is Relational database an example of structured data?

Answer 12

Yes

Question 13

How does RDBMS ensure data integrity?

Answer 13

No duplicated rows
Null values used when there is no data
Column values must not be repeating

Question 14

What does a null value mean?

Answer 14

The absence of data

Question 15

What is a schema?

Answer 15

Rules and structure of a database.

Question 16

What are the 2 types of schema in relational database?

Answer 16

Logical schema

Physical schema

Question 17

Which should exist first? The logical schema or the physical schema?

Answer 17

Logical schema

Question 18

What does the schema define?

Answer 18

Tables
Forms
Reports
Queries data type allowed
Macro and module

Question 19

What is a row in a table?

Answer 19

Record

Question 20

What are the columns in a table called?

Answer 20

Fields

Question 21

What makes a table in a database relational?

Answer 21

It must be a primary key

Question 22

Who places constraints on fields?

Answer 22

The database administrator

Question 23

What do macro and modules do for databases?

Answer 23

Let you add functionalities to a database, for example a set time to run a report

Question 24

Which database stores values as blobs?

Answer 24

Key/value database

Question 25

What are the ways that database can be accessed?

Answer 25

Manual Access
Direct Access
Programmatic Access
User interface and utility access

Question 26

What is manual access?

Answer 26

Going directly into the table

Question 27

What happens with direct access

Answer 27

Access the database table across a network. Usually done with an API(application programming interface) or ODBC(open database connection, JDBC(Java database connection)

Question 28

What is the other name for permission?

Answer 28

Privileges

Question 29

What are the 3 different types of permissions?

Answer 29

Server permission
Database permission
Object permission

Question 30

What is the ALTER command used for in SQL

Answer 30

Add
Delete
Modify columns

ALTER TABLE table_name ADD columb_name datatype;

DROP

Question 31

What is the CREATE command used for in database management?

Answer 31

Create tables in a database

CREATE TABLE table_name (column datatype, column2 datatype)

Question 32

What command is used to delete a table or database?

Answer 32

DROP TABLE table_name;

Question 33

How is the UPDATE command used?

Answer 33

UPDATE Column name
SET field=xxxxx
WHERE field=

Question 34

What are the 2 recommended ways to backup a database

Answer 34

Database Data dump

Run a backup

Question 35

Where are flat files stored

Answer 35

On the RAM