Practical on SQL (12)

-

  1. Create a database College.
  2. Delete a database College.
  3. Create a database OurSchool.
  4. Use database OurSchool.
  5. Create a table student with rollno, class, studentid, sname, address, phone, salary with suitable variable.
  6. Create a table parents with sno, studentid, parentname, phone, address
  7. Create a table persons with a primary key field.
  8. Delete a column salary from student table.
  9. Insert any 5 records into student table.
  10. Display all the records.
  11. Display only class 11 records. (Record must be in table)
  12. Display only name and address of class 12 records. (Record must be in table)
  13. Add a column section to student table.
  14. Update your table field section from varchar(50) into varchar(3)
  15. Update section to all the students.
  16. Update name from Ram to Shyam whose roll no is 10. (Record must be in table)
  17. Delete a single record whose roll no is 5 from student table.
  18. Delete all the data from student table.
  19. Delete student table.
  20. Make a auto increment for sno field in a table.
  21. Display only unique records from the column of a table.
  22. Display all the records whose address is butwal.
  23. Update all the records whose address is butwal to Kathmandu.
  24. Delete all the records whose address is Kathmandu.
  25. Display all the detail of roll no 5.
  26. Display all the records whose Class is 12 and age is 13.
  27. Display all the records whose address is Pokhara or Bhairawaha.
  28. Display all the records whose age is not less than 18.
  29. Display all the records whose country is Nepal and city is Pokhara or Bhairawaha.
  30. Display all the records whose country is not Germany and Not USA.
  31. Select all the records ordered by name in ascending order.
  32. Select all the records ordered by salary in descending order.
  33. Arrange the records by Country and Customer Name. (If coutry will be same then it checks for the customer's name)
  34. Display all the records where address field is null.
  35. Display all the records where phone number field is filled.
  36. Display all the records for first 10 records only.
  37. Display only first 50% records only.
  38. Display first three records' whose country is Nepal.
  39. Find the cheapest price from the products.
  40. Find the expensive price from the products.
  41. Find the total number of records from the country Nepal.
  42. Find the average price of a product.
  43. Calculate the sum of all product of a specific brand.
  44. Find total price of order.
  45. Display all the products whose name starts from a.
  46. Display all the products whose name ends with a.
  47. Display all the records whose name have r in second position.
  48. Display all the records whose name have at least 3 characters and a is in second position.
  49. Display all the records whose city starts from a,b,c,d,e.
  50. Display all the records whose city does not starts from a,b,c,d,e.
  51. Select all the records whose customers that are located in Butwal, Pokhara, Kathmandu.
  52. Select all the records whose products price is in between 20000 and 50000.
  53. Select all the records whose products price is in between 20000 and 50000.
  54. Select all the records ordered by product name whose address is Butwal and Kathmandu.
  55. Select all the records whose order is between 05/07/2022 and 05/07/2023.
  56. Display all the records from customer, CustomerID as ID and customername as customer.
  57. Display all the records from customer and while displaying combine address, postalcode, city, country as Address.
  58. Solve the following.
  59. Notice that the "CustomerID" column in the "Orders" table refers to the "CustomerID" in the "Customers" table. The relationship between the two tables above is the "CustomerID" column.
  60. Then, we can create the following SQL statement (that contains an INNER JOIN), that selects records that have matching values in both tables:

  1. (INNER) JOIN: Returns records that have matching values in both tables
  2. LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
  3. RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
  4. FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table
61. Join all the records of any two tables.
62. Join only distinct data from any two tables.

Comments

Post a Comment

Popular posts from this blog

Question Collection-11

-
 Computer System 1. Draw the block diagram of computer system. Explain the input and processing unit. 2. Explain different types of system bus. Different types of system bus. Differentiate between primary and secondary memory. 3. Define the memory structure of computer system. Explain cache, main and secondary memory with purpose. 4. What is computer system? Explain different components with their function. 5. What is generation of computer? Explain the different generations of computer with their major features. 6. What is CPU? Explain the major units of CPU. 7. Explain any five fields of usage of computer in present days. 8. Explain the role of memory in a computer and differentiate between main memory and auxiliary storage. 9. What do you mean by peripherals? Differentiate between impact and non-impact printers. 10. Discuss about how the development of the PCs(Personal computer) has extended the use of computer in present days. 11. Differentiate between analog and digital comput...
Read more

Software Process Model (12)

-
  What is Software Development Life Cycle? Software Process Model Software Development Life Cycle (SDLC) is a process used by the software industry to design, develop and test high quality softwares. The SDLC aims to produce a high-quality software that meets or exceeds customer expectations, reaches completion within times and cost estimates. It is a process followed for a software project, within a software organization. It consists of a detailed plan describing how to develop, maintain, replace and alter or enhance specific software. The life cycle defines a methodology for improving the quality of software and the overall development process. System Development Life Cycle Phases / Stages: System Study The Study phase is the most crucial step in creating a successful system. During this phase you decide exactly what you want to do and the problems you’re trying to solve by defining the problems, the objectives and the resources such as personnel and costs. System Analy...
Read more

Important Questions for XII

-
  Unit-1- Database Management System - 8 Marks 1. What is Database and DBMS? List out the advantages and disadvantages of DBMS. 2. Explain the different models of DBMS with advantages and disadvantages. 3. Write differentiate between centralized and distributed database systems. 4. Who is DBA? What are the major responsibilities of DBA? 5. What is data integrity in DBMS? Explain its types. 6. What is normalization? Explain the normalization process with examples. 7. Define the following terms.            a) Data Dictionary      b) Primary Key      c) Relationship      d) DML           e) SQL      f) Data Integrity      g) DDL      h) Data Security      i) Database System 8. What are the different types of SQL commands. Write with example.  Unit-2- Data Communication and Networking - 9 Marks 1...
Read more