CBSE Class 12th Mid Term Exam 2024-25 : Information Practices Most Important Question with Answers

SHARING IS CARING

If our Website helped you a little, then kindly spread our voice using Social Networks. Spread our word to your readers, friends, teachers, students & all those close ones who deserve to know what you know now.

CBSE Class 12th Mid Term/Half-Yearly Exam 2024-25 is approaching, and it is very important to prepare thoroughly for it, Preparing for CBSE Class 12th Mid-Term Exam 2024-25 can be challenging, especially for Information Practices.

To help you prepare, we have compiled some of the most important questions along with their answers. These questions are designed to help you revise key concepts and perform better in the exam.

CBSE Class 12 Information Practices Important Question and Solutions

Q1. Write any two advantages of network.

Q2. Define Fire Wall.

Q3. Name the network device which is used to amplifying the signal.

Q4. Write the full form of (1) MAC (2) TCP/IP

Q5. How ROUTER is different from Bridge? Explain.

Q6. Explain any two threats of network security.

Q7. How bus topology is different from Start Topology? Explain.

Q8. How List Box is Different from Combo Box? Explain.

Q9. Write any one method and event of jTextField.

Q10. Name two data types of Java used to store fractional numbers (numbers with decimals).

Q11. Distinguish between Java and Netbeans.

Q12. What is the use of RAD? Explain.

Q13. What will be displayed in jTextField1 and jTextField2?

int x,y,z,t;
x = 7;
y= 10;
z = x+y*3;
t= x + y;
jTextField1.setText("'"+z);
jTextField2.setText(""+t);

Q14. Consider the following code:

salary = 20000;
grade = 'g';
switch(grade)
{
case 'x' : salary = 25000;
break;
case 'y' : salary = 30000;
break;
}

(i) What will be the value of salary variable after execution of the above code?

(ii) What will happen if 'break' statements are omitted from the above code?

Q15. How Switch..case is different from If..Else? Explain with an example.

Q16. Arun has applied a Constraint on a column(field) such that Arun must have to insert a value in this field, when he inserts a new row in the table. Which constraint has Ajay used?

Q17. Define Primary Key.

Q18. 'STUDENT' table has a column named 'REMARK' that stores Remarks. The values stored in REMARK are "PASS" or "NOT PASS" or "COMPTT" etc. Write SQL query to display details of all rows except those that have REMARK as "PASS".

Q19. Write a Query to display the Structure of the table EMPLOYEE.

Q20. Write a Query to display all the constraints along with the field names.

Q21. Find the output of the following:

Table: EMP

Empno	Ename	Salary	Deptno
1234	Rahul	2000	10
2315	Sagar	3000	20
4312	Janvi	3000	20
5345	Aishwarya	4000	30

(i) Select Deptno, Avg(Salary) from EMP group by Deptno;

(ii) Select left(ename,4) from emp;

Q22. How Update Command is different from Alter Command? Explain with an example.

Q23. What is the use of COMMT? How it is different from ROLLBACK? Explain.

Q24. What is the difference between DDL and DML? Explain with an Example.

Q25. Write Java Code to accept any number from the user and check the number is "Prime" or "Not".

Q26. What is the difference between for loop and While loop? Explain with an example.

Q27. How NULL is different from 0(zero)? Explain with an example.

Q28. How INT data type is different from DECIMAL? Explain with an example.

Q29. Rahul is not clear about the difference between the following two statements:

(i) Select count(distinct(deptno)) from emp;

(ii) Select count(deptno) from emp;

Help him understand the difference between these two statements

Q30. Find the output of the following:

(i) Select round(5678.56,-1)+truncate(3320.45,0);

(ii) Select mod(dayofmonth("2018-02-20"),2);

(iii) Select POW(INSTR('My_Database','_'),2);

(iv) Select instr("Correction","r");

Q31. Write any two E-Commerce web site names.

Q32. Define Back End.

Q33. Mr. Paul is working as System Developer in Electronics Enterprises. Help him to choose most appropriate controls from List Box, Combo Box, Text Field, Text Area, Radio Button, Check Box, Label and Command Button for the following entries:

SNo	Function
1	Select any number of facilities
2	To Enter the Name
3	Select the department
4	Select the gender

👉 CBSE Class 12 Study Materials

CBSE Class 12 Syllabus 2024-25	CBSE Class 12 Previous Year Papers
NCERT Books For Class 12 Books	NCERT Class 12 Solutions
CBSE Class 12 Full Study Material	CBSE Class 12 Sample Paper 2023-24