On Monday, 21 October 2019 at 09:57:16 UTC, Arjunkumar wrote:
Hello Everyone,
I am looking for SQL interview questions list. I have scheduled
my interviews in the upcoming week, Recruiters told me they
might test my SQL knowledge too. What kind of questions should
I expect?
One is a consultant swe / data scientist and the other is an
application developer.
Here I am sharing with you a list of interview questions, which
you need to go through and you will get an answer to these
questions from here
(https://hackr.io/blog/top-sql-interview-questions).
1. What is the difference between DBMS and RDBMS?
2. Can we embed Pl/SQL in SQL? Justify your answers
3. What do you mean by data manipulation language - DML?
4. What is a join in SQL? What are the types of joins?
5. What is the difference between CHAR and VARCHAR2 datatype in
SQL?
6. What is a trigger?
7. What are SQL constraints give examples?
8. What are ACID properties in a transaction?
9. What is SAVEPOINT in a transaction control?
10. What are the scalar functions in SQL? Give an example
