WBBHSC Class 12 Modern Computer Application Higher Secondary Examination 2019

WBBHSC Class 12 Modern Computer Application Higher Secondary Examination 2019

Time: 3 Hours 15 Minutes

(First 15 Minutes for reading the question paper only, 3 Hours for writing) 

Full Marks – 70

PART – B [Mark-35]

1. Select the correct answer from the alternatives : [1 × 21 = 21]

(i) What can be the maximum length of a text field in MS-Access?—

1. 120
2. 255
3. 265
4. 75

(ii) Cell border is given by which of the following group in MS-Excel?—

1. Font
2. Style
3. Cells
4. Alignment

(iii) By default how many worksheets are there is a workbook?—

1. 2
2. 5
3. 3
4. 8

(iv) Which one of the following is not a DML statement?—

1. DELETE
2. UPDATE
3. INSERT
4. ALTER

(v) Which one of the following is not a relational algebra operation—

1. Selection
2. Production
3. Union
4. None of these

(vi) In which data model of Database, is the parent-child relationship found?—

1. E-R model
2. Network model
3. Hierarchical model
4. Relational model

(vii) In E-Rdiagram, entity is implemented by using—

1. Square box
2. Triangular box
3. Rectangle box
4. Ellipse

(viii) In DBMS, the characteristics of an Entity is known as—

1. Degree
2. Cardinality
3. Attribute
4. Domain

(ix) In a particular moment, the overall data of a database is known as—

1. Record
2. Data vault
3. Instance
4. Data structure

(x) Which attribute of the list tag is used to select the style of numbering in an ordered list?—

1. Type
2. Style
3. Start
4. Format

(xi) Which of the following is a default data type in MS-Access?—

1. OLE object
2. Text
3. Number
4. Currency

(xii) tag is used for underlining text in HTML.—

1. <U>
2. <UD>
3. <UL>
4. <I>

(xiii) Which of the following tag is used to move a text ill HTML?—

1. <P>
2. <MQ>
3. <Marquee>
4. <Move>

(xiv) In E-mail, the ‘cc’ feature stands for—

1. Clone copy
2. Carbon copy
3. Cut copy
4. Contact copy

(xv) In which topology, point to point connection is used?—

1. Star
2. Ring
3. Tree
4. All of these

(xvi) In which type of transmission, start bit and stop bit are used?—

1. Synchronous
2. Asynchronous
3. Parallel
4. None of these

(xvii) The number of selection lines in 8 : 1 MUX is—

1. 2
2. 3
3. 4
4. 5

(xviii) If both inputs of a half adder are ‘1’ them the sum and carry will be —

1. 1, 0
2. 0,1
3. 1, 1
4. 0, 0

(xix) What will be the output of a 2-input XNOR gate with inputs A and B?—

1. AB
2. \overline{AB} + A.B
3. A\overline{B} + \overline{A} B
4. A + B

(xx) The value of F is—

1. \overline{AB}
2. A + S
3. \overline{A} + \overline{A}
4. A. B

(xxi) How many NAND gates are required to make an OR gate using NAND gates?

1. 3
2. 4
3. 5
4. 2

2. Answer the following questions in short (Alternatives are to be noted): [1 × 14 = 14]

1. Draw the block diagram of a 4 x 1 MUX. Or; Draw the block diagram of a 2 x 4 decoder.
2. Write the full form of CSMA / CD. Or; Write two features of BUS topology.
3. How many parts are there in an a-mail ID and what are those?
4. Write a function for each of <HR> and <P> tag in HTML. Or; Write the syntax to make the height of ‘Picture 1. jpg’ as 200.
5. What is the function of the ‘Rowspan’ attribute? Or; What is the function of cell padding in HTML?
6. What is the Alternate key?
7. What do you mean by Wizard in MS-Access? Or; What is the use of the ‘Memo’ data type in MS-Access?
8. Construct a XOR gate using basic logic gates.
9. What will be the maximum value of the output of a 4-bit adder circuit? Oi; How nany output lines are there in a Decimal to Binary encoder?
10. What is the function of Repeater? Or, What is Protocol?
11. What do you mean by computer virus? Or; What is Firewall?
12. “The Gateway of India is Mumbai.”
    Write the syntax in HTML to display the following line as heading in smallest display the following line as heading in smallest size.
    “The Gateway of India is established in Mumbai.”
    Or; Write the syntax in HTML to represent the text .‘O₂’
13. What do you mean by weak entity?
14. Write the syntax of lower () function in MS-Excel. Or, Write the syntax to find out the average among 10, 20 and 30 in MS-Excel.

PART – A [Marks: 35]

Answer the following questions (Alternatives are to be noted) : [7 × 5 = 35]

Question 1

1. Derive the logical expressions for sum and carry off a full adder circuit and draw the logic diagram.
2. Draw the circuit diagram of 4 x 1 MUX
3. Write two differences between MUX and DeMUX. (2 + 1) + 2 + 2

Or;

1. Write the truth table of Octal to Binary encoder and also draw the circuit diagram.
2. Draw the circuit diagram of 2 x 4 decoder.
3. Draw the circuit diagram to make a full subtractor using half subtractor. (1 + 2) + 2 + 2

Question 2

1. How many types of Text or Paragraph Alignment are there in HTML and what are those?
2. What is the function of FRAMESET tag in HTML? Mention any two attributes of this tag.
3. State one use of the anchor tag in HTML. (I + 1) + (2 + 2) + 1

Or;

Write the code to create a web page using HTML where the following features will be shown :

(a) Give the title of the web page as ‘Project Work in HTML’.

(b) Make the following table in that web page:

(c) Giva a caption at the bottom of that table sa ‘Project Topics’ 1 + 5 + 1

Question 3

Consider the following table :

employee {e_id, name, age, salary}

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

1. Show the record of those employees whose surname is ‘Baneijee’.
2. Show the name and salary of that employee whose age is between 50 and 60.
3. Arrange the records of all employees according to their salary in ascending order. 2 + 3 + 2

Or,

1. Explain the ‘Cartesian product’ and ‘Natural join’ operation with example.
2. Define referential integrity with example.
3. What is the purpose of AND operator in SQL? (2 + 2) + 2 + 2

Question 4

1. What is the advantage of Auto Fill? Explain with an example.
2. What is conditional formatting?
3. How can you change the name of a worksheet in MS-Excel? Explain. (2 + 1) + 2 + 2

Or,

1. In MS-Excel, write the formula to check Pass’ or ‘Fail’ In a subject (Note that the pass mark is ‘30’ and the subject market should be taken from A4 cell).
2. Write the steps to make a pie chart in MS-Excel.
3. What is the purpose of the Autosum feature in MS-Excel? 2 + 3 + 2

Question 5

1. Write the steps of creating a table named ‘Student’ using Design view in MS-Access. Write the name of two fields with data type or mai table.
2. What is the purpose of using an Input Mask for a field in MS-Access?
3. Write the steps for deleting a field in MS-Access. (2 + 2) + 2 + 1

Or

1. Write the procedure to make an Auto report is MS-Access.
2. Write two differences between ‘Select Query’ and ‘Cross tab query’. 4 + (1½ + 1½)