6.3 Database Management And Administration Tools

Question 1

What is the purpose of BI (Business Intelligence), and what is a BI system?

Question 2

What is the purpose of a Data Warehouse?

Question 3

What is the purpose of SQP keywords: SELECT - FROM - WHERE?

Question 4

Review SQL wildcard characters such as *,%.

Question 5

Review SQL relational operators such as > (greater than), < (less than).

Question 6

Which field must contain a unique value in order for a relational database table to function?

Answer 6

Primary key

Question 7

What is the database administrator’s role in security?

Answer 7

To institute protocols to protect the databases from external threats

Question 8

Armando is a freelance graphic designer. He has decided to create a database of the artwork he has done throughout the years. Each of his pieces of art is sorted using an assigned name and number.

Answer 8

Character string

Question 9

In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?

Answer 9

Knowledge

Question 10

What is the role of drivers in facilitating communication between applications and databases?

Answer 10

They allow the application to interact with the database.

Question 11

Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?

Answer 11

FROM

Question 12

What is the database administrator’s role in security?

Answer 12

To institute protocols to protect the databases from external threats