What are the most common interview questions on ETL Testing for experience?

613

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

561

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1123

---

how would you improve etl (extract, transform, load) throughput?

556

---

define and explain the differences between clustered and non-clustered indexes.

607

---

what are the different ways to return the rowcount of a table?

588

---

what is datawarehouse?

664

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

914

---

how will add additional conditions in sql?

588

---

What is a Database?

606

---

What is a Transformation?

579

---

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

585

---

Which statement is used to delete a table in MySQL.

499

---

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1006

---

What are SSL and TSL protocols?

592

---