SQL

Articles related to structured query language (SQL)

• What are tables and fields?
• Which operator is used in query for pattern matching?
• What is the command used to fetch first 5 characters of the string?
• How to select unique records from a table?
• How to fetch common records from two tables?
• How can you create an empty table from an existing table?
• What are aggregate and scalar functions?
• What is an ALIAS command?
• What is Union, minus and Interact commands?
• What is recursive stored procedure?
• What is CLAUSE?
• What is Online Transaction Processing (OLTP)?
• What are all types of user defined functions?
• What is user defined functions?
• What is Cross-Join?
• What is Self-Join?
• What is Datawarehouse?
• What is the difference between Cluster and Non-Cluster Index?
• What is Auto Increment?
• What is data Integrity?
• What is a constraint?
• What are local and global variables and their differences?
• What is the difference between DELETE and TRUNCATE commands?
• What is a trigger?
• What is a stored procedure?
• What are the types of subquery?
• What is subquery?
• What is a query?
• What is a relationship and what are they?
• What is a Cursor?
• What are all the different types of indexes?
• What is an Index?
• What is a View?
• What are all the different normalizations?
• What is Denormalization?
• What is normalization?
• What are the types of join and explain each?
• What is a join?
• What is a foreign key?
• What is a unique key?
• What is a primary key?
• What is a Database?
• What is SQL?
• What is RDBMS?