Chapter Wise Important Questions- XII

Chapter 1: Database Management System

1.       What is normalization? Explain 1NF, 2NF and 3NF with example.

2.       Differentiate between centralized and distributed database system.

3.        Differentiate between DDL and DML.

4.       Explain the Relational Data model with example.

5.       Explain any two advantages of DBMS over traditional file system.

6.       What is transmission medium? Explain its major types with advantages and disadvantages.

7.       What is database model? Explain with example.

8.       Write the SQL statement to perform the following task.

 a. Create a table named Students with following fields and insert the following five records.

Roll  No.

Name

 

Class

 

Address

 

Percentage

 

 

 

 

 

b Add the field named Rank in the above table.

c.Display Name, Class and Address of the students from the table Students.

d. Display all the records of students whose Address is "Bhaktapur"

e. Display Roll number, Name and Percentage from the table Students.

f. Increase the percentage of all the students by 5.

g. Update the Name and Class of Student into Navya and 12 having roll number 8.

h. Delete the record of student named Ram.

i. Display all the records in ascending order by Name.

j. Display all the records whose name starts with N.

k Display the records of Students whose Class is 12 and lives in Kathmandu.

 l. Display the record of Students whose Percentage lies between 75 and 90

 

Chapter 2: Computer Network

1.       Differentiate between star, bus and ring topology with diagram.

2.       What is transmission media?

3.       Differentiate between guided and unguided media.

4.       Explain OSI model

 

Chapter 3: Web Technology –II

1.       Write JavaScript function that checks if a number is odd or even and print them.

2.       Write a JavaScrip program to check greatest/ smallest number among three numbers.

3.       Write a program to find factorial of a given number.

4.       Write a program to find factor of a given number.

5.       Write a JavaScript Code snippet, along with HTML, that displays the multiplication table of a entered number.

6.       How do you add an event handler in JavaScript? Give an example.

7.       How do you fetch data from a database in PHP and display it in form? Describe.

8.       Define a syntax for database connectivity.

9.Write a JavaScrip program to check if a given number is palindrome or not.

10. Explain form validation using Javascript with example.

11. Write a PHP program to calculate the sum of two digit of a number.

12. How to use array in PHP demonstrate with example

 

Chapter 5: Object Oriented Programming

1.       Differentiate between OOP and POP

2.       Write short notes on

a.       Class

b.       Inheritance

c.        Polymorphism

d.       Encapsulation

e.        Procedure Programming language

 

Chapter 6: Software Process Model

1.       Explain software development life cycle.

2.       What is system analyst? Explain its role and responsibilities.

3.       What is waterfall model? Write it advantages and disadvantages.

4.       What is requirement gathering? Explain its methods.

5.       What are the major activities performed to design the software? Describe.

Chapter 7: Recent trend in technology

1.       What is cloud computing? Write its advantages and disadvantages.

2.       What is AI? Explain the popular five-application areas of AI.Give example of AI application in education.

3.       Define following with advantages and disadvantages:

a.       Mobile Computing

b.       VR

 

Chapter 4: Programming in C

1.       Write a C program using binary file handling (putw(), getw()).

2.       What is structure? Write a program to input roll, name and age of 5 students and display them properly using structure.      

3.       Write the advantage of pointer. Write a C-program to enter the radius of a football and find the area of football by using user defined function 

4.       Write a C program using structures to store and display book details.

5.       Write a C program to enter ID, employee_name, and post of the employee and store them in a data file named "emp.txt". Display each record on the screen in an appropriate format.

6.       Write a C-program using structure to input staff id, name and the salary of 50 staffs. Display staff id, name and salary of those staff whose salary range from 25 thousand to 40 thousand.

7.       Write a C program that reads the account_number, name and address of ten customers from users and displays the account_number, name and address of these customers using Array and structure.

8.       What are the components of a function in C? Describe Call-by-value and Call-by-reference and passing function parameters.

9.       Write a C program to find the factorial of a number using recursion.

10.    Write a program to store and display records of a student using structure.

11.    Write a C program to write student data into a file.

12.    Write a C program to write student data into a file.

13.    File Handling – Write and Read Student Record

14. to check whether the number is odd or even.

15. to display 0,1,1,2,3....................... upto 10th term.

 


Popular posts from this blog

Computer

Grid for SEE class 10 Computer Science  Chapter Very Short Questions( (1 marks each) Short Questions( (2 marks each) Long Questions(4 marks each) Total Computer Fundamentals 6X1=6 (2 QnA, 2TT, 2FF) 5X2=10 (5 QnA) 1X4=4 (Number System) 20 Marks DBMS 2X1=2 (2 QnA) 4X2=8 (4 QnA) - 10 Marks QBASIC 1X1=1 (1 QnA) 3X2=6 (Output, Debug, QnA) 2X4=8 (Sub, Function, File Handling) 15 Marks C- programming 1X1=1 (1 QnA) - 1X4=4   5 Marks Total 10 questions 12 questions 4 questions 50 marks
Read more

Sequential Programs

  Sequential Programs 1.       WAP to display sum of two integer numbers. x = 2 y = 3 result = x+ y print("The sum is:",result)   Output: The sum is: 5   WAP to display sum of two integer numbers given by the user. 1.1 x = int(input("Enter the first number:")) y = int(input("Enter the second number:")) result = x+ y print("The sum is:",result) Output: Enter the first number:2 Enter the second number:3 The sum is: 5  1.2 x = int(input("Enter the first number:")) y = int(input("Enter the second number:")) result = x+ y print(f"The sum of {x} and {y} is: {result}")   Output: Enter the first number:2 Enter the second number:3 The sum of 2 and 3 is: 5 1.3   x = float(input("Enter first number:")) y = float(input("Enter second number: ")) sum = x + y print("The sum of {0} and {1} is {2}".format(x, y, sum))   Output: Enter ...
Read more