1) What is SQL?
2) When SQL appeared?
3) What are the usages of SQL?
4) Does SQL support programming?
5) What are the subsets of SQL?
6) What is a Data Definition Language?
7) What is a Data Manipulation Language?
8) What is Data Control Language?
9) What are tables and fields in the database?
10) What is a primary key?
11) What is a foreign key?
12) What is a unique key?
13) What is the difference between primary key and unique key?
14) What is a Database?
15) What is DBMS?
16) What are the different types of database management systems?
17) What is RDBMS?
18) What is Normalization in a Database?
19) What is the primary use of Normalization?
20) What are the disadvantages of not performing Database Normalization?
21) What is an inconsistent dependency?
22) What is Denormalization in a Database?
23) What are the types of operators available in SQL?
24) What is a view in SQL?
25) What is an Index in SQL?
26) Which are the different types of indexes in SQL?
27) What is the unique Index?
28) What is the Clustered Index in SQL?
29) What is the Non-Clustered Index in SQL?
30) What is the difference between SQL, MySQL and SQL Server?
31) What is the difference between SQL and PL/SQL?
32) Is it possible to sort a column using a column alias?
33) What is the difference between clustered and non-clustered index in SQL?
34) What is the SQL query to display the current date?
35) Which are the most commonly used SQL joins?
36) What are the different types of joins in SQL?
37) What is Inner Join in SQL?
38) What is Right Join in SQL?
39) What is Left Join in SQL?
40) What is Full Join in SQL?
41) What is a "TRIGGER" in SQL?
42) What is self-join and what is the requirement of self-join?
43) What are the set operators in SQL?
44) What is the difference between BETWEEN and IN condition operators?
45) What is a constraint? Tell me about its various levels.
46) Write an SQL query to find names of employee start with 'A'?
47) Write an SQL query to get the third maximum salary of an employee from a table named employee_table.
48) What is the difference between DELETE and TRUNCATE statement in SQL?
49) What is ACID property in a database?
50) What is the difference between NULL value, zero and blank space?
51) What is the usage of SQL functions?
52) What do you understand by case manipulation functions?
53) Which are the different case manipulation functions in SQL?
54) Explain character-manipulation functions?
55) Which are the different character-manipulation functions in SQL?
56) What is the usage of NVL() function?
57) Which function is used to return remainder in a division operator in SQL?
58) What are the syntax and use of the COALESCE function?
59) What is the usage of the DISTINCT keyword?
No comments:
Post a Comment