CLASS 10 UNIT 3 SESSION 4 IMPORTANT BOOK SOLUTION
CLASS 10 UNIT 3 SESSION 4 IMPORTANT BOOK SOLUTION
ASSESSMENT
Fill in the blanks:
- A _____ helps the user to systematically store information in the database.
ANSWER: Form
2. A _______ enables users to view, enter, and change data directly in database objects such as tables.
ANSWER: Form
3. ________ statement retrieves zero or more rows from one or more database tables or database views.
ANSWER: SELECT
4. By default, data is arranged in ________ order using ORDER BY clause.
ANSWER: Ascending
5. ______ statement is used for modifying records in a database.
ANSWER: Update
6. __ statement is used to remove one or more records in a Database.
ANSWER: Delete
Short Answer Questions:
- Name DML commands.
Answer:
- SELECT -Retrieve data from the database.
- INSERT – Insert data into a table.
- UPDATE – Update existing data within a table.
- DELETE – Delete records from a database table.
- What is the purpose of using queries?
Answer: Query is to collect specific information from the pool of data. A query helps us join information from different tables and filter that information.
3 Which clause of Select statement helps to display specific data?
Answer: WHERE Clause
4. Differentiate between Where and Orderby clause of SQL statements.
Answer:
- WHERE specifies which rows to retrieve.
- ORDER BY specifies an order in which to return the rows.
5 .State the purpose of Update Command with the help of an example.
Answer: Update statement is used for modifying records in a database.
For example: Update SDetails set Location = ‘Delhi’ where RollNo = 14;
It will update the RollNo =14 where student Location is Delhi in SDetails Table.
One thought on “CLASS 10 UNIT 3 SESSION 4 IMPORTANT BOOK SOLUTION”