TOP SQL INTERVIEW QUESTIONS
1.Difference between SQL and MySQL: SQL is a standard language for accessing and managing databases, while MySQL is an open-source relational database management system (RDBMS) that uses SQL.
2.What are ACID properties in a transaction?: ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties ensure reliable processing in a database system during transaction processing.
3.Dateadd function in SQL: The DATEADD function adds a number to a specified part of a date and returns the modified date. It’s useful for calculations involving dates.
4.What is a View in SQL?: A view is a virtual table representing a subset of data from one or more tables. Views are not physically present in the database but act like tables.
5.Different types of indexes: The three main types of indexes in SQL are Unique Index, Clustered Index, and NonClustered Index, each serving different purposes in data retrieval and storage optimization.
6.What is a Cursor?: A cursor in SQL is a control structure used for traversal of records in a database. It acts like a pointer, allowing operations on data row by row.
7.Subsets of SQL: SQL has several subsets, including Data Definition Language (DDL) for database structure operations, Data Manipulation Language (DML) for data access and modification, and Data Control Language (DCL) for access control.
8.What is a Stored Procedure?: A stored procedure is a set of SQL statements that can be stored in the database. A stored procedure can be invoked and executed as needed, which is efficient for frequently used or complex operations.
9.What are Scalar Functions?: Scalar functions in SQL are used to return a single value based on the input value. For example, UCASE() converts a specified field to upper case.
10.What is a Natural Join?: A natural join in SQL is a type of join that creates an implicit join clause for you based on the common columns in the two tables being joined. It is a subset of the inner join
