RANDOM WEEK 2

Question 1

SQL is a non procedural language, was does non procedural mean

Answer 1

meaning you just tell it what you want, not how to do it

Question 2

what can you do with the SELECT option

Answer 2

with the select option you can get info out of a table :

SELECT * FROM customers;

Question 3

what can you do with the INSERT option

Answer 3

The INSERT statement is used to add new records to a table.

Question 4

OLTP (Online Transaction Processing)

Answer 4

day to day operations, for things like buying stuff online, fast transactions

Question 5

OLAP (Online Analytical Processing)

Answer 5

data analysis and decision making, analyzing trends, which product was most sold last year (trends) etc

Question 6

OLTP OR OLAP: clerk/it professional

Answer 6

OLTP

Question 7

OLTP OR OLAP: ad-hoc

Answer 7

OLAP

Question 8

OLTP OR OLAP: query throughput response

Answer 8

OLAP

Question 9

OLTP OR OLAP: repetitive

Answer 9

OLTP

Question 10

why keep OLTP and OLAP seperate? (who uses what)

Answer 10

OLTP is used by DBMS
OLAP is used by warehouses

Question 11

two sorts of multi-dimensional model

Answer 11

star schema: fact table in the middle, connected to smaller attendant tables

snowflake schema: same but further splitting into a set of smaller dimension tables.