www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - SQL Questions Query

reply Arjunkumar <kumararjun678904 gmail.com> writes:
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.
Oct 21 2019
parent Rohan Joshi <rohanjoshi0894 gmai.com> writes:
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
Nov 12 2019