SOLVED PABSON SEE PRE-QUALIFYING EXAM-2079 Subject: Opt. II Computer

 SOLVED PABSON

SEE PRE-QUALIFYING EXAM-2079

Subject: Opt. II Computer

 

Full Marks: 50

 

Candidates are required to write their answers according to the Time: 1:30 Hrs. instructions given.

 

Group 'A'

 

1. Answer the following questions in one sentence.                                   [6x1=6]

 

 

a) Write two examples of bounded media.

Ans: Any two examples of bounded media are Twisted Pair Cable and Fiber Optic Cable

 

b) Write two methods for hardware security.

Ans: Any two methods for hardware security are Insurance and Regular maintenance of computer hardware.

 

c) What is M-Commerce?

Ans: The online transactions through the wireless handheld devices such as mobile phone, laptop, palmtop, tablet, or any other personal digital assistant is called M-Commerce.

 

d) List two examples of DBMS.

Ans: Any two examples of DBMS are MS-Access and Oracle.

 

e) What is modular programming in Q-Basic programming?

Ans: Modular programming is a technique that divides a program into many small, manageable, logical and functional modules or blocks.

 

f) What is C language?

Ans: C language is a structured programming language that divides program into many functions.

 

2. Write the technical term for the following statements. [2x1=2]

 

a) The fake attempt to obtain sensitive information such as username, password by disguising oneself as a trustworthy entity. Phishing 

 

b) The technology to encode file or message. Encryption

 

3. Write the Full Forms of the following:                           [2x1=2]

 

 

a) URL - Uniform Resource Locator

 

b) ADSL - Asymmetric Digital Subscriber Line

 

 

 

Group 'B' [9x2=18]

4. Answer the following questions:

 

a) "Computer network reduces the operation cost". Justify the statement.

Computer Network reduces expenses of an office because computer on a network share different hardware devices like printers, scanners, hard disk etc. And sharing those hardware devices will reduces the expense of an office. For example if there are twenty computers in an office, now for printing the data there is no need to buy twenty printers individually rather than simple network the computer and connect the printer on the network which helps in sharing of the one printer among twenty computers which reduces the cost of buying nineteen printers individually.

 

b) What is computer security? Write two measures to protect it.

The security given to the computer for the protection of hardware, software and data from being lost or damaged due to accidental or intentional harm is known as computer security.

Any two measures to protect it are Insurance and Password.

 

c) What is e-governance? Write any two advantages of e- governance,

The use of ICT and its application by the government for the provision of information and public services to the people is called e-governance.

Any two advantages of e-governance are :

a)     Speed - Electronic technologies make communication better, and faster. It will take very less time for any policy, or scheme to reach to the people.

b)     Transparency - The use of e-governance helps make all functions of the business transparent.  All the information of each and every policy will be directly available to the citizens.

 

d) What is E-commerce? Write any two advantages of it.

Ecommerce refers to the buying and selling of goods or services using the internet.

Any two advantages of it are:

a)     It makes buying/selling possible 24/7.

b)     It makes buying selling procedure faster, as well as easy to find products.

 

e). How does IOT help in our daily life? Explain.

With the use of IOT, accessing information is easy; we can control a device that is miles apart in real time. Communication between the connected devices becomes more transparent and easier.

There are smartwatches and many other wearables that monitor our health conditions on a real-time basis. So if some medical urgency is needed such devices can initiate the necessary actions like alerting the family members, calling an ambulance, etc.

f) List any four data types of MS-Access. Also mention its function.

Any four data types of MS-Access are:
i) Text - It is used for storing text or combination of text and numbers. It can store up to 255 characters.
ii) Date/Time – Stores date and time
iii) Memo - It is used for storing lengthy text and numbers. It can store up to 65,535 characters.
iv) AutoNumber - Unique value generated by Access for each new record.

 

 

g) Define field and record in database.

Record is a collection of multiple related fields in a row which gives complete information about a person or thing. E.g.: Ram Chabahil 4468790

A column in a table is called field, and it contains a specific piece of information within a record. E.g.: Name, Address, Telephone

 

 

h) What is primary key? Write its importance.

A key that uniquely identifies each record in a database is primary key.

Its importance are:

To reduce and control duplication of record in a table.
iTo set the relationship between tables.

 

i) What is query in MS-Access? List different types of query in MS-Access.

Query is an object of Ms-Access which extracts and arranges information from a table in a manner that is specified.

The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and make-table query.

 

 

5. Write the output of the given program showing the dry table.                       [2]

 

 

DECLARE SUB series()

CLS

CALL series

END

 

SUB series()

A=11111

C=5

WHILE C>=1

PRINT A;

A=A\10

C=C-1

WEND

END SUB

 

 

 

Dry Run

Variable	Variable	Condition Check	Output
A	C	C>=1
11111	5	5>=1 Yes	11111  1111  111    11  1
1111	4	4>=1 Yes
111	3	3>=1 Yes
11	2	2>=1 Yes
1	1	1>=1 Yes
0	0	0>=1 No Loop Exits

 

Output

11111  1111  111    11  1

 

6. Debug the following program.

 

REM to store name, address in the file "store.dat"

CLS

OPEN "store.dat" FOR INPUT AS #1

DO

INPUT "Enter name"; name$

INPUT "Enter address"; address

WRITE name$, address$

INPUT "do you want to continue"; ans$

LOOP WHILE UCASE$(ans$)="Y"

CLOSE #2

END

 

Debugged program.

 

REM to store name, address in the file "store.dat"

CLS

OPEN "store.dat" FOR OUTPUT AS #1

DO

INPUT "Enter name"; name$

INPUT "Enter address"; address$

WRITE #1, name$, address$

INPUT "do you want to continue"; ans$

LOOP WHILE UCASE$(ans$)="Y"

CLOSE #1

END

 

 

 

7. Read the following program and answer the given questions: [2]

 

DECLARE SUB string(x$)

CLS

X$=“COMPUTER"

CALL string(X$)

END

 

SUB string(x$)

 L=LEN(X$)

FOR A = L to 1 step -2

PRINT MID$(x$.A,1);

NEXT A

END SUB

 

Questions:

 

a) What is the value of L in the above program?

Ans: The value of L in the above program is 8.

 

b) List the numeric and string variable in the above program.

Ans: Numeric variable = L, A

String Variable = X$,

 

Group C

 

 

8. Convert the following as indicated. [4x1=4]

 

i) (CAB)₁₆ into binary

 

 

ii) (767)₈ into decimal

i) (1110111)₂ + (1011)₂-(11)₂

 

 iv) (10111101)₂ ÷(101)

 

9. Answer the following questions: [4x2=8]

 

a) Write a program to calculate total surface area of a cylinder using function procedure and volume using sub procedure. [Hint: Total surface area-2 pr(h+r), Volume=pr²h]   [4]

 

DECLARE FUNCTION AREA(R, H)

DECLARE SUB VOL(R,H)

Cls

INPUT "Enter radius"; R

INPUT "Enter height"; H

PRINT AREA(R, H)

Call VOL(R, H)

END

 

FUNCTION AREA (R, H)

    AREA = 2 * 3.14 * R * (R + H)

END FUNCTION

 

SUB VOL (R, H)

    V = 3.14 * R ^ 2 * H

    PRINT "Volume of cylinder"; V

END SUB

 

b) A sequential data file "employee.dat" contains name, address, age and salary of employees. WAP to display all the information whose address is 'Kathmandu' and salary is greater than 50000.                        [4]

 

 

OPEN "employee.dat" FOR INPUT As #1

CLS

WHILE NOT EOF(1)

    INPUT #1, N$, A$, AG, S

    If UCASE$(A$) = "KATHMANDU" AND S > 50000 THEN

        PRINT N$, A$, AG, S

    END IF

WEND

CLOSE #1

END

 

 

10. Write a program in C programming to find the reverse of an input number. [4]

 

#include <stdio.h>

int main()

{

  int n, s = 0, r;

  printf("Enter any number: ");

  scanf("%d", &n);

  while (n != 0)

{

    r = n % 10;

    s = s * 10 + r;

    n /= 10;

  }

  printf("Reversed number = %d", s);

  return 0;

}

 

 

OR

 

 

Write a C program to input three different numbers and check whether the input number is positive, negative or zero. [4]

 

#include <stdio.h>

 

int main()

{

    int n;

        printf("Enter any number: ");

    scanf("%d", &n);

        if(n > 0)

        printf("Number is POSITIVE");

    else if(n < 0)

        printf("Number is NEGATIVE");

    else

        printf("Number is ZERO");

    return 0;

}