What is SQL?
SQL stands for Structured Query Language, it lets you to access and manipulate data like insertion, updation, retrieving and deleting.
What is DMBS?
What is RDMS?
What is Database?
What are tables and fields?
What is primary key?
What is unique key?
What is a foreign key?
What is join?
What are the types of join and explain each?
What is normalization?
What is Denormalization?
What are all the different normalizations?
What is a View?
What is an Index?
What are all the diffrent types of indexes?
What is a cursor?
What is a relationship and what are they?
What is query?
What is subquery?
What are the types of subquery?
What is a stored procedure?
What is a trigger?
What is the difference between DELETE and TRUNCATE commands?
What are local and global variables and their differences?
What is a constraint?
What is data Integrity?
What is Auto Increment?
What is the difference between Cluster and Non-Cluster Index?
What is Datawarehouse?
What is Self-Join?
What is Cross-Join?
What is user defined functions
What is collation?
What are all different types of collation sensitivity?
Advantages and Disadvantages of Stored Procedure?
What is Online Transaction Processing(OLTP)?
What is CLAUSE?
What is recursive store procedure?
What is union, minus and interact commands?
What is an ALIAS command?
What is difference between TRUNCATE and DROP statements?
What are aggregate and scalar functions?
How can you create an empty table from an existing table?
How to fetch common records from two tables?
How to fetch alternate records from table?
How to select unique records from a table?
What is the command used to fetch first 5 characters of the string?
Which operator is used in query for pattern matching?
No comments:
Post a Comment