RDBMS Interview Questions

S.No Question
1. What is SQL?
2. What are different types of statements supported by SQL?
3. What is DBMS?
4. What is RDBMS?
5. Why do we use SQL Constraints? Which constraints we can use while creating database in SQL?
6. What are different JOINS used in SQL?
7. What is Normalization?
8. What are all the different Normalization?
9. How many Aggregate Functions are available there in SQL?
10. What is SQL Injection?
11. What is the difference between "Primary Key" and "Unique Key"?
12. What is isNULL() operator?
13. How to change Database name in SQL server?
14. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
15. What is CHECK Constraints?
16. What is an SQL View?
17. What is a Composite Primary Key?
18. What are user defined datatypes and when you should go for them?
19. What is the SELECT statement?
20. What is an Alias in SQL?
21. What is Denormalization?
22. What is the difference between DROP and TRUNCATE statements?
23. What is the difference between DELETE and TRUNCATE statements?
24. How can you fetch first 5 charcter of the string?
25. What is a Primary Key?
26. What is a Unique Key?
27. What is a foreign key?
28. What do you understand by Self Join?
29. What is the differnce between Union and Union All operators?

Contact

Contact Us

Our Address

Office no.- 401,Shekhar Central Building ,Palasiya, Pin-code:452001, Indore

Email Us

contact@codebetter.in

Call Us

+91 88230 75444, +91 99939 28766

Loading
Your message has been sent. Thank you!