SEE -2081 COMPUTER SCIENCE SOLVED

         SEE SOLVED SET -2081 COMPUTER

Answer the following questions in one sentence                                      6 x 1=6

1. What is telecommunication?

Telecommunication is the transmission of information over a distance using electronic means, such as telephone, radio, television, and the internet.

2. Give any two examples of simplex mode.

Television Broadcasting

Radio Transmission

3. Write two methods of creating a table in MS-Access.

Using Design View .

Using Datasheet View

4. What is the maximum character limit for a field name in MS-Access?

The maximum character limit for a field name in MS-Access is 64 characters.

5. Write the syntax of the KILL statement in QBASIC

KILL "filename.ext"

6. Write two keywords used in C language.

1.     int

2.     return

2.Write appropriate technical term for the following                         2

1. What do we call websites that search documents for keywords?

Search Engines.

2. What is the recording of interaction with the digital world?

Digital Footprint.

3. Write the full forms of the following question              ( 2)

UPS – Uninterruptible Power Supply

VR – Virtual Reality

 

                   Group B

     4. Answer the following questions:                                    (9 x2=18)

1. Define cyber law and list one do’s and don’ts of cyber ethics.

Cyber law refers to the laws that govern activities on the internet, including cybersecurity, privacy, and digital transactions.

Do’s of Cyber Ethics:

Use strong passwords and protect personal information.

Don’ts of Cyber Ethics:

 Do not engage in hacking or cyberbullying.

 

2. Define antivirus software and give two examples.

Antivirus software is a program designed to detect, prevent, and remove malicious software (malware) such as viruses, spyware, ransomware, and trojans. It helps protect computers and networks from security threats.

Examples:

Avast Antivirus

Norton Antivirus

 

3. Why is e-commerce more popular than traditional commerce? (Two reasons)

E –commerce is more popular than traditional commerce Customers can shop online anytime and from anywhere, avoiding physical store visits, making the process time-efficient.

 Businesses can reach a global audience without requiring physical stores, increasing their customer base and revenue potential

 

.4. What is e-governance? Provide two examples of e-governance services in Nepal.

E-governance refers to the use of information and communication technology (ICT) by the government to provide services, information, and facilitate communication with citizens, businesses, and other government agencies. It enhances transparency and efficiency in government operations.

Examples in Nepal:

Online PAN registration – Issued through the Inland Revenue Department (ird.gov.np) for tax purposes.

Driving License Application – Managed by the Department of Transport Management (doit.gov.np) to streamline license issuance.

5. What is a database? Name two data types used in MS-Access.

A database is a structured collection of related data stored electronically to facilitate easy access, management, and retrieval. It helps in organizing large amounts of data systematically.

Data Types in MS-Access:

Text – Stores short alphanumeric data (e.g., names, addresses), allowing up to 255 characters.

Number – Stores numerical values (e.g., age, price, quantity) and supports different number formats.

 

6. What is the difference between Field and Record? (Two differences)

Field	Record
A field is a single column of data representing a specific attribute (e.g., Name, Age).	A record is a complete row of data, containing multiple fields (e.g., John, 25).
It represents a specific type of information within a table.	It represents a single entry in a table, consisting of multiple fields.

7. Define a report. Why is it necessary in DBMS?

A report is a formatted and structured output of database queries, often used for analysis, presentation, and decision-making. It is necessary in DBMS as it summarizes large data for better interpretation and decision-making and it facilitates easy sharing of organized data with stakeholders, improving communication and transparency.

 

 

8. What is a query? Mention different types of action queries.

A query is a request made to a database to retrieve, update, or manipulate specific data based on given conditions. Queries help users filter and manage large datasets efficiently.

Types of Action Queries:

Append Query

Delete Query

Update Query

Make Table Query

 

 

5. Write down the output of the given program show them in dry run table.          2

DECLARE SUB Display (TS)

TS="COMPUTER"

CALL Display (TS)

END

 

SUB Display (TS)

FOR C=1 TO LEN(TS) STEP 2

    DS=MID$(TS,C,1)

    PRINT DS;

NEXT C

END SUB

 

Dry Run Table:

C	D$ =(MID$(TS,C,1))	Output
1	C	C
3	M	M
5	U	U
7	E	E

Final Output:

C M U E

6. Rewrite the given program after correcting the bugs                                          2

REM to add record in an existing file.

OPEN "student.dat" FOR OUT AS #2 

TOP:

INPUT "Enter Name, Class and Roll No.: "; SName$, C, RN 

INPUT#2, SName$, C, RN 

INPUT "More records"; Y$ 

IF UCASE$(Y$) = "Y" THEN GOTO POP 

CLOSE #2 

STOP 

After debugging

 

REM To add record in an existing file

OPEN "student.dat" FOR APPEND AS #2

TOP:

INPUT "Enter Name, Class and Roll No:"; Name$, C, RN

WRITE #2, Name$, C, RN

INPUT "More records"; Y$

IF UCASE$(Y$) = "Y" THEN GOTO TOP

CLOSE #2

END

     Group C

Convert/Calculate as per the instruction:                              4 x 1 = 4

(i)(1503)₈=(?)₁₆

(ii) (101000101)₂=(?)₈

iii) (1010+1101)₂−(110)₂

iv) (100111)₂ ÷(110)₂

 

 

9.A Write a program in QBASIC that asks length, breadth, and height of a room and calculate its perimeter and volume.Create a Function procedure to calculate perimeter and Sub procedure to calculate volume [Hint: volume= LXBXH and Perimeter= 2(L+B)                                                4 x 2= 8

DECLARE FUNCTION Perimeter(L, B)

DECLARE SUB Volume(L, B, H)

CLS

INPUT "Enter Length: ", L

INPUT "Enter Breadth: ", B

INPUT "Enter Height: ", H

PRINT "Perimeter = "; Perimeter(L, B)

CALL Volume(L, B, H)

END

FUNCTION Perimeter(L, B)

    Perimeter = 2 * (L + B)

END FUNCTION

 

SUB Volume(L, B, H)

    V = L * B * H

    PRINT "Volume = "; V

    END SUB

B. Write a program to read data from the sequential data file "std.dat" which contains:

Student's name, Roll No.Marks of English, Nepali, Maths, and Computer and display the result with all the information of those students whose marks in Computer are more than 40.                     4

 

OPEN "std.dat" FOR INPUT AS #1

DO WHILE NOT EOF(1)

    INPUT #1, Name$, Roll, Eng, Nep, Maths, Comp

    IF Comp > 40 THEN

        PRINT Name$, Roll, Eng, Nep, Maths, Comp

    END IF

LOOP

CLOSE #1

10 Find the greatest number among any two different input numbers.       4

#include <stdio.h>

int main() {

    int a, b;

    printf("Enter two numbers: ");

    scanf("%d %d", &a, &b);

    if(a > b)

        printf("%d is greater\n", a);

else

 

        printf("%d is greater\n", b);

    return 0;

}

OR

 

(ii) Display the series: 5, 10, 15, 20, ...... up to the 15th term.

 

#include <stdio.h>

 

int main() {

    int i;

 

    for (i = 1; i <= 15; i++) {

        printf("%d ", 5 * i);

    }

 

    return 0;

}

 

 

http://www.milanbaral123.blogspot.com