Computer Science Question Paper Set C (Model Question)

Which protocol is mainly used for transferring web pages between a web browser and a web server?

Which device is used to regenerate weak signals in a network?

Which SQL command is used to remove selected records from a table?

Which of the following is not a component of multimedia?

Which image format supports animation and is commonly used for simple web graphics?

What will be the output of the following Python code?

a = 8
b = 3
print(a // b)

Which Python statement is used to stop a loop immediately?

Which technology enables computers to identify patterns and learn from data?

Which of the following is an example of Augmented Reality?

Which of the following is a major concern when AI systems collect users' personal information?

What is IP address? Differentiate between IPv4 and IPv6.

What is a network protocol? Write any two examples of network protocols.

What is data redundancy? How can a DBMS help reduce it?

Differentiate between DELETE and DROP commands in SQL.

What is image compression? Why is it important in multimedia?

Write a Python program to calculate the sum of the first 10 natural numbers using a for loop.

What is a user-defined function in Python? Write its general syntax.

What is Machine Learning? Mention any two applications of Machine Learning.

What is Augmented Reality (AR)? Give one example of its use.

What is Big Data? Mention any two characteristics of Big Data.

What is a communication medium? Explain the following types of communication media with examples:

a. Twisted pair cable
b. Coaxial cable
c. Optical fiber
d. Radio wave

Consider the following table named Employee:

Answer the following:

a. Which field should be used as the primary key? Give a reason.
b. Write an SQL command to display the names of employees working in the IT department.
c. Write an SQL command to increase Nabin's salary to 45000.
d. Write an SQL command to add a new employee with ID 104, name "Mina", department "Finance", and salary 32000.

What is multimedia? Explain the role of text, graphics, audio, and animation in multimedia presentations.

Study the following Python program and answer the questions:

def check_number(n):
    if n > 0:
        return "Positive"
    elif n < 0:
        return "Negative"
    else:
        return "Zero"

num = int(input("Enter a number: "))
print(check_number(num))

a. What is the name of the user-defined function?

b. What is the parameter of the function?

c. What will be the output if the user enters -8?

d. Rewrite the function to return "Even" if the number is even and "Odd" if it is odd.

AI and emerging technologies are changing education, healthcare, communication, and daily life.

a. Define Artificial Intelligence.

b. Differentiate between Artificial Intelligence and Machine Learning.

c. Explain one application of Generative AI.

d. Mention any one ethical issue related to AI and explain it briefly.