Quiz_till_5th_unit

Which is not a type of data in a database?

• Configuration data

• Transaction data

• Convolution data

• Master data

What is ETL used for?

• Moving master data from one system to another

• Moving transaction data into a warehouse

• Moving data from production to QA for bug replication

• Both A & B

Where is metadata?

• Data about business rules

• Properties of the data itself

• Security settings in a database

• Metadata is the same as master data

What is the first form of normalisation

• Each attribute in the relation is atomic

• When we have delimiters in a single column to separate data

• There is no functional dependency between columns

• There is no transitive dependency between columns

Which is not a property of the primary key?

• There can be only one primary key in a table

• The primary key must be unique and not null

• Primary key must always link to the foreign key of another table

• The primary key in a table should be able to reference a record uniquely