Model Questions Solution (III)

Group A – Computer Fundamental – 22 marks

1) Answer the following question [5×2=10]

a. Differentiate between star and bus topology?

Ans: In a star topology, all devices are connected to a central hub or switch, whereas in a bus topology, all devices are connected to a single backbone cable.

b. Distinguish between email and traditional postal service.

Ans: Email is a digital communication method allowing the exchange of messages electronically, while traditional postal service involves physical delivery of letters or packages via mail carriers.

c. Write any four ill-effects of computer virus.

Ans: Computer viruses can cause data loss, system crashes, steal sensitive information, and spread to other systems

d. Write any four software security measures.

Ans: Software security measures include encryption, regular software updates, access control, and intrusion detection systems.

e. How can we use multimedia in education. Explain?

Ans: Multimedia can be used in education to enhance learning through various media formats like audio, video, animations, and interactive presentations, catering to different learning styles and making learning more engaging and effective.

2) a. Convert as instructed [2×1=2]

1. (8797)16 into Decimal

Ans: (8797)₁₆ into Decimal = 35,067

2. (753)8 into Hexadecimal

Ans: (753)₈ into Hexadecimal = 3AB

b. Perform the binary calculation [2×1=2]

1. (1000)2-(111)2 

Ans: (1000)₂ – (111)₂ = (1001)₂

2. (1010)2 /(10)2 

Ans: (1010)₂ / (10)₂ = (101)₂

3) Match the following [4×0.5=2]

Bandwidth                      ISP

Internet                           POP

Protocol                         bps

Hardware security        NAV

                                        CVT

Ans:

• Bandwidth – bps
• Internet – ISP
• Protocol – POP
• Hardware security – NAV

4) Choose the correct answer [4×0.5=2]

a. Which is not a guided media?

1. UTP cable
2. STP cable
3. Satellite
4. Fiber optics

Ans: Satellite

b. Which device is necessary to operate internet.

1. CD-ROM
2. CCTV
3. MODEM
4. ALL

Ans: MODEM

c. MODEM convert  …..

1. Sound into digital
2. Digital signal into sound
3. Both 1 and 2
4. None of the above

Ans: Digital signal into sound

d. Which is not an Internet service.

1. e-mail
2. IRC
3. ISP
4. e-commerce

Ans: CCTV

5) Give appropriate technical terms of the following [4×0.5=2]

• Making extra copy of data or program.

Ans: Backup

• A card used to connect network cable to computer.

Ans: Network Interface Card (NIC)

• Device used for power protection.

Ans: Uninterruptible Power Supply (UPS)

• Program used to detect and eliminate computers virus.

Ans: Antivirus software

6) Write full form [4×0.5=2]

1. Wi-Fi
2. UPS
3. TCP/IP
4. UTP

Ans:

Wi-Fi – Wireless Fidelity

UPS – Uninterruptible Power Supply

TCP/IP – Transmission Control Protocol/Internet Protocol

UTP – Unshielded Twisted Pair

Group B – DBMS – 10 marks

7) Answer the following questions. [3×2=6]

1. Differentiate between database and DBMS.

Ans: A database is a structured collection of data, while DBMS (Database Management System) is software used to manage, manipulate, and interact with databases.

2.Define primary key. Write its importance?

Ans: A primary key is a unique identifier for each record in a database table, ensuring data integrity and enabling efficient data retrieval.

3. What is query? Write its important.

Ans: A query is a request for information from a database, enabling users to retrieve specific data meeting certain criteria.

8) Stare whether the following statements are true or false [4×0.5=2]

a. Primary key does not accept null value. ( True)

b. The extension of database file created by MS-Access is BDF. ( False)

c. Memo data type can be indexed. (True)

9) Match the following [4×0.5=2]

Primary key                      Formatted output

OLE                                   Interface

Form                                 64,000 characters

Report                              Unique field

                                          Picture

Ans:

Primary key – Unique field
OLE – Picture
Form – Interface
Report – Formatted output

Group C – QBASIC programming – 18 marks

10) Answer the following. [3×1=3]

1. What is user define function?

Ans: User-defined function is a function created by the user to perform a specific task, extending the functionality of the programming language.

2. Write any two data types used in C language?

Ans: Two data types used in C language are int (integer) and float (floating-point number).

2.Write the function of following statements. NAME, SHELL

Ans: In QBASIC, NAME is used to assign a name to a program or subroutine, and SHELL is used to execute operating system commands from within a QBASIC program.

11) Debug the given program. [2]

DECLARE FUNCTION reverse$(N$)
INPUT “Any String”; N$
X$ = reverse$(N$)
PRINT N$
END
FUNCTION reverse(N$)
L = LEN$(N$)
FOR X = L to 1 STEP – 1
A$ = MID$(N$, X, I)
B$ = B$ + A$
NEXT X
B$ = reverse$(N$)
END FUNCTION

Ans: Here’s the debugged version of the program:

DECLARE FUNCTION reverse$(N$)

INPUT "Any String"; N$
X$ = reverse$(N$)
PRINT X$
END

FUNCTION reverse$(N$)
    L = LEN(N$)
    FOR X = L TO 1 STEP -1
        A$ = MID$(N$, X, 1)
        B$ = B$ + A$
    NEXT X
    reverse$ = B$
END FUNCTION

12) Write the output of the following program. [2]

DECLARE SUB series ()
CALL series
END
SUB series
X = 1
FOR K = 1 TO 4
    PRINT X;
    X = X + K
NEXT K
END SUB

Ans: The output of the program would be:

1 2 4 7 11

13) Read the given program and answer the given question. [2]

DECLARE SUB SUM (N)
N = 5
CALL SUM (N)
END
SUB SUM (N)
FOR X = 1 TO N
S =S  + X
NEXT X
PRINT S
END SUB

a) In the above program, how many times does the FOR ………..NEXT loop executes?

Ans: The FOR…NEXT loop executes 5 times, as determined by the value of N which is set to 5 before calling the SUM subroutine.

   b) Write the name of the procedure used in the above program.

Ans: The name of the procedure used in the above program is SUM.

14) a) Write a program to calculate the average of three numbers using FUNCTION procedure. [3]

Ans: Program to calculate the average of three numbers using FUNCTION procedure:

FUNCTION CalculateAverage(num1, num2, num3)
    CalculateAverage = (num1 + num2 + num3) / 3
END FUNCTION

CLS
INPUT "Enter first number: ", num1
INPUT "Enter second number: ", num2
INPUT "Enter third number: ", num3

average = CalculateAverage(num1, num2, num3)
PRINT "The average of the three numbers is: "; average

b) Write a program to print the total number of vowel alphabets present in the given word using SUB procedure. [3]

Ans: Program to print the total number of vowel alphabets present in the given word using SUB procedure:

SUB CountVowels(word)
    vowels = "aeiouAEIOU"
    count = 0
    FOR i = 1 TO LEN(word)
        letter = MID$(word, i, 1)
        IF INSTR(vowels, letter) THEN
            count = count + 1
        END IF
    NEXT i
    PRINT "Total number of vowels in the word "; word; " is "; count
END SUB

CLS
INPUT "Enter a word: ", inputWord
CALL CountVowels(inputWord)

c) A data file “STAFF.dat” has stored records of few employees with EMPID, First name, last name, post and salary. Write a program to display all the records of the employees whose salary is more than 40,000 [3]

Ans: Program to display all the records of the employees whose salary is more than 40,000 in QBASIC:

OPEN "STAFF.dat" FOR INPUT AS #1

DO WHILE NOT EOF(1)
    INPUT #1, EMPID, firstName, lastName, post, salary
    IF salary > 40000 THEN
        PRINT EMPID, firstName, lastName, post, salary
    END IF
LOOP

CLOSE #1