Download App

IT Set 4 — Information Technology STD 10 — Question

CBSE BoardEnglish MediumSTD 10Information TechnologyIT Set 44 Marks
Question
Consider the following table: Employee
Image
(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display E name and Salary of those employees whose Salary is greater than or equal to 22000.
(ii) Display details of employees who are not getting commission.
(iii) Display all the details of the employee profile ‘SALESMAN’.
✓

Answer

(a) There are 8 fields and 6 records in the table Employee.
(b) (i) SELECT E name, Salary FROM Employee WHERE Salary> = 22000;
(ii) SELECT* FROM Employee WHERE Commission IS NULL;
(iii) SELECT *FROM EMPLOYEE WHERE Profile=’’SALESMAN’;

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "4 Marks Quetions" from IT Set 4→IT Set 4 — all question types→Information Technology STD 10 question papers→CBSE Board STD 10 question papers→CBSE Board question paper generator→

Similar questions

Lavish is preparing notes for his upcoming exams. Help him to write the correct answer to the following:
(i) Scenario (ii) Absolute link (iii) Relative link (iv) Macro
→
Define the following types of integrity:
(i) Entity integrity
(ii) Domain integrity
(iii) Referential integrity
(iv) User-defined integrity
→
Shubham is learning about DBMS. He wants to know about the following:
(a) The purpose of DBMS
(b) Any two uses of DBMS
→
Consider the following table: Employee Salary. 
Image
(i) How many fields and records are in the table EmployeeSalary?
(ii) Write the SQL queries for the following:
(a) List all data of table EmployeeSalary.
(b) Display all the records whose salary’ is less than 25000.
(c) Display the FirstName and JobTitle of employees having Dept ‘Finance’.
→
Ojas had prepared a Table of Contents of the project work he had done in a word processor application.
(a) Tell him the different steps to update the TOC.
(b) Tell him the different steps to delete the TOC.
→
What is network topology? Also, discuss the different types of topologies.
→
Write the steps for text fitting inside a shape in a word processor document. Also, describe its options.
→
Reema has been appointed as an SME in an IT-based company. Tell her the following:
(i) What is a workplace emergency?
(ii) Name the workplace emergencies that may happen.
→
Lavish wants to know the following points about the database. 
(a) Definition of a Database Management System.
(b) Any two advantages of using a database management system for school.
→
Manya is studying the different topologies available in networking. Tell her the difference between Star topology and Bus topology with the help of a suitable diagram.
→