Scribd
Upload
18 views1 page

Mysql

This document is an assignment for Class 11 Information Technology focusing on database concepts. It includes one-mark questions, basic definitions, examples and syntax for DML commands, and competency-based questions related to database management systems and SQL commands. The assignment covers essential topics such as DBMS, DML commands, and practical SQL applications.

Uploaded by

shanpreet.singh08
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
18 views1 page

Mysql

This document is an assignment for Class 11 Information Technology focusing on database concepts. It includes one-mark questions, basic definitions, examples and syntax for DML commands, and competency-based questions related to database management systems and SQL commands. The assignment covers essential topics such as DBMS, DML commands, and practical SQL applications.

Uploaded by

shanpreet.singh08
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
You are on page 1/ 1

GURU NANAK INTERNATIONAL PUBLIC SCHOOL

I-Block, B.R.S Nagar, Ludhiana


Class : 11 Information Technology (802)

Assignment – Database Concepts


Section A: One-Mark Questions
1. What is a database?
2. Expand DBMS.
3. Write one example of a DBMS.
4. What is a row/tuple?
5. What is a column/field?
6. Name one DML command.
7. Which DML command is used to remove data from a table?
8. What does the SELECT command do?
9. Which keyword is used in SQL to add new data into a table?
10. Write the full form of SQL.
Section B: Basic Definitions
11. Define Database Management System (DBMS).
12. Define Row/Tuple with an example.
13. Define Column/Field with an example.
14. Differentiate between Row and Column.
15. What is the difference between DDL and DML?

Section C: Examples & Syntax (DML Commands)


16. Write the syntax of the INSERT command in SQL with an example.
17. Write the syntax of the UPDATE command in SQL with an example.
18. Write the syntax of the DELETE command in SQL with an example.
19. Write the syntax of the SELECT command in SQL with an example.
Section D: Competency-Based Questions
20. A school wants to store student details (RollNo, Name, Class, Marks) in a database. Which
DBMS concept helps in storing such information? Write one benefit of using DBMS.
21. A librarian wants to delete all records of books issued before 2020. Which SQL command
should be used? Write the correct syntax.
22. In a company database, the HR manager wants to increase the salary of employees by 10%
whose department is “Sales”. Write the SQL command.
23. Ramesh is asked to display the names of all customers from the “Customer” table whose city
is “Delhi”. Which SQL command will he use?

You might also like