Scribd
Upload
9 views1 page

Essential DBMS and SQL Operations Guide

The document consists of a series of questions related to database management systems (DBMS) and relational database management systems (RDBMS). It covers topics such as SQL queries for data manipulation, types of joins, primary keys, and concepts like NULL values. Additionally, it includes practical tasks like updating records, finding maximum values, and sorting data within tables.

Uploaded by

Digication Institute
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

Essential DBMS and SQL Operations Guide

The document consists of a series of questions related to database management systems (DBMS) and relational database management systems (RDBMS). It covers topics such as SQL queries for data manipulation, types of joins, primary keys, and concepts like NULL values. Additionally, it includes practical tasks like updating records, finding maximum values, and sorting data within tables.

Uploaded by

Digication Institute
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q1 What is DBMS, and what types of DBMS do you know?

Q2 What is RDBMS? Give some examples of RDBMS.

Q3 Find the maximum value of address_id in the customers table.

Q4 Update the city field to "Unknown" for all rows where it is currently NULL.(Customer Table)

Q5 Use the LIKE operator to find customers whose first_name includes the letter "a".(Customer
Table)

Q6 Create a new column that combines first_name and last_name into a single full_name column.
(Customer Table)

Q7 What types of joins do you know?

Q8. What is a primary key?

Q9 How to delete a table from a database?

Q10 How to sort records in a table?

Q11 Assume address_id represents a score; add 10 points to each customer’s address_id and display
it.

Q12 Find customers who have no payments recorded

Q13 Find customers who have made payments over a certain amount (e.g., 1000)

Q14 List the top 3 customers with the highest payment amounts

Q15 Find customers who have made payments, along with the number of payments they made
(assuming multiple payments per customer)

Q16 Get the employee_id, first_name, last_name, and hire_date for employees who joined in June
1987.(Employees)

Q17 Find the Total Salary by Department(employees)

Q18 What is NULL value? How is it different from zero or a blank space?

Q19 What is the default data ordering with the ORDER BY statement, and how do you change it?

You might also like