40 interview questions on Database - Fundamentals for developers (2024)

Hard

3 votes516 runs0 comment

What is GDPR?

Data Scientist

data

regulation

titouan lecampat Sep 19, 2022

Easy

3 votes490 runs0 comment

What type of constraint was violated?

Data Scientist

database

primary key

uniqueness

Nicolasat Sep 19, 2022

Medium

3 votes488 runs0 comment

The decomposition normalization algorithm is?.

Data Scientist

database

normalization

titouan lecampat Sep 19, 2022

Expert

2 votes575 runs0 comment

Find the keys of the following functional dependencies: a, b -> c a, b, d -> e c -> a, b d -> f e -> g

Data Scientist

database

functional dependencies

titouan lecampat Mar 28, 2022

Expert

1 vote630 runs1 comment

How to obtain the surname and first name of people running more than 10 units?

Data Scientist

database

projection

selection

titouan lecampat Mar 28, 2022

Medium

1 vote530 runs1 comment

Which entity provides the legal framework supervising databases in France?

Data Scientist

database

france

titouan lecampat Sep 19, 2022

Expert

1 vote448 runs0 comment

What happens when you make the same transaction several times?

Data Scientist

database

transactions

titouan lecampat Sep 19, 2022

Medium

1 vote74 runs1 comment

What type of constraint was violated?

Data Scientist

database

constraint

titouan lecampat Mar 17, 2023

Easy

0 vote477 runs0 comment

What is a database?

Data Scientist

data

storage

titouan lecampat Sep 19, 2022

Hard

0 vote454 runs0 comment

Which of these propositions can be types of constraints in a database?

Data Scientist

database

constraints

titouan lecampat Sep 19, 2022

Expert

0 vote449 runs0 comment

Get all the names from the table E={(Name), (first name), time}.

Data Scientist

database

projection

titouan lecampat Sep 19, 2022

Expert

0 vote438 runs0 comment

Properties of an elementary functional dependency X$ ightarrow$Y

Data Scientist

database

functional dependency

titouan lecampat Sep 19, 2022

Medium

0 vote434 runs0 comment

What is a Table in a database?

Data Scientist

database

table

titouan lecampat Sep 19, 2022

Medium

0 vote432 runs0 comment

What does the bond 0..* mean in a database?

Data Scientist

database

cardinality

titouan lecampat Mar 28, 2022

Easy

0 vote431 runs0 comment

How is a database managed with?

Data Scientist

database

management

titouan lecampat Mar 28, 2022

Easy

0 vote431 runs0 comment

A relation must contain at least one key

Data Scientist

database

relation

titouan lecampat Mar 28, 2022

Expert

0 vote429 runs0 comment

Find the normal form of the relation {a -> b; c -> a, d, e; f -> a}.

Data Scientist

database

normal form

titouan lecampat Mar 28, 2022

Medium

0 vote427 runs0 comment

What is the problem with a Cartesian product of tables?

Data Scientist

database

joins

titouan lecampat Mar 28, 2022

Medium

0 vote425 runs0 comment

Given a table E={(Name), (first name), time} representing the time for a race, what type of constraint was violated?

Data Scientist

database

constraints

titouan lecampat Mar 28, 2022

Expert

0 vote291 runs0 comment

Given a set of functional dependencies, find the minimum number of functional dependencies to be removed in order to achieve a non redundant coverage.

Data Scientist

database

functional dependencies

titouan lecampat Mar 28, 2022

40 interview questions on Database - Fundamentalsfor developers (2024)

Test your technical skills before an interview of Database - Fundamentals with 40 corrected questions. Beginner, Intermediate or Expert level.

What is GDPR?

What type of constraint was violated?

The decomposition normalization algorithm is?.

Find the keys of the following functional dependencies: a, b -> c a, b, d -> e c -> a, b d -> f e -> g

How to obtain the surname and first name of people running more than 10 units?

Which entity provides the legal framework supervising databases in France?

What happens when you make the same transaction several times?

What type of constraint was violated?

What is a database?

Which of these propositions can be types of constraints in a database?

Get all the names from the table E={(Name), (first name), time}.

Properties of an elementary functional dependency X$ ightarrow$Y

What is a Table in a database?

What does the bond 0..* mean in a database?

How is a database managed with?

A relation must contain at least one key

Find the normal form of the relation {a -> b; c -> a, d, e; f -> a}.

What is the problem with a Cartesian product of tables?

Given a table E={(Name), (first name), time} representing the time for a race, what type of constraint was violated?

Given a set of functional dependencies, find the minimum number of functional dependencies to be removed in order to achieve a non redundant coverage.