JALA Academy - Full Stack Developer - JAVA

Topic

DB INTERVIEW QUESTIONS

Duration

1 Day

Interview Questions

What is the difference between SQL and MySQL?

What is RDBMS? How is it different from DBMS?

What are joins in SQL?

What are Constraints in SQL?

What is the difference between CHAR and VARCHAR2 datatype in SQL?

What is a Primary Key?

What is a Foreign key in SQL?

What are UNION, MINUS, and INTERSECT commands?

What is Cursor? How to use a Cursor?

What are the TRUNCATE, DELETE and DROP statements?

What are Aggregate and Scalar functions?

Write a SQL query to display the current date?

What is an Index?

What is Normalization and what are the advantages of it?

Explain different types of Normalization.

What is the ACID property in a database?

What do you mean by “Trigger” in SQL?

Are NULL values the same as that of zero or a blank space?

What is the difference between cross join and natural join?

What is a subquery in SQL?

How can you insert NULL values in a column while inserting the data?

What is the main difference between ‘BETWEEN’ and ‘IN’ condition operators?

What is the difference between ‘HAVING’ CLAUSE and a ‘WHERE’ CLAUSE?

What is an ALIAS command?

How can you select unique records from a table?

What is the main difference between SQL and PL/SQL?

What is a View?

What is a Stored Procedure?

Assignments

Contact the Technical Co-ordinator for Assignments. For any help WhatsApp the office number