Click ⭐ if you like the project. Pull Request are highly appreciated.
| No. | Questions |
|---|---|
| SELECT | |
| UPDATE | |
| DELETE | |
| INSERT | |
| JOIN | |
| UNION | |
| SELECT DISTINCT | |
| WHERE | |
| AND | |
| OR | |
| NOT | |
| SELECT TOP | |
| MIN | |
| MAX | |
| COUNT | |
| AVG | |
| SUM | |
| LIKE | |
| Wildcards | |
| In | |
| Between | |
| Alias | |
| Inner Join | |
| Left Join | |
| Right Join | |
| Full Join | |
| Self Join | |
| Group By | |
| Having | |
| Exists | |
| All | |
| Any | |
| SELECT INTO | |
| INSERT INTO SELECT | |
| NULL FUNCTIONS | |
| STORED PROCEDURES | |
| COMMENTS | |
| OPERATIONS | |
| SQL Create DB | |
| SQL Drop DB | |
| SQL Backup DB | |
| SQL Create Table | |
| SQL Drop Table | |
| SQL Alter Table | |
| SQL Constraints | |
| SQL Not Null | |
| SQL Unique | |
| SQL Primary Key | |
| SQL Foreign Key | |
| SQL Check | |
| SQL Default | |
| SQL Index | |
| SQL Auto Increment | |
| SQL Dates | |
| SQL Views | |
| SQL Injection | |
| SQL Hosting | |
| SQL Data Types | |
| What is a Database? | |
| What is a Relational Database? | |
| What is RDBMS? | |
| Introduction to SQL | |
| Naming Conventions | |
| Data Integrity | |
| Database Terms | |
| Atomic Values | |
| Relationships | |
| One-to-One Relationships | |
| One-to-Many Relationships | |
| Many-to-Many Relationships | |
| Designing One-to-One Relationships | |
| Designing One-to-Many Relationships | |
| Parent Tables and Child Tables | |
| Designing Many-to-Many Relationships | |
| Introduction to Keys | |
| Primary Key Index | |
| Look up Table | |
| Superkey and Candidate Key | |
| Primary Key and Alternate Key | |
| Surrogate Key and Natural Key | |
| Should I use Surrogate Keys or Natural Keys? | |
| Foreign Key | |
| NOT NULL Foreign Key | |
| Foreign Key Constraints | |
| Simple Key, Composite Key, Compound Key | |
| Review and Key Points....HA GET IT? KEY points | |
| Introduction to Entity Relationship Modeling | |
| Cardinality | |
| Modality | |
| Introduction to Database Normalization | |
| 1NF (First Normal Form of Database Normalization) | |
| 2NF (Second Normal Form of Database Normalization) | |
| 3NF (Third Normal Form of Database Normalization) | |
| Indexes (Clustered, Nonclustered, Composite Index) | |
| Data Types | |
| Introduction to Joins | |
| Inner Join | |
| Inner Join on 3 Tables | |
| Introduction to Outer Joins | |
| Right Outer Join | |
| JOIN with NOT NULL Columns | |
| Outer Join Across 3 Tables | |
| What is the difference between SQL and MySQL? | |
| What are the different subsets of SQL? | |
| What do you mean by DBMS? What are its different types? | |
| What do you mean by table and field in SQL? | |
| What are joins in SQL? | |
| What is the difference between CHAR and VARCHAR2 datatype in SQL? | |
| What is the Primary key? | |
| What are Constraints? | |
| What is the difference between DELETE and TRUNCATE statements? | |
| What is a Unique key? | |
| How to break many:many relationship in 2 SQL tables? | |
| SQL query to remove duplicate records | |
| SQL query to count the occurrences of character 'R' in a string | |
| What is Use of Partial View | |
| Can you write SQL SPs? | |
| How will you find out a third retweet using SQL - considering the database of twitter? | |
| Find the second largest salary from the employee's table | |
| SQL query consisting sets theory. | |
| plsql | |
| SDLC | |
| Microstrategy Schema Designing | |
| Redshift | |
| Write an SQL querry to determine the third highest salary? | |
| Transactions | |
| ACID property | |
| Data Warehouse | |
| stored procedures vs functions | |
| Business Intelligence | |
| Trigger | |
| Multirow functions | |
| find top 10 employee by using DENSE RANK | |
| Write a procedure to store all the data from a table to a collection table. | |
| What are Aggregate functions | |
| What is lazy writer.? | |
| Calculate the no of exp of the employees from the joining date from table? | |
| how to find out 1st highest salary | |
| How will you retrieve the crashed database? | |
| Out of n records the query to pickup 3 to 8 records from a table? | |
| what are the recovery models? | |
| Materialized Views | |
| Whether once can drop an MV, if yes then what will happen to its table | |
| Types of MV | |
| Grants and Privileges | |
| Synonyms | |
| Autonomous Transactions | |
| Parallel Hints | |
| Benefits of Packages | |
| Performance Tuning | |
| how many types of subqueries | |
| cursor | |
| Group function | |
| Difference between where and having | |
| If there is a table with a primary key would it be possible to create a clustered index on the table? | |
| OLTP | |
| OLAP | |
| SSIS troubleshooting | |
| Types of backup on SQL | |
| how to load unstructured data in oracle tables? | |
| what are all the DDL command ? | |
| set operators | |
| Find out the currently running task inside SSIS. | |
| Explain differences between primary key and unique key | |
| Joins (inner, outer, left, right) | |
| Unions and unions all | |
| Stored procedures | |
| Functions (scalar and table-valued) | |
| Triggers | |
| Data manipulation language (DML) | |
| Data definition language (DDL) | |
| Data control language (DCL) | |
| Transactions and concurrency control | |
| ACID (Atomicity, Consistency, Isolation, Durability) properties | |
| Logical and physical database design | |
| Entity-relationship modeling | |
| Normalization techniques (1NF, 2NF, 3NF) | |
| Data integrity constraints (primary keys, foreign keys, unique constraints) | |
| Referential integrity | |
| Query optimization | |
| Query execution plans | |
| Query hints and optimizer directives | |
| Index optimization and covering indexes | |
| EXPLAIN statement and query profiling | |
| Partitioning and sharding | |
| Replication and high availability | |
| Load balancing and clustering | |
| Failover and disaster recovery | |
| Backup and restore strategies | |
| User authentication and authorization | |
| Access control and privileges | |
| Encryption and data security | |
| Auditing and logging | |
| Performance tuning tools (EXPLAIN, SHOW STATUS, etc.) | |
| Connection pooling | |
| Locking and deadlock detection | |
| Query caching and result caching | |
| Full-text search | |
| Spatial data and GIS applications | |
| Performance monitoring and troubleshooting | |
| Performance optimization techniques (query rewriting, denormalization, etc.) | |
| Data warehousing and OLAP (Online Analytical Processing) | |
| Database schema versioning and migration | |
| Advanced backup and recovery strategies (point-in-time recovery, incremental backups) | |
| Database compression and storage optimization | |
| Query rewriting and query hints | |
| Database monitoring and alerting | |
| Database auditing and compliance | |
| Database replication conflict resolution | |
| Advanced locking and isolation levels | |
| Advanced MySQL configuration and optimization settings | |
| Views | |
| Triggers | |
| Computed Columns | |
| Stored Procedures | |
| User Defined Functions | |
| Transaction | |
| Ranking Functions | |
| Aggregate Functions | |
| Prebuilt non-aggregate functions | |
| XML to SQL parsing | |
| Partitions | |
| Dynamic Queries | |
| Joins | |
| Database normalization | |
| Indexing strategies | |
| Subqueries | |
| why jda | |
| how many type of ALWAYSON IN SQL | |
| Azure Migration | |
| How will you construct the database for 1000 users and what its size? | |
| collection | |
| SQL Loader | |
| Merge statement | |
| Differ bw view nd alias name | |
| PIVOT table | |
| DML and DDL command | |
| Types of joints in sql server | |
| bitmap index | |
| case | |
| analytical functions | |
| What is the output of SUM(NULL)? | |
| indexing | |
| partitioning | |
| How to optimize query ? | |
| Basic questions like rank, dense rank union and collection concepts | |
| How would you reset a sequence in Oracle | |
| Write query to retrive the salary and the employee name from the table employee and salary table. | |
| what is private and public specifier related to package | |
| SQL Tuning and Replication | |
| Normalization | |
| floor and ceil functions | |
| constraints | |
| how to restore master database. | |
| What is truncate in sql? | |
| Find Cumulative sum | |
| how to resolve deadlock in mysql | |
| .net page lifecycle,MPFL,firewalls,sql proc,UDF,Delegates,Authenticatuion ,authorization | |
| basic SQL query for first 5 record in list | |
| Types of SQL statement | |
| Explain SDLC Explain normalisation? Sub queries? | |
| Write a query to find Second highest salary from employee table? and many more..... | |
| delete row 3 with primary key ... add row 3 again but it should come exactly at the place of previously deleted 3 | |
| Apti reasoning | |
| What is a default constraint? Explain with an example. | |
| What do you understand by a Character Manipulation function? | |
| high availibility planing | |
| sidaster | |
| how to tune database | |
| Difference between rank and dense rank | |
| SQL Server , Service packs , cluster , alwayson, nirroring | |
| about clustering. | |
| Replication | |
| what is difference between cluster and non cluster index | |
| SQL - HOW TO DELETE DUPLICATE RECORDS BY KEEPING ONE ROW IN MAIN TABLE | |
| DIFFERENCE BETWEEN MERGE AND UNION ALL TRANSFORMATIONS? | |
| what is cross join | |
| concept of DWH | |
| Abt sql, joins, delete, drop, Truncate, unique n primary key foreign, some queries, abt database, cursor, trigger procedure, functions. | |
| what is recursive stored procedure and syntax? | |
| differnce between drop and truncate | |
| Explain oops concepts with Real time example? What is normalization? | |
| sql loader. How to truncate partition. error in extenal table. some scenario based external table and partition. and some query | |
| Indexing and partitioning strategies | |
| does deadlock occur in SQL | |
| why hexaware | |
| join,transaction,lock,block,deadlock | |
| Quries , Remove duplicates with different functionalities , quest based on analytical functions , rank , desk rank , first , last ,grouping | |
| log shipping, mirroring, clustering, Always on | |
| SQL Replication questions, Question on HADR like Mirroring , logshipping and Always On. SQL performance related question | |
| Normalization and its types.Trigger and its types.diff bet Procedure and Function.Constraints.Use of Primary key and Foreign key.some Real time example for above concepts | |
| How to create a compound trigger? | |
| basics of SQL, SQL performances,SSIR,SSRS,SQL Quries | |
| WHAT IS CHECKPOINT AND WHAT ARE CONFIG OPTIONS AVAILABLE? | |
| What is referential integrity | |
| SQL: joins, constraints, clauses, identity column | |
| Overview of Azure data factory and it's use. | |
| Plsql - collections, bulk collect SQL -truncate function with dates, logical sql queries Data base modeling Performance tuning | |
| Same questions, queries asked in each round | |
| what are views | |
| what is index | |
| SQL Joins, Aggregation functions, substring, sql queries based on the interviewer's conditions, Java oops concepts, Normalisation- removing redundancy, small puzzles | |
| What different are the Constraints used on Table Columns in SQL? | |
| questions on join,types of join,view,unique key, some basic question query was lyk, write a query to display 3rd highest salary of employee | |
| Difference between a view and materialized view? Can we modify a view? if any view is modifiable? Difference between PLSQL table and Varray? Have you ever used utl_file package? Write a program to bulk insert into a table using FORALL ? Find the 2nd highest salary of an employee? Difference between procedure and function | |
| high availability concepts | |
| Difference between truncate and delete write query to get third maximum salary. write query to get all employee belonging to sales | |
| sql joins, constraints, normalization etc | |
| Difference between Procedures and Functions? | |
| WHAT ARE DIFF JOINS IN SQL? & EXPLAIN CARTISIAN JOIN. | |
| Olap vs oltp | |
| what is difference between union and union all? | |
| can primary key have null value? | |
| types of SDLC | |
| Clustered and Non-clustered indexes. | |
| Difference between ASM and ADDR report |
It is a structured way of storing data.
It has tables i.e rows and columns. You can create relations i.e joins and unions.
The key difference is that RDBMS (relational database management system) applications store data in a tabular form, while DBMS applications store data as files.
- Introduction to SQL
SELECT
UPDATE
DELETE
INSERT
TABLE
JOIN
UNION
Aggregate functions
SELECT DISTINCT
WHERE
AND
OR
NOT
SELECT TOP
MIN
MAX
COUNT
AVG
SUM
LIKE
Wildcards
In
Between
Alias
Inner Join
Left Join
Right Join
Full Join
Self Join
Group By
Having
Exists
All
Any
SELECT INTO
INSERT INTO SELECT
CASE
NULL FUNCTIONS
STORED PROCEDURES
COMMENTS
OPERATIONS
SQL Create DB
SQL Drop DB
SQL Backup DB
SQL Create Table
SQL Drop Table
SQL Alter Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Check
SQL Default
SQL Index
SQL Auto Increment
SQL Dates
SQL Views
SQL Injection
SQL Hosting
SQL Data Types