Prepare for Schema Design Interview with iQwizz | Difficulty Level: Beginner | Rating: 4.5

Please login before attempting the quiz

Question 1

Which type of dependency does Third Normal Form (3NF) aim to eliminate?

Partial dependency
Join dependency
Transitive dependency
Multi-valued dependency

Question 2

What is the primary purpose of a Primary Key in a database table?

To uniquely identify each row within the table.
To ensure that all columns in the table have a value.
To establish a relationship with another table.
To define the order in which data is stored.

Question 3

You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?

Second Normal Form (2NF)
Third Normal Form (3NF)
None of the above
First Normal Form (1NF)

Question 4

To change the data type of a column in an existing table, which clause should be used with the ALTER TABLE statement?

TRANSFORM COLUMN
UPDATE COLUMN
MODIFY COLUMN
CHANGE COLUMN

Question 5

A table has a composite primary key (using two columns). What condition must be met for it to be considered in Second Normal Form (2NF)?

All columns must have unique values
It must already be in 1NF
No non-key attribute should be dependent on only part of the primary key
It must have no transitive dependencies

Question 6

A Foreign Key in a database is used to...

Define a new data type for a column.
Establish a link between two tables based on a common column.
Create a primary key for a related table.
Enforce data validation rules on a column.

Question 7

Which of the following is a key benefit of using a well-designed schema for a data warehouse?

Improved query performance and efficiency
Increased data redundancy for backups
Reduced need for data modeling and analysis
Simplified data loading from various sources

Question 8

In a table with a composite key, a non-key attribute depends on only one part of the key. Which normal form is violated?

None of the above
Second Normal Form (2NF)
First Normal Form (1NF)
Third Normal Form (3NF)

Question 9

In which scenario might denormalization be considered acceptable in database design?

To enforce strict data integrity
To simplify the database schema
To increase data redundancy
To improve query performance by reducing joins

Question 10

Which of the following is a characteristic of a Dimension table in a Star Schema?

Focuses on storing calculated metrics
Contains highly transactional data
Provides descriptive attributes about business entities
Typically has a small number of rows

Please login before attempting the quiz

Question 1

Which type of dependency does Third Normal Form (3NF) aim to eliminate?

Partial dependency
Join dependency
Transitive dependency
Multi-valued dependency

Question 2

What is the primary purpose of a Primary Key in a database table?

To uniquely identify each row within the table.
To ensure that all columns in the table have a value.
To establish a relationship with another table.
To define the order in which data is stored.

Question 3

You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?

Second Normal Form (2NF)
Third Normal Form (3NF)
None of the above
First Normal Form (1NF)

Question 4

To change the data type of a column in an existing table, which clause should be used with the ALTER TABLE statement?

TRANSFORM COLUMN
UPDATE COLUMN
MODIFY COLUMN
CHANGE COLUMN

Question 5

A table has a composite primary key (using two columns). What condition must be met for it to be considered in Second Normal Form (2NF)?

All columns must have unique values
It must already be in 1NF
No non-key attribute should be dependent on only part of the primary key
It must have no transitive dependencies

Question 6

A Foreign Key in a database is used to...

Define a new data type for a column.
Establish a link between two tables based on a common column.
Create a primary key for a related table.
Enforce data validation rules on a column.

Question 7

Which of the following is a key benefit of using a well-designed schema for a data warehouse?

Improved query performance and efficiency
Increased data redundancy for backups
Reduced need for data modeling and analysis
Simplified data loading from various sources

Question 8

In a table with a composite key, a non-key attribute depends on only one part of the key. Which normal form is violated?

None of the above
Second Normal Form (2NF)
First Normal Form (1NF)
Third Normal Form (3NF)

Question 9

In which scenario might denormalization be considered acceptable in database design?

To enforce strict data integrity
To simplify the database schema
To increase data redundancy
To improve query performance by reducing joins

Question 10

Which of the following is a characteristic of a Dimension table in a Star Schema?

Focuses on storing calculated metrics
Contains highly transactional data
Provides descriptive attributes about business entities
Typically has a small number of rows

Schema Design Questions

Please login before attempting the quiz

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Please login before attempting the quiz

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Login Account