Pauk Pauk

Which of the following is a benefit of normalization?

• Improved data integrity

• Increasing data redundancy, worsening data integrity, and making data maintenance harder

• Complicating data structure, reducing data integrity, and increasing data redundancy

• Decreasing data redundancy, compromising data integrity, and making data maintenance more complex

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

• Unique key

• Main key

• Key attribute

• Super key

What is the best way to represent the attributes in a large database?

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

• Data Analysis

• Data Visualization

• DDL (Data Definition Language)

• DML (Data Manipulation Langauge)

A database entity is also known as

If you were collecting and storing information about your music collection, an album would be considered a/an

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match

• Join

• Union

• Intersection

• Cartesian Product

Which type of data can be stored in the database?

• Only numbers

• Audio files

• Images only

• Any type of data

Tables in second normal form (2NF)

• Tables in 2NF allow partial dependencies on the primary key

• Tables in 2NF can have non-key attributes that are not functionally dependent on the primary key

• Tables in 2NF require all attributes to be part of the primary key

• Tables in 2NF have no partial dependencies, meaning all non-key attributes are fully functionally dependent on the primary key

What does the following query do?
UPDATE student
SET marks = marks*1.10;