Finals - L5 - Persistent Storage Database

Question 1

What is the crucial component that manages communication
between the memory and the processor in a computer
system?

Example: CPU (cache) and RAM (1 and 0)

Answer 1

Memory Controller

Question 2

This performs a particular function. What term is this?

Example: WEB, CLI/CONSOLE, GUI

Answer 2

Applications

Question 3

What is the supplementary memory system that temporarily (not persistent) stores frequently used instructions and data for quicker processing?

Answer 3

Caching

Question 4

What is any data storage device that retains data after power to that device is shut off?

Answer 4

Persistent Storage

Question 5

What is this called?
* This is a database stored in a file called a flat file.
* There are no structures for indexing or recognizing relationships
between records.

Example:
.txt/.csv
This is not structured

Answer 5

Flat-file database

Question 6

What is the kind of database used by the examples below?
* SQL-based
* sqlite
* Oracle
* MSSQL server
* MySQL

Answer 6

Structured Database

Question 7

EACH DATABASE HAS OWN blank

Example:

Microsoft sql server ———————-ssms- sql server management
studio
Mysql —————————————management studio -
PHPmyadmin

Answer 7

MANAGEMENT SUITE

Question 8

Workbench
blank is the hostname or the computer that is
currently in use to run a program, in which the computer has the role as a virtual server.
* Anyhost —- IP Address

Answer 8

Localhost—127.0.0.1

Question 9

What are the type of constraints used to specify rules for the data in a table?
* These constraints are used to limit the type of data
that can go into a table. This ensures the accuracy and
reliability of the data in the table.

Answer 9

SQL constraints

Question 10

IDENTIFY THE MOST COMMON SQL DATA TYPE:

NUMERIC DATA
blank – Stores numeric values from -2147483648 to
2147483647
blank – Stores numeric values with decimals with lower floating
point that float.
blank – Stores numeric values with decimals with a high floating point
blank – Stores TRUE = 1 or FALSE = 0

Answer 10

• INTEGER / INT
• DOUBLE
• FLOAT
• BOOL

Question 11

IDENTIFY THE MOST COMMON SQL DATA TYPE:

TIME DATA
blank – Stores Date in the format YYYY-MM-DD.
blank – Stores Time in the format hh:mm:ss
blank – Stores Date and time in the format YYYY-MM-DD
hh:mm:ss.

MISCELLANEOUS DATA
blank – Stores large binary data

Answer 11

TIME DATA
* DATE
* TIME
* DATETIME

MISCELLANEOUS DATA
* BLOB

Question 12

IDENTIFY THE MOST COMMON SQL DATA TYPE:

TIME DATA
blank – Stores Date in the format YYYY-MM-DD.
blank – Stores Time in the format hh:mm:ss
blank – Stores Date and time in the format YYYY-MM-DD
hh:mm:ss.

MISCELLANEOUS DATA
blank – Stores large binary data

Answer 12

TIME DATA
* DATE
* TIME
* DATETIME

MISCELLANEOUS DATA
* BLOB

Question 13

What is the command used to create objects in the database?

Answer 13

Create

Question 14

What is the command used to create a table in the MySQL server?

Answer 14

CREATE TABLE

Question 15

What are the 2 commands to log into the MySQL server?

Answer 15

• mysql -u root -p
• CREATE DATABASE database1

Question 16

What is the command used to insert data into the MySQL server?

Answer 16

INSERT INTO

Question 17

The blank statement is used to modify the existing records in a
table.

SYNTAX EXAMPLE:
~~~
UPDATE employee SET firstname=’Darna’, lastname=’Wonderwoman’, yearhired=2010
where empid=2
~~~

Answer 17

UPDATE

Question 18

The blank statement is used to delete existing records in
a table.

SYNTAX EXAMPLE:

DELETE FROM table_name WHERE condition;

Answer 18

DELETE