- In MySQL, what is difference between BTREE and HASH indices?
- What are differences between
COUNT(*)
,COUNT(1)
andCOUNT(column_name)
? - Explain the different types of SQL commands.
- Explain the different types of
JOIN
. - What’s the difference between a
WHERE
clause and aHAVING
clause? - What’s the difference between a
TRUNCATE
command and aDELETE
command? - What are
UNION
,UNION ALL
,MINUS
, andINTERSECT
set operators? - What are Normalization and Denormalization?
- What are scalar functions?
- What are aggregate functions?
- What is a stored procedure?
- What is an index?
- What is an SQL Server cursor? How do you use it?
- What are the different types of indexes?
- What are ACID properties?
- What is a schema?
- What is an alias command?
- What is the difference between
CHAR
andVARCHAR
datatypes in SQL? - What is collation? What are the different collation sensitivity?
- Provide an integer
n
and a list of integersnums
, find all pairs of integer which are sum equal ton
. Pairs are unique,(x,y)
and(y,x)
are one result. - Find the Longest Increasing Odds Subsequence