Class 10 IT | Chapter- Database | Important MCQs - 4

  Class 10 IT (402) Complete Solution

CBSE Class 10 Information Technology (402)
Important MCQs
Chapter -Database

Sport

Use above Table for MCQS

1. Which DDL command is used to build a table "Sport " in SQL?

A) Create table Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);
B) Make table Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int)
C) Build table Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);
D) Create Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);

... Answer is A) Create table Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);

2. This DML command is used to enter record in table "Sport" in SQL.

A) Enter into Sport values ( 11, 9, "Surjeet", "Cricket", "B", 68);
B) Put into Sport ( 11, 9, "Surjeet", "Cricket", "B", 68);
C) Insert in Sport value ( 11, 9, "Surjeet", "Cricket", "B", 68);
D) Insert into Sport values ( 11, 9, "Surjeet", "Cricket", "B", 68);

... Answer is D) Insert into Sport values ( 11, 9, "Surjeet", "Cricket", "B", 68);

3. ____ is the DML command to display all record from table "Sport" in SQL.

A) Display record from table Sport:
B) Select * from Sport;
C) Select all record from Sport;
D) Select * from table Sport;

... Answer is B) Select * from Sport;

4. Which DML command is used to display "Class & Name" columns from table "Sport" in SQL?

A) Select class, Name from table Sport;
B) Query class, Name from Sport;
C) Select class, Name from Sport;
D) Display class, Name from Sport;

... Answer is C) Select class, Name from Sport;

5. Replace Grade = A where class = 9 using DML command in SQL.

A) Change table Sport set Grade = "A" where class = 9;
B) Update Sport replace Grade = "A" check class = 9;
C) Update table set Grade = "A" where class = 9
D) Update Sport set Grade = "A" where class = 9;

... Answer is D) Update Sport set Grade = "A" where class = 9;

6. _____ is the DML command to display all records of class = 8 students in SQL.

A) Show all from Sport Where class = 8;
B) Select * from Sport Where class = 8;
C) Display all from Sport Where class = 8;
D) Select * from table Sport Where class = 8

... Answer is B) Select * from Sport Where class = 8;

7. Which DML command is used to display all record, who have got Marks >=70, from table "Sport" in SQL.

A) Selct * from Sport where marks >= 70;
B) Selct * from Sport check marks >= 70;
C) Display all from Sport where marks >= 70;
D) Display all from Sport find marks >= 70;

... Answer is A) Selct * from Sport where marks >= 70;

8. ____ DML command is used to delete the record of "Surjeet" from table "Sport" in SQL.

A) Drop from Sport Where Name = "Surjeet";
B) Delete from Sport cheeck Name = "Surjeet";
C) Delete from Sport Where Name = "Surjeet";
D) Delete from table Sport Where Name = "Surjeet";

... Answer is C) Delete from Sport Where Name = "Surjeet";

9. This DDL command is used to delete the table "Sport" in SQL.

A) Drop table Sport;
B) Delete table Sport;
C) Drop Sport table;
D) Drop table Sport

... Answer is A) Drop table Sport;

10. Which DDL command is used to delete one column "Class" from table "Sport" in SQL?

A) Drop column class from Sport:
B) Drop column class from table Sport
C) Delete column class from Sport;
D) Alter table Sport drop column class;

... Answer is D) Alter table Sport drop column class;

--------------------------------------------------

Chapter  - Database

•  MCQs - 1
•  MCQs - 2
•  MCQs - 3
•  MCQs - 4
  

 ------------------------------------------------

------------------------------------------

MCQs of All Chapters Class 10 IT (402) 

Class 10 IT (402) Important MCQs Questions

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application

------------------------------------------

 Chapters of Class 10  IT (402) Solution

Class 10 IT (402) Question Answer

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application

------------------------------------------

Sample Paper of Class 10 IT 402

CBSE Class 10 IT (402) Sample Paper

• IT (402) Sample Paper 2020 - 21
  
• IT (402) Sample Paper 2021 - 22
• IT (402) Sample Paper 2021 - 22
• IT (402) Sample Paper 2022 - 23
• IT (402) Sample Paper 2022 - 23  
• IT (402)Sample Paper 2022 - 23

 

------------------------------------------

--------------------------------------------------

Sample Paper of Class 10

• English Sample Paper 2022 - 23
  
• Hindi A Sample Paper 2022 - 23
• Maths (Standard) Sample Paper 2022 - 23
• Maths (Basic) Sample Paper 2022 - 23
• Science Sample Paper 2022 - 23  
• Social Science Sample Paper 2022-23

-------------------------------------------------