Class 12 Modern Computer Application 2020 Question Paper

 Table of contents

PART -B

Multiple Choice Question:                                       

1╳21=21
1. Select the correct alternatives from the alternatives

i . How many input combinations will be there to design a truth table of 4-input OR gate.
 a. 16        b..8        c. 24        d.32

ii. How many  bits are there in an output of an octal to binary encoder circuit?
a. 7        b. 8        c. 3        d. 15

iii. How many links are required to connect in n numbers of computers in a mesh topology?
a. n        b. n(n-1)/2       c. (n-1)        d. n(n-1)

iv. The first three bits of network ID in a class C type IP address is 
a. 011        b. 001      c. 110        d. 111

v.Which of the following tag is used to draw a horizontal line?
a. <HL>        b. <HR>      c. <LI>        d. <HI>

vi.  Which symbol is used to denote attribute in ER diagram?
a. Square        b. Diamond      c. oval        d. circle

vii. Which of the following is database constraints?
a. Primary key        b. Foreign key      c. Both a and b       d. None of these.

viii. Which of the following cannot be used to identify a tuple uniquely in a relation?

a. Super key        b. Primary key      c. Candidate key       d. Foreign Key.


ix. A valid cell address in MS Excel is which of the following is used to represent data of a table in MS Access ?

a. 8B        b. B8      c. 8B8        d. None of these.

x. Which of the following is used to represent data of a table in MS Access?
a. Form        b. Report      c. Data view Sheet        d. Design view.

xi. In which of the following tab of MS Access 2007 relationship option is there?

a. Home        b. Datasheet      c. Create        d. Database tools.


xii. Which of the following function used to convert fraction into an integer in MS Excel?

a. Count()       b. Average()      c. Now()        d. Round().


xiii. Which of the following is not an operation of a relational algebra?

a. Selection        b. Production     c. Set Difference        d. Union.


xiv. Record is also known as

a. Tuple    b. Degree    c. Attribute    d. Cardinality


xv. The function of data dictionary is

a. to store meta data        b. to reduce anomalies      c. to covert into another language       d. all of these.


xvi. To link two web pages in HTML the……………………….. tag is used. 

a. <link>        b. <A>      c. <HLINK>        d. <H>.


xvii. The tag which is used to make subscript in HTML?

a. <SUP>        b.<SUB>        c. <SUBC>        d.<SUBCPT>


xviii. The difference between highest frequency and lowest frequency of data transmission medium is known as
a.Wavelength    b. Bandwidth    c. Signal    d. Amplitude.

xix. Which of the following combinational circuit is used in ALU?
a. Adder    b. Multiplexer    c. Demultiplexer    d. Encoder

xx. In which of the following logic get the output will be 1 when both inputs are same?
a. NOR    b. NAND    c. XNOR    d. OR

xix. which of the following is universal logic Gate ?
a. AND    b. XOR    c. NOR    d. NOT





Short Answer Type Questions.


2. Answer the following questions in short 1╳14=14
i. What is the function of Demultiplexer?

ii. Write one difference between baseband and broadband network.

iii. Write two advantages of social networking.
OR
What is the significance of using password.

iv. What is the difference between container tag and empty tag.

v. What do you mean by database instance?
OR
State a feature of network data model.

vi. Define normalization.
OR
What do you mean by degree of a relation?

vii. Implement an  AND Gate using NOR Gate.

viii. Write the truth table of half sub tractor circuit.
OR
Write the truth table of 4 ╳ 1 multiplexer.

ix. Write down the full form of UDP.
OR
Write down the full form of MODEM.

x. What is search engine?
OR
Write the names of any two web browser.

xi. Write the syntax of if() function in MS Excel.

xii. Mention the default format of date in MS Access.
OR
What do you mean by query in MS Access?

xiii. What is the function of a <BR>tag in HTML?
OR
What is the function of attribute in HTML?

xiv. Write two attributes name of <body> tag in HTML.
OR
Write the syntax to make with of table border as 5. 


Click Here to Download Bengali Version PDF

Post a Comment

0 Comments