Book - Chapter 11 In Database Analytics

Question 1

What does in database analytics mean

Answer 1

Describe the processing of data within its repository

Question 2

What are the three advantages to using tables

Answer 2

Disk storage saving. Changes and corrections are easily made. Products can be added to the database prior to any orders being placed.

Question 3

What is the process of reducing duplications

Answer 3

Normalisation

Question 4

What is the select function

Answer 4

Specifies the table columns to be displayed

Question 5

What is the from function

Answer 5

Specifies the name of the table to be queried

Question 6

What is the where function

Answer 6

Specifies the criterion or filter to be applied

Question 7

What is the joint function

Answer 7

Specify the relationships between the multiple tables

Question 8

What is an inner join

Answer 8

Returns rows from the two tables where the ON criteria is met

Question 9

What is the order by function

Answer 9

Sorts of records

Question 10

What is a right outer join function

Answer 10

All rows on the table on the right hand side of the join should be returned regardless of whether there is matching

Question 11

What is the union all function

Answer 11

Mergence the results of the two select statements regardless of any duplicate records appearing in both select statements

Question 12

What is the union function

Answer 12

It is the same as the union all by which it emerges the results of two select statements but it eliminates any duplicates

Question 13

What is the intersect function

Answer 13

Determines any identical records that are returned by two select statements.

Question 14

What is the sub query

Answer 14

Also known as a nested query. It is an SQL query with in a query

Question 15

What is the roll up function

Answer 15

Provides of subtotal

Question 16

What is the cube function

Answer 16

Providing subtotals for each column specified

Question 17

In regular expressions what does this symbol mean

^

Answer 17

Looks for matches at the beginning of the string

Question 18

In regular expressions what does this symbol mean

|

Answer 18

Matches item A or B

Question 19

In regular expressions what does this symbol mean

$

Answer 19

Looks for matches at the end of the string

Question 20

In regular expressions what does this symbol mean

*

Answer 20

Matches preceding item 0 or more times

Question 21

What is a rank function

Answer 21

Can be used to order a set of rose based on some attribute

Question 22

What does EWMA stand for

Answer 22

Exponentially weighted moving average

Question 23

What is madlib

Answer 23

And open source library for scalable in database analytics

Question 24

What does madlib stand for

Answer 24

Magnetic agile deep

Question 25

What is the data lake

Answer 25

Represents an environment that Kalex and stores large volumes of structured and unstructured data sets