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

Expert

5 votes684 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

Hard

4 votes573 runs

1 comment

What is GDPR?

Data Scientist

data

regulation

titouan lecampat Sep 19, 2022

Medium

3 votes528 runs0 comment

The decomposition normalization algorithm is?.

Data Scientist

database

normalization

titouan lecampat Sep 19, 2022

Easy

3 votes524 runs0 comment

What type of constraint was violated?

Data Scientist

database

primary key

uniqueness

Nicolasat Sep 19, 2022

Expert

2 votes626 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 votes574 runs1 comment

Which entity provides the legal framework supervising databases in France?

Data Scientist

database

france

titouan lecampat Sep 19, 2022

Expert

1 vote483 runs0 comment

What happens when you make the same transaction several times?

Data Scientist

database

transactions

titouan lecampat Sep 19, 2022

Medium

1 vote75 runs1 comment

What type of constraint was violated?

Data Scientist

database

constraint

titouan lecampat Mar 17, 2023

Easy

0 vote512 runs0 comment

What is a database?

Data Scientist

data

storage

titouan lecampat Sep 19, 2022

Hard

0 vote490 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 vote485 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 vote474 runs0 comment

Properties of an elementary functional dependency X$ ightarrow$Y

Data Scientist

database

functional dependency

titouan lecampat Sep 19, 2022

Medium

0 vote469 runs0 comment

What is a Table in a database?

Data Scientist

database

table

titouan lecampat Sep 19, 2022

Medium

0 vote465 runs0 comment

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

Data Scientist

database

cardinality

titouan lecampat Mar 28, 2022

Easy

0 vote465 runs0 comment

A relation must contain at least one key

Data Scientist

database

relation

titouan lecampat Mar 28, 2022

Easy

0 vote464 runs0 comment

How is a database managed with?

Data Scientist

database

management

titouan lecampat Mar 28, 2022

Expert

0 vote463 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 vote461 runs0 comment

What is the problem with a Cartesian product of tables?

Data Scientist

database

joins

titouan lecampat Mar 28, 2022

Medium

0 vote458 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 vote311 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.

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

What is GDPR?

The decomposition normalization algorithm is?.

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

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?

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.