HS 2023 MODERN COMPUTER APPLICATION Question Paper WBCHSE

 HS 2023 MODERN COMPUTER APPLICATION

( ENGLISH VERSION )

The questions related to MCQ and SAQ should be answered in the specific printed TABLE accordingly in the Answer Script.

( Multiple Choice Type Questions )

1. Select the correct answer from the alternatives :             1x21=21

What will be the value of Fin the above diagram ?

a) A+B                    b) A+B

c) AB                      d)AB

(ii)  What will be the two input of a NOR gate when the output is high ?

a) 1, 0            b) 1, 1   c) 0, 0    d) 0, 1

(iii) Which o f the following is an universal logic gate ? 

(a) AND (b) XOR (c) NOR (d) NOT 

(iv) The number o f output line o f an Octal to Binary encoder is 

(a) 8     (b) 4     (c) 3     (d ) 10

(v) The number of selection line in '4 x 1 MUX’ is 

(a) 1     (b) 2     (c) 4     (d) 3 

(vi) Which of the following is an example of Half duplex mode 

(a) Telephone     (b) Walkie-talkie     (c) Radio broadcasting     (d) Television 

(vii) Which o f the following network topology uses server ? 

(a) Ring     (b) Mesh     (c) Star     (d) Bus

 (viii) The first page o f a website is called 

(a) Design page     (b) Home page     (c) First page     (d) Main page 

(ix) Which of the following option is used to select the type of a text or a character in HTML document? 

(a) <FONT>     (b) <FONT STYLE>     (c) <FONT FACE>     (d) <FONTTYPE>

(x)  Which of the following tag is used to add hyperlink in HTML?

(a) <HR>     (b) <BR>     (c) <A>     (d)     <B>

(xi) What is the default extension of a HTML document ? 

(a) .html (b) .htm     (c) Neither   (a) nor (b)     (d) Both (a) and (b) 

(xii) Full form of DML is

 (a) Data Multipurpose Language         (b) Data Manageable Language 

 (c) Data Manipulation Language         (d) Data Modulation Language 

(xiii) Each and every row of a table in Relational Model is known as

 (a) Domain     (b) Degree     (c) Tuple     (d) Attribute 

(xiv) Which symbol is used to represent an entity in ER diagram ?

 (a) Rectangale     (b) Ellipse     (c) Triangle     (d) Diamond box

(xv) Which of the following is an appropriate example of a  database ?

 (a) Magazine     (b) Story book     (c) Newspaper         (d) Telephone directory 

(xvi) “A teacher teaches many students in a class.” Which relationship is defined in the above statement? 

(a) 1 : 1     (b) 1 : N     (c) N : M     (d) None of these 

(xvii) Which of the following symbol is used to represent Cartesian product operation in relational algebra ? 

(a) π       (b) σ     (c) x       (d) ⋈

(xviii) Which of the following is not a logical function of MS-Excel ?

 (a) AND         (b) OR         (c) NOT         (d) NOW 

(xix) .......... . types of cell MS-Excel 2007. referencing are there in

(a) 5     (b) 2     (c) 3     (d)4

(xx) Which of the following is not an object of MS-Access 2007 ?

 (a) Report     (b) Application     (c) F orm     (d) Query 

(xxi) Which data type can be used instead of Text data type in  MS-Access ?

(a) Character     (b) Memo     (c) OLE object     (d) Number 

( Short Answer Type Questions )

2. Answer the following questions in short ( Alternatives are to be noted ) : 

                                                                                                                            1 x 1 4 = 1 4 

(i) Construct an AND gate using NOR gate.

 (ii) Draw the block diagram of 2 x 1 MUX.

                        OR

Write the truth table of 1 x 2 De-MUX.

 (iii) What is two-level circuit ?

                OR

Why multiplexer is called data selector ?

(iv) Write the difference between half-duplex and full-duplex communication mode.

                    OR

Write the structure of class C address in IPv4 addressing of internet.

(v) How many links are needed to construct a Mesh topology with 10 computers ? 

(vi) What is Firewall ?

        OR

Write the structure of E-mail Id.

 (vii) Write two examples of search engine. 

(viii) How can you break a line in HTML ? 

                 OR

Write the syntax of <OL> tag in HTML. 

(ix) Which tag is used to Bold a text in HTML ? 

(x) How many types of paragraph alignments are there in HTML and what are those ?

        OR

Write the full form of HREF.

(xi) What is candidate key ?

                OR

What do you mean by database instance ? 

(xii) What is cardinality in a relation ?

                OR

Define data dictionary. 

(xiii) What is the address of last column in MS-Excel ?

                    OR

What is the role of concatenate function in MS-Excel ? 

(xiv) What is the function of lookup wizard in MS-Access ?

                    OR

What is the use of show table dialog box in MS-Access ?

( Subjective / Descriptive Type Questions )

 3. Answer the following questions (Alternatives are to be noted) :

                                                                                                                                            7 x 5 = 35

(a) Derive the logical expressions for difference and borrow of a full subtractor circuit using truth table and also draw the logic diagram.

b)Draw the circuit diagram of a 1 x 4 De-MUX. 

                                                                                                                                                   ( 2 + 2 ) + 3

OR

a)Write the truth table of 3 to 8 decoder and also draw the logic diagram of it.

b)Write two differences between Decoder and Encoder. 

c) Construct a Full Adder by using two Half Adder.

                                                                                                                    ( 1½ +1 ½) + 2 + 2

4. a) Which tag is used to make a text as heading in HTML ? How many types of it and what are those ?

b) Write the syntax to insert a picture named ‘Picture-1.JPG’ in a webpage.

c) Write the name of any two attributes and their functions of ‘BODY’ tag in HTML. 

                                                                                                                                2 + 2 + 3

                            OR

a)Write the purpose of the following tags in HTML :

 (i) <FONT> (ii) <HR> 

b)Write the HTML codes to subscript and superscript of a  text.

c) Write the difference between container tag and empty tag. 

                                                                                                                                3 + 2 + 2

5.  Explain with example :

    a)Cartesian product

    b)Selection

    c) Projection.                                                                                                             3 + 2 + 2

                            OR

    Look at the following table :

    Product (Pid, Pname, Price, Company)

Pid	Pname	Price	Company
P001	TV	15000	LG
P002	AC	40000	Voltas
P003	Refrigerator	20000	Samsung
P004	Microwave oven	16000	LG
POO 5	Washing machine	30000	LG

 

 

Write the SQL query and give output to do the following tasks :

(a) Show the name and price of the product whose prices are more than 20000.

b)  Show the details of the product whose manufacturing company is ‘LG’.

C) Arrange the records of all products according to their price in ascending order. 

                                        (l + l) + (l + l) +  ( 1½ +1 ½)

6.    a) Write the steps to perform cell merge operation in MS Excel 2007.

       b) Write the purpose of TODAY ( ) and COUNT IF ( ) functions.  

                                                                                                3 + ( 2 + 2 )

                        OR

(a)  What do you mean by cell range in MS Excel ? Give example.

(b)  How can you insert a new worksheet in MS Excel ?

(c) Write a short note on relative cell reference.

                                                                                                            ( 1 + 1 ) + 2 + 3

7.    (a) Write two differences between Design view and Datasheet view in MS-Access.

         (b) Write the procedure to make the relationship between two tables in MS-Access.

         (c) Write two advantages of making ‘Report’ in MS-Access

                                                                                                                    2 + 3 + 2

                        OR

(a)  Write the procedure to make an Auto dorms in MS - Access.

(b)  Write two different between 'Select Query' and 'Cross tab Query'

(c) Write the function of 'OLE Object ' and 'Memo data type in MS- Access .

                                                                                                                3+2+2

Click here to Download WBCHSE HS 2023 Modern Computer Application Question paper In Bengali