Scribd
Upload
7 views1 page

DB Interview Question Bank

The document is a question bank organized by rooms, each containing questions related to databases and SQL. Topics include primary keys, atomicity, DML, joins, differences between SQL and NoSQL, data normalization, data mining, SQL injection attacks, DBMS, fields vs. rows, composite keys, AWS Redshift, and database schemas. It also includes requests for explanations of specific SQL statements.

Uploaded by

Darshana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

DB Interview Question Bank

The document is a question bank organized by rooms, each containing questions related to databases and SQL. Topics include primary keys, atomicity, DML, joins, differences between SQL and NoSQL, data normalization, data mining, SQL injection attacks, DBMS, fields vs. rows, composite keys, AWS Redshift, and database schemas. It also includes requests for explanations of specific SQL statements.

Uploaded by

Darshana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

The Question Bank

Room 1/6

1. Explain what a Primary Key is


2. When talking about Databases, what does atomicity mean
3. Why would you use DML

Room 2

4. If you wanted to select all rows from two tables in a SQL Database, what type of
Join would you use
5. What is the difference between a SQL and a NOSQL database
6. What is data normalisation

Room 3/5

7. What is data mining


8. What is a SQL injection attack
9. What does DBMS stand for

Room 4

10. What is the difference between a field and a row in a relational database
11. What is a composite key and why would you use one
12. What is AWS Redshift and why would you use it

Room 5

13. Explain what this SQL statement does

14. What is a Database Schema


15. Explain what this SQL statement does

You might also like