Introduction of Database

1. What is DBMS?
2. List commercial Databases available in market?
3. Define RDBMS?What are the advantage of RDBMS over DBMS?
4. Why Database needed in development?
5. What are the components of Database?
6. Role of a DBA in Database?

Basics of Database

1. Explain various elements of a table? With examples.
2. Database is a collection of only tables or more than this? Justify?
3. What are different data types are use in Database table? List down.
4. What is Constraints? Define different type of constraints?
5. What is called referential integrity?
6. What do you mean by primary key? Differentiate with foreign key?
7. What is called view? Why we create it?

Database Operations

1. Define DDL, DML and DCL.
2. What is CRUD operation? Define it on a table.
3. Define JOIN? Describe different types of JOIN?
4. How web front end interact with database?
5. Create a Table name as RECORDS, Where columns are- Id, Name, Address, Phone. Perform following operation on it.
   • INSERT
   • UPDATE
   • SELECT all
   • SELECT Id and Name
   • SELECT with WHERE clause
   • DELETE
   • ALTER table
6. What is SQL subquery? Explain with example.
7. What is a purpose of using union?
8. Explain all wildcards available in SQL?
9. How we can add extra column in table? List the name of SQL statement?

Database Testing

1. What is database testing? Define it’s objective.
2. How database play a role in different architecture?
3. What are the problems, when we ignored Database testing?
4. What do we Test at the Database Level?
5. Some SQL Queries on Our Database(https://training.qaonlinetraining.com/execute_sql/)
   • How to display all information from customers  table?  Develop a query and run that?
   • Develop SQL to display all information stored in employee table?
   • Develop SQL to list all information in products table?
6. Why we use distinct? Develop sql query to display various cities from where customers belong to? execute it and make sure you can get the results.
7. Develop SQL to list all customers from Germany? execute and make sure you can get results.
8. Display SQL to display all customers belong to UK and London? execute it and make sure you can get the results.
9. Develop SQL to display all customers which are order by in ascending order on city? Execute and make sure you can display results.
10. Develop sql to display first 5 records from products table. Execute and verify results.
11. Develop sql to display all customers who belong  to country which name starts with M. Execute and verify results.
12. Develop sql to display all customers who belong to country which name end with y.
13. Develop sql to display all customers who belong to country which name not start with M.
14. Develop SQL which selects all customers with a Country containing the pattern “land”.
15. • Develop SQL to display all products between price 10 and 20. Execute and verify the results.
    • Develop SQL to display all products not between price 10 and 20. Execute and verify the results.
    • Develop SQL to display all orders from orders table between ’04-July-1996′ and ’09-July-1996′
16. Develop SQL query which explain how to use aliases to display column names?
17. Develop sql to display average value of price column from products table?
18. Develop SQL query to return total number of records from customers  table?
19. Develop SQL to find the price of costliest and cheapest items from product table?
20. Using inner join, develop sql on customers and order table which display all customers who book orders?
21. Using left join on customer and order table, develop sql which display all customers and whatever orders they have?
22. Using right join on customer and order table, develop sql which display all customers and any order they have places?
23. Develop SQL to display all customers group by different countries?
24. Using product table, develop SQL which display all products group by supplier id and price more than 18?
25. Explain five sql functions? With example.