Saturday, 11 April 2020

CDC Model Set Solution 2077


Model Question paper
Group ‘A’
1.     Answer the following questions in one sentence. [6*1 = 6]
a.       What is search engine?
Ans: Search engine is a program that searches identifies items in a database that correspond to keywords.
b.       What is the business done through the internet?
Ans: Online Shopping, E-banking, E-Commerce.
c.       Which data type is used to store the numeric characters or special symbols in Ms-Access?
Ans; Text is used to store the numeric characters or special symbols in Ms-Access.
d.       Which view is used to modify a table in Ms-Access?
Ans: Design view is used to modify a table in Ms-Access.
e.       What is Modular programming?
Ans: Modular programming is a Programming language in which large program can divide in to small part or chunks.
f.        Write any two features of C-Language.
Ans:     1. It is middle level programming language.
            2. C language used variety of data type and powerful operators.
2.     Write appropriate technical term for the following. [2*1=2]
a.       Law that governs the legal issues of cyberspace.
Ans: Cyber Law
b.       The smallest unit to represent information in quantum computers.
Ans: Qubit (Bit)
3.       Write the full from of the following.                                         
i.                    STP = Shielded twisted pair cable
ii.                  WAP = Wireless Application protocol
Group ‘B’  
4.     Answer the following questions. [9*2 = 18]    
a.       What is computer network? Enlist any two advantages of it.
Ans: A interconnection group of computer used to share and communicate each other called computer network.
                        Advantages are;
                        1. It save cost by sharing storage or peripheral devices.
                        2. Data communication is fast.
b.       What is computer ethics? Write any two of them.
Ans: Moral norms and value should be followed by computer user called computer ethics.
            Any two computer ethics are:
            1. We should not use computer to steal other document
            2. We should not guess password of other computer.
c.       What is software security? Write any two measures of software security.
Ans: The measure used to protect computer software called software security.
            Two measures of software security are:
            1. We should put backup
            2. We should use updated antivirus.
d.       What is m-commerce? Write its two important services.
Ans: M-Commerce is the buying and selling of goods and services through wireless handheld devices such as mobile, tablets etc.
e.       What is IOT? Write any two importance of it.
Ans: IOT is short for Internet of things. Then internet of things refers to the ever-growing network of physical objects that features an IP address for internet connectivity and communication.
f.        What is database? Give any two examples.
Ans: Database is an organized collection of data, generally stored and accessed electronically from a computer system.
         Examples are:
         1. daily attendance
         2. Hospital registration
g.       What is primary key? List any two advantages of it.
Ans: Primary key is a type of field in database which is unique.
            Advantages:
            1. It does not accept null value
            2. It does not support duplicate value
h.       What is data sorting? List any two advantages of it.
Ans: Data sorting is a feature of database in which allow to arrange record in ascending or descending order.
            1. It help to make fast data searching
            2. It help to make systematic our database.
i.        What types of work is done in MS-Access using form and query object?
Ans:     In form we can view all data in record at once and we can input data.
            In query we can retrieve the data.         
5.       Write down the output of the following program. Shown with dry run in table.         [2]
DECLARE SUB SHOW(A)
CLS
N = 87
CALL SHOW(N)
END
SUB SHOW(A)
DO
B=A MOD 6+3
IF B MOD 4 = 0 THEN GOTO AA
PRINT B;
AA:
A = A – 10
LOOP WHILE A>=50
END SUB

Dry run table
A = N
B= A Mod 6+3
O/P
AA>=50
87
6

77
77
5

67
67
4
4
57
57
3

47
           
            Output is
                        4

6.       Re-write the given program after correcting the bugs.                                    [2]
REM to add records in an existing file
CLS
OPEN “Records.dat” FOR OUTPUT AS#1
AA:
INPUT : “Enter Name, Class and Roll No.”; Nm$, Cl, Rn
 INPUT #2,Nm$,Cl,Rn
INPUT “More Records”;Y$
IF UCASE(Y$) = “Y” THEN GOTO aa
CLOSE “Record.dat”
END

Ans:

REM to add records in an existing file
CLS
OPEN “Records.dat” FOR APPEND AS#1
AA:
INPUT : “Enter Name, Class and Roll No.”; Nm$, Cl, Rn
 WRITE #2,Nm$,Cl,Rn
INPUT “More Records”;Y$
IF UCASE$(Y$) = “Y” THEN GOTO AA
CLOSE #1
END

7.     Study the following program and answer the given questions.                        [2*1=2]
OPEN “Detail.dat” FOR INPUT AS#1
OPEN “Temp.dat” FOR OUTPUT AS#1
INPUT “Enter the name of students”; Sn$
FOR I=1 TO 10
INPUT #1,Nm$,Cl,A
IF Sn$ <> Nm$ THEN
WRITE #2,Nm$,Cl,A
END IF
NEXT I
CLOSE #1,#2
KILL “Detail.dat”
NAME “Temp.dat” AS “Detail.dat”
END

a.       What is the main objective of the program given below?
Ans: To delete user choice record from Detail.dat

b.       Do you get any problem in the above program if “Kill” statement is removed?
Ans: Temp.dat cannot rename with Detail.Dat

Group ‘C’
8.     Convert/Calculate as per the instructions.                              [4*1 =4]
i)                    (11001101)2= (?)16
Ans:    
BIN
1100
1101
HEX
C
D

ie. (11001101)2 = (CD)16
ii)                  (524)10 = (?)2
Ans:
2
524

2
262
0
2
131
0
2
65
1
2
32
1
2
16
0
2
8
0
2
4
0
2
2
0
2
1
0

0
1

            ie. (524)10 = (1000001100)2

iii)           (1010)2 +  (110)2 – (1011)2 = (?)2
Ans:  111100-1011
            = 101101
    1010
    x110
    0000
  1010
1010
111100

                       
    111100
  x1011
101101

iv)           (10110)2 / (101)2
101
 10110
100

-101


       10

            ie.         Q= 100
                        R = 10


9.       Write a program in QBASIC that asks length, breadth and height of a room and calculates its area and volume. Create a user defined function to calculate area and Sub-program to calculate volume.                                                      Hint : [ A = L*B], [V = L*B*H]
Ans:

DECLARE FUNCTION area(a, b)
CLS
            PRINT "Area of Room"
            INPUT "Enter length of room"; l
            INPUT "Enter breath of room"; b     
PRINT area(l, b)
END
FUNCTION area(p, q)
            LET A=p*q
            area = A
END FUNCTION


DECLARE SUB vol(a, b, c)
CLS
            INPUT "Enter length of room"; l
            INPUT "Enter breath of room"; b
            INPUT "Enter height of room"; h
CALL vol(l, b, h)
END
SUB vol(l, b, h)
            LET V = l*b*h
            Print "Volume of room is   : "; V
END SUB



10.   A sequential data file called “Record.txt” has stored data under the field heading Roll No, Name, Gender, English, Nepali, Maths and Computer. Write a program to display all the information of those students whose gender is ‘F’ and obtained marks in computer is more than 90.

OPEN “Record.txt” FOR INPUT AS#1
Print "Roll No", "Name", "Gender", "English", "Nepal", "Maths", "Computer"
Do While Not EOF(1)
            INPUT #1,Rn, N$, G$, E, Ne, Ma, Co
IF Ucase$(G$)="F" and Co>90 THEN
Print Rn, N$, G$, E, Ne, Ma, Co
END IF
WEND
CLOSE #1
END



11.   Write a program in C language that asks a number and check whether it is odd number or even.
Ans:
            #include <stdio.h>
            {
                        int n;
            Print f("Enter an interger\n");
            scanf (%d", &n);
                        if (n%2==0)
                                    printf ("Even\n");
                        else
                                    printf ("Odd\n");
                        return 0;
            }
OR
Write a program in C language to display the series with their sum 1,2,3,4,…. Up to 10th term.

                        #include <studio.h>
                        void main( )
                        {
                                    int i;
                                    printf("The first 10 natural numbers are: \n");
                                    for (i=1; i<=10;i++)
                                    {
                                                printf(%d ", i);
                                    }
                        printf("\n");
                        }

No comments:

Post a Comment

MCQ Question Bank Microsoft PowerPoint