Database Assignmentcan't see properly

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(http://www.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”.
    • 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′
  15. Develop SQL query which explain how to use aliases to display column names?
  16. Develop sql to display average value of price column from products table?
  17. Develop SQL query to return total number of records from customers  table?
  18. Develop SQL to find the price of costliest and cheapest items from product table?
  19. Using inner join, develop sql on customers and order table which display all customers who book orders?
  20. Using left join on customer and order table, develop sql which display all customers and whatever orders they have?
  21. Using right join on customer and order table, develop sql which display all customers and any order they have places?
  22. Develop SQL to display all customers group by different countries?
  23. Using product table, develop SQL which display all products group by supplier id and price more than 18?
  24. Explain five sql functions? With example.

19 Comments

    HOW we can send the assignment to InfoTech?

    It is not my assignment. I Just try to see how that works.
    Q#1
    A database management system (DBMS) is a set of programs and applications that helps in storing, modifying, and extracting information from a database.

    Q#2

    What is DBMS?
    DBMS stands for database management system. DBMS is a computer software application for creating and managing database( organized collection of data). DBMS provides various functions that allows its end users to retrieve, create, modify or delete data in a database. DBMS manages three important things:
    1. Database Engine: that allows data to be accessed, locked and modify.
    2. Database Schema: defines logical structure of database.
    3. Physical Database: is a collection of files that stores the data.

    There are many commercial databases available in market but the popular ones are:
    Microsoft : MS SQL, MS Access
    IBM: DB2
    Oracle: Oracle, MYSQL.

    Define RDBMS?What are the advantage of RDBMS over DBMS?
    RDBMS stands for Relational Database Management System.
    Now days all database management systems are based on relational model first introduced by E.F CODD. Relational database system is where data is spread across several tables.

    What are the components of Database?
    Components of Database are:
    Tables, queries, forms, reports.

    How to display all information from customers table? Develop a query and run that?

    Select * from Customers;

    Develop SQL to display all information stored in employee table?

    Select * from employee

    Develop SQL to list all information in products table?

    Select * from products;

    Develop sql query to display various cities from where customers belong to? execute it and make sure you can get the results.

    SELECT DISTINCT city FROM customers;

    Develop SQL to list all customers from Germany? execute and make sure you can get results.

    SELECT * FROM customers WHERE country= ‘Germany’;

    Display SQL to display all customers belong to UK and London? execute it and make sure you can get the results.

    SELECT * FROM customers WHERE country=’UK’ AND city=’London’;

    Develop SQL to display all customers which are order by in ascending order on city? Execute and make sure you can display results.

    SELECT * FROM customers ORDER BY city;

    Develop sql to display first 5 records from products table. Execute and verify results.

    SELECT * FROM products LIMIT 5

    Develop sql to display all customers who belong to country which name starts with M. Execute and verify results.

    SELECT * FROM customers WHERE country LIKE= ‘M%’;

    Develop sql to display all customers who belong to country which name end with y.

    SELECT * FROM customers WHERE country LIKE= ‘%Y’;

    Develop sql to display all customers who belong to country which name not start with M.

    SELECT * FROM customers WHERE country NOT LIKE ‘M%’;

    Develop SQL which selects all customers with a Country containing the pattern “land”.

    SELECT * FROM customers WHERE country LIKE ‘%LAND%’;

Leave a Reply

Loading Questions

If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com