SEBA Class 10 Computer Science Question Paper Solved 2023, SEBA Class 10 Computer Science Question Paper Solved PDF Download, HSLC 2023 Computer Science Question Paper Solved 2023 to each Paper is Assam Board Exam in the list of SEBA so that you can easily browse through different subjects and select needs one. Assam Board HSLC 2023 Computer Science Previous Years Question Paper Solved can be of great value to excel in the examination.
SEBA Class 10 Computer Science Question Paper Solved 2023
HSLC Old Question Paper provided is as per the 2023 Assam Board Exam and covers all the questions from the SEBA HSLC 2023 Question Paper. Access the detailed SEBA Class 10 Computer Science Old Question Paper Solved provided here and get a good grip on the subject. Access the HSLC 2023 Computer Science Old Question Paper Solved, Class X Computer Science 2023 Old Paper Question Answer of English in Page Format. Make use of them during your practice and score well in the exams.
Computer Science
2023
COMPUTER SCIENCE OLD PAPER
ALL QUESTION ANSWER
1. Choose the correct answer:
(a) The command is used to determine your computer’s networking information, such as the IP address, address of its default gateway, etc.
(i) ping
(ii) host name
(iii) ipconfig
(iv) None of the above
Ans: (iii) ipconfig
(b) Which of the following properties are used with the <td> tag?
(i) text-align
(ii) vertical-align
(iii) padding
(iv) All of the above
Ans: (iv) All of the above
(c) The — Command is used to modify the table structure.
(i) ALTER
(ii) UPDATE
(iii) ALTER TABLE
(iv) MODIFY
Ans: (iii) ALTER TABLE
(d) Which of the following is an address operator?
(i) *
(ii) &
(iii) %
(iv) #
Ans: (ii) &
2. Fill in the blanks:
(a) In a computer network, ___________ can be shared among the connected computers.
Ans: In a computer network, Resources can be shared among the connected computers.
(b) ___________ are used to write notes about an HTML document.
Ans: Comments are used to write notes about an HTML document.
(c) A ___________ is a special variable that stores the address of another variable.
Ans: A Pointer is a special variable that stores the address of another variable.
(d) ___________ is used to fetch the data from the database.
Ans: SELECT is used to fetch the data from the database.
3. State whether the following statements are true or false:
(a) To delete a column in an existing Table, we can use the DELETE command.
Ans: False.
(b) The statement inside the while loop executes atleast once even if the condition is false.
Ans: True.
(c) An object(s) is/are user defined blueprint of prototype from which class is created.
Ans: False.
(d) A router is a network device that creates a wireless network.
Ans: False.
4. Answer the following questions in one word:
(a) It is a name of computer or any connected device in a computer network. What it is called ?
Ans: Hostname.
(b) It is a set of well established rules that determine how two computers communicate or transfer data between them. What it is called ?
Ans: Protocol.
(c) It is a simple design language intended to simplify the process of making web pages presentable. What it is called ?
Ans: CSS (Cascading Style Sheets)
(d) It is used when the items in the list are not required to be in specific order. What it is called ?
Ans: Set.
(e) These are some rules that helps ensure the validity of data while entering data into a table. What it is called?
Ans: Constraints.
(f) It is a tag used to create text box, radio button and check box on the webpage. What is the tag here called ?
Ans: <input>
(g) These commands are used to grant and take back authority from any database user. What is the language here called ?
Ans: SQL (Structured Query Language)
(h) It is defined as wrapping up of data and information under a single unit. What it is called ?
Ans: Encapsulation.
5. Answer the following questions:
(a) What do you mean by IP address? Write short notes on IP address.
Ans: IP address stands for “Internet Protocol address.”
The Internet Protocol is a set of rules for communication over the internet, such as sending mail, streaming video, or connecting to a website. An IP address identifies a network or device on the internet.
(b) What are the benefits of MAC address?
Ans: Because without a MAC address, there is no way for another computer to send a message to you alone. So you would receive all the messages on your network, and have to work out some way of deciding which are for you.
(c) What is the use of HTML formatting?
Ans: HTML Formatting is a process that allows us to format text to increase its visual appeal. We can use HTML text formatting tags to bold, italicize, and underlined text.
(d) What is the use of type attribute with an unordered list ?
Ans: The ‘type’ attribute is not used with unordered lists (<ul>). The ‘type’ attribute is typically associated with ordered lists (<ol>), where it defines the type of numbering or bullet style to be used.
(e) Explain the importance of tables in HTML.
Ans: The HTML table model allows authors to arrange data text, preformatted text, images, links, forms, form fields, other tables, etc. into rows and columns of cells. Each table may have an associated caption (see the CAPTION element) that provides a short description of the table’s purpose.
(f) Is it possible to add NULL and NOT NULL constraints to a table already loaded with data?
Ans: Yes, it is possible to add NULL and NOT NULL constraints to a table that already contains data.
(g) What are the characteristics by which one can determine the data type of ” MySQL?
Ans: We can determine the data type in MySQL with the following characteristics:
- The type of values (fixed or variable) it represents.
- The storage space it takes is based on whether the values are a fixed-length or variable length.
- Its values can be indexed or not.
- How MySQL performs a comparison of values of a particular data type.
(h) What do you mean by array? How to create/declare an array, give example ?
Ans: To create an array, define the data type (like int ) and specify the name of the array followed by square brackets []. To insert values to it, use a comma-separated list, inside curly braces: int myNumbers[] = {25, 50, 75, 100}; We have now created a variable that holds an array of four integers.
(i) What do you mean by library function ? Is sum() a library function ? is Justify.
Ans: Library functions in C are also inbuilt functions in C language. These inbuilt functions are located in some common location, and it is known as the library.
multiply(), sum() divide(), etc. are the user defined or user created function in a program. Example: printf(), sqrt(), strcpy(), etc.
(j) Why is dynamic memory allocation an efficient memory management technique?
Ans: One of the key advantages of dynamic memory allocation is the ability to allocate memory as needed, conserving resources and preventing wastage. It allows programs to adapt to changing requirements and handle variable-sized data structures efficiently.
(k) Why pointers are useful in C?
Ans: They are important in C, because they allow us to manipulate the data in the computer’s memory. This can reduce the code and improve the performance.
(l) Explain two features of OOP.
Ans: The main features of object-oriented programming (OOP) are encapsulation, inheritance.
Encapsulation: Encapsulation is a core concept in OOP where data and methods that operate on the data are bundled together within a class. It promotes information hiding, allowing objects to control access to their internal state.
Inheritance: Inheritance is a mechanism in OOP that allows a new class to inherit properties and behaviors from an existing class, fostering code reuse and establishing a hierarchical relationship between classes.
6. Answer the following questions:
(a) What is group function? Explain with an example.
Ans: Group functions are mathematical functions to operate on sets of rows to give one result per set. The types of group functions (also called aggregate functions) are: AVG, that calculates the average of the specified columns in a set of rows, COUNT, calculating the number of rows in a set.
(b) Write a C program to find the largest number among a series of numbers using an array.
Ans: #include <stdio.h>
int main() {
// Define the size of the array
int size;
// Prompt the user for the number of elements
printf(“Enter the number of elements: “);
scanf(“%d”, &size);
// Declare an array of the specified size
int numbers[size];
// Input numbers from the user
printf(“Enter %d numbers:\n”, size);
for (int i = 0; i < size; ++i) {
scanf(“%d”, &numbers[i]);
}
// Assume the first element is the largest
int largest = numbers[0];
// Iterate through the array to find the largest number
for (int i = 1; i < size; ++i) {
if (numbers[i] > largest) {
largest = numbers[i];
}
}
// Display the result
printf(“The largest number is: %d\n”, largest);
return 0;
}
(e) Can we have two functions with the same name but with different number of parameters in a single program ? Write a C program to justify your answer.
Ans: No, in C programming, you cannot have two functions with the same name even if they have a different number of parameters. Function overloading, where you define multiple functions with the same name but different parameter lists, is not supported in C.
#include <stdio.h>
#include <stdarg.h>
// Function with a variable number of arguments
int sum(int count, …) {
int result = 0;
va_list args;
va_start(args, count);
for (int i = 0; i < count; ++i) {
result += va_arg(args, int);
}
va_end(args);
return result;
}
// Function with a different number of parameters
int add(int a, int b) {
return a + b;
}
int main() {
// Example usage
printf(“Sum: %d\n”, sum(3, 1, 2, 3));
printf(“Addition: %d\n”, add(5, 7));
return 0;
}
7. Answer the following questions:
(a) What is target attribute ? What are the values of target attribute ?
Ans: In HTML, the “target” attribute is used to specify where the linked document should open when a user clicks on a link. It can be set to various values such as “_blank” to open in a new window or tab, “_self” to open in the same window, or “_parent” to open in the parent frame.
The value of the target attribute in the tag is the specified target window. Possible values include _self , _top , _parent , _new or any other valid name for a target window.
(b) Draw a flow chart for finding summation of integers using loop.
Ans:
(e) What is nested loop? Why do we use nested loops in our program ?
Ans: A nested loop is a (inner) loop that appears in the loop body of another (outer) loop. The inner or outer loop can be any type: while, do while, or for.
These loops are particularly useful when displaying multidimensional data. When using these loops, the first iteration of the first loop will initialize, followed by the second loop.
8. (a) Create a table ACTIVITY with ACT_Code as the primary key. Decide your own data types. Inset records as shown in the Table below and write the queries for the following:
| ACT_Code | ACT_Name | Place | Schedule_Date | Participants |
|---|---|---|---|---|
| A001 | High jump | Stadium 1 | 2022-12-01 | 12 |
| A002 | Long jump | Stadium 1 | 2022-12-01 | 15 |
| A003 | Shotput | Stadium 2 | 2022-12-02 | 10 |
| A004 | Discuss throw | Stadium 2 | 2022-12-02 | 14 |
| A005 | Football | Stadium 3 | 2022-12-03 | 20 |
Ans: Table Creation:
CREATE TABLE ACTIVITY (
ACT_Code VARCHAR(5) PRIMARY KEY,
ACT_Name VARCHAR(50),
Place VARCHAR(50),
Schedule_Date DATE,
Participants INT
);
Insert Records:
INSERT INTO ACTIVITY VALUES
(‘A001’, ‘High jump’, ‘Stadium 1’, ‘2022-12-01’, 12),
(‘A002’, ‘Long jump’, ‘Stadium 1’, ‘2022-12-01’, 15),
(‘A003’, ‘Shotput’, ‘Stadium 2’, ‘2022-12-02’, 10),
(‘A004’, ‘Discuss throw’, ‘Stadium 2’, ‘2022-12-02’, 14),
(‘A005’, ‘Football’, ‘Stadium 3’, ‘2022-12-03’, 20);
(b) Write a query for the following:
(i) Write a query to display the details of activities in ascending order of schedule date.
Ans: SELECT * FROM ACTIVITY ORDER BY Schedule_Date ASC;
(ii) Display the various places given in the table.
Ans: SELECT DISTINCT Place FROM ACTIVITY;
(iii) Display the details of ACT_Code A001 and A002.
Ans: SELECT * FROM ACTIVITY WHERE ACT_Code IN (‘A001’, ‘A002’);
(iv) Display the activity name (ACT_Name) that has participants in the range 10 to 15.
Ans: SELECT ACT_Name
FROM ACTIVITY
WHERE Participants BETWEEN 10 AND 15;
