SQL

 What is SQL?

What is a database?

What is DBMS?

What is RDBMS?

What is a schema?

What is a clause?

What is an SQL query?

What is a subquery?

What is a Stored Procedure?

What is a Recursive Stored Procedure?

What is a Trigger?

What is a join?

What is Data Integrity?

What is Normalization?

What is Denormalization?

What is a primary key?

What is a unique key?

What is a foreign key?

What is an index?

What is a view?

What is Cursor? How to use a Cursor?

How to create empty tables with the same structure as another table?

What is Pattern Matching in SQL? 

What is the difference between DBMS and RDBMS?

What are Entities and Relationships?

 What are UNION, MINUS and INTERSECT commands?

What is the difference between SQL and MySQL?

What are SQL dialects? Give some examples.

What are the main applications of SQL?

What is an SQL statement? Give some examples.

What types of SQL commands (or SQL subsets) do you know?

Give some examples of common SQL commands of each type.

What is DBMS, and what types of DBMS do you know?

What is RDBMS? Give some examples of RDBMS.

What are tables and fields in SQL?

What is an SQL query, and what types of queries do you know?

What types of SQL subqueries do you know?

What is a constraint, and why use constraints?

What SQL constraints do you know?

What types of joins do you know?

What types of indexes do you know?

What is a SQL comment?

What is a SQL operator?

What types of SQL operators do you know?

What is an alias?

What are some common statements used with the SELECT query?

What are Aggregate and Scalar functions?

What is User-defined function? What are its various types?

What is OLTP?

 What are the differences between OLTP and OLAP?

What is Collation? What are the different types of Collation Sensitivity?

How to create a table?

How to update a table?

How to delete a table from a database?

How to get the count of records in a table?

How to sort records in a table?

How to select all columns from a table?

How to select common records from two tables?

What is the DISTINCT statement and how do you use it?

What are entities? Give some examples.

What are relationships? Give some examples.

What is NULL value? How is it different from zero or a blank space?

What is a function in SQL, and why use functions?

What types of SQL functions do you know?

What aggregate functions do you know?

What scalar functions do you know?

What are case manipulation functions? Give some examples.

 What are character manipulation functions? Give some examples.

What is the difference between local and global variables?

What is the default data ordering with the ORDER BY statement, and how do you change it?

What set operators do you know?

What operator is used in the query for pattern matching?

 What is the difference between a primary key and a unique key?

What is a composite primary key?

What is the order of appearance of the common statements in the SELECT query?

In which order the interpreter executes the common statements in the SELECT query?

What is a view, and why use it?

Can we create a view based on another view?

Can we still use a view if the original table is deleted?

What types of SQL relationships do you know?

What are the possible values of a BOOLEAN data field?

What is normalization in SQL, and why use it?

What is denormalization in SQL, and why use it?

 What is the difference between renaming a column and giving an alias to it?

What is the difference between nested and correlated subqueries?

What is the difference between clustered and non-clustered indexes?

What is the CASE() function?

What is the difference between the DELETE and TRUNCATE statements?

 What is the difference between the DROP and TRUNCATE statements?

What is the difference between the HAVING and WHERE statements?

How do you add a record to a table?

 How to delete a record from a table?

 How to add a column to a table?

How to rename a column of a table?

How to delete a column from a table?

 How to select all even or all odd records in a table?

How to prevent duplicate records when making a query?

How to insert many rows in a table?

How to find the nth highest value in a column of a table?

How to find the values in a text column of a table that start with a certain letter?

How to find the last id in a table?

How to select random rows from a table?