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

Hard

3 votes498 runs0 comment

What is GDPR?

Data Scientist

data

regulation

titouan lecampat Sep 19, 2022

Easy

3 votes473 runs0 comment

What type of constraint was violated?

Data Scientist

database

primary key

uniqueness

Nicolasat Sep 19, 2022

Expert

2 votes556 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

Medium

2 votes470 runs0 comment

The decomposition normalization algorithm is?.

Data Scientist

database

normalization

titouan lecampat Sep 19, 2022

Expert

1 vote610 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 vote513 runs1 comment

Which entity provides the legal framework supervising databases in France?

Data Scientist

database

france

titouan lecampat Sep 19, 2022

Medium

1 vote71 runs1 comment

What type of constraint was violated?

Data Scientist

database

constraint

titouan lecampat Mar 17, 2023

Easy

0 vote461 runs0 comment

What is a database?

Data Scientist

data

storage

titouan lecampat Sep 19, 2022

Hard

0 vote437 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 vote431 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 vote430 runs0 comment

What happens when you make the same transaction several times?

Data Scientist

database

transactions

titouan lecampat Sep 19, 2022

Expert

0 vote421 runs0 comment

Properties of an elementary functional dependency X$ ightarrow$Y

Data Scientist

database

functional dependency

titouan lecampat Sep 19, 2022

Medium

0 vote417 runs0 comment

What is a Table in a database?

Data Scientist

database

table

titouan lecampat Sep 19, 2022

Medium

0 vote415 runs0 comment

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

Data Scientist

database

cardinality

titouan lecampat Mar 28, 2022

Easy

0 vote415 runs0 comment

A relation must contain at least one key

Data Scientist

database

relation

titouan lecampat Mar 28, 2022

Easy

0 vote414 runs0 comment

How is a database managed with?

Data Scientist

database

management

titouan lecampat Mar 28, 2022

Expert

0 vote412 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 vote410 runs0 comment

What is the problem with a Cartesian product of tables?

Data Scientist

database

joins

titouan lecampat Mar 28, 2022

Medium

0 vote409 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 vote280 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?

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

The decomposition normalization algorithm is?.

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 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}.

What happens when you make the same transaction several times?

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?

A relation must contain at least one key

How is a database managed with?

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.