Management of Data

Question 1

Which data type is used to represent product order code that comprises alphanumeric characters?

Answer 1

String

Question 2

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.

Which data type will be required in order to create his database?

Answer 2

Character string

Question 3

Why is it important to ensure that data support business goals?

Answer 3

To aid in making strategic decisions

Question 4

In which category of the data, information, knowledge, wisdom (DIKW) hierarchy would business intelligence by located?

Answer 4

Knowledge

Question 5

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

Answer 5

Primary key

Question 6

what are the three main categories of databases?

Answer 6

Flat file, relational, hierarchal

Question 7

What is the database administrators like in security?

Answer 7

To institute protocols to protect the databases from external threats

Question 8

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

Answer 8

They allow the application to interact with database

Question 9

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

Answer 9

FROM