WBBHSC Class 12 Modern Computer Application Higher Secondary Examination 2018

WBBHSC Class 12 Modern Computer Application Higher Secondary Examination 2018
WhatsApp

WBBHSC Class 12 Modern Computer Application Higher Secondary Examination 2018

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) In a 2-input XOR gate, one input is variable x. What value should be set to the other input of the gate so that the output is always x?—

  1. x
  2. 1
  3. 0
  4. All of these

(ii) ‘Parallel electric switches’ in a circuit is an example of—

  1. logical AND
  2. logical NOT
  3. logical OR
  4. none of these

(iii) Which of the following device converts analogue signal to digital signal and digital signal to analogue signal?—

  1. Repeater
  2. Switch
  3. Modem
  4. Hub

(iv) Which attribute of the table tag in HTML is used to add space in between adjacent cells of a table?—

  1. Cell spacing
  2. Cell margin
  3. Cell padding
  4. Cell width

(v) How many types of heading tags are there in HTML?—

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

(vi) RAW facts and figures are called—

  1. Data
  2. Information
  3. Snapshot
  4. Tables

(vii) Each row of a database table is known as—

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

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

  1. Primary key
  2. Candidate key
  3. Foreign key
  4. None of these

(ix) Which one of the following syntax is correct?—

  1. SUM (A1-A5)
  2. SUM (Al $ A5)
  3. SUM (A1;A5)
  4. SUM (Al: A5)

(x) Which of the following option is used to run multiple commands as a group in MS- Access?—

  1. Form
  2. Pages
  3. macro
  4. Report

(xi) We can store an image as a data item in a table in MS-Access using _____ data type—

  1. Memo
  2. Hyperlink
  3. OLE object
  4. Look up wizard

(xii) Which of the following functions in MS-Excel, is used to find out the number of times, a particular data is there in a data range?—

  1. Count
  2. Countif
  3. Sum
  4. Max

(xiii) Which of the following is a DCL statement?—

  1. Create
  2. Insert
  3. Drop
  4. Grant

(xiv) Which of the following is nofaDBMS software?

  1. dBase
  2. Oracle
  3. Visual Basic
  4. MS-Access

(xv) Data integrity refers to—

  1. non-duplication of data
  2. accuracy of data
  3. security of data
  4. centralised data

(xvi) Which of the following attributes is used to change the font style of a text in HTML?—

  1. Pattern
  2. Face
  3. Size
  4. Design

(xvii) E-mail is downloaded from the mailbox using the protocol—

  1. SMTP
  2. POP3
  3. IMAP
  4. MIME

(xviii) In which of the following media, data is transferred in the form of a light signal?—

  1. STP
  2. Co-axial cable
  3. Fiber optic cable
  4. All of these

(xix) In a de-multiplexer mcontrol bits can be used to select a maximum of how many output lines?—

  1. m2
  2. m
  3. 2m
  4. 2m

(xx) Which of the following gate is not required to implement a multiplexer?—

Logic Gates

  1. AND
  2. OR
  3. NOT
  4. All of these are necessary

(xxi) What will be the value of F in the above diagram?—

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

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

  1. Write the Truth Table of 1 x 4 DeMux. Or; Write a difference between MUX and DeMUX.
  2. What is the Baud rate?
  3. Write a function of www. Or; Give the names of two search engines.
  4. Write the syntax to give the background colour as ‘YELLOW’ in a webpage, using HTML. Or; What are the two main sections of an HTML document?
  5. What is the purpose of the ‘line break’ tag in HTML? Or; What do you mean by Container element in HTML?
  6. What is the main function of DBA?
  7. Which data type is necessary to store the Date of birth, in a table of MS-Access? Or, What do you mean by Query in MS-Access?
  8. What do you mean by Universal gate?
  9. Find out the relationship between the number of Input lines and Selection lines of a Multiplexer. Or; What is the function of a decoder circuit?
  10. What do you mean by Channel capacity? Or, Write the full form of IGMP.
  11. Write the difference between Half duplex and Full duplex communication.
  12. What is the function of ‘VALIGN’ attribute in HTML? Or; Write the code in HTML to make the following lien ‘Bold’ and ‘Italics’: “New Delhi the capital of India.”
  13. Define Normalization. Or; What do you mean by Candidate key?
  14. What is the address of the first cell in an MS-Excel sheet?

PART – A [Marks : 35]

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

Question 1

  1. Write the difference between Decoder and Encoder.
  2. Write the truth table of Decimal to Binary Encoder and also draw the circuit diagram. 2 + (2 + 3)

Or

  1. Derive the logical expressions for difference and borrow of a half subtractor circuit. Draw the logic diagram.
  2. Design AND gate using NOR gate only.
  3. Draw the logic diagram of a 1 x 4 de-multiplexer circuit. (2 + 1) + 2 + 2

Question 2

  1. Distinguish between container tag and empty tag in HTML.
  2. Which tag is used for linking in HTML? Write one attribute of this tag with an example.
  3. Write the function of tr tag and td tag. 2 + 2 +(1½ +  1½)

Or

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

  1. Give the title of the webpage as ‘Modem Computer Application’.
  2. Give a heading using the thickest heading tag into the webpage as ‘Chapters of Modern Computer Application’.
  3. Create the following list: 1. Logic Gate & Comoinauonai circuit 2. Networking 3. Database Management System 4. Introduction to Spreadsheet 5. MS-Access. 1 + 1+5

Question 3

(a) Consider the following table :

  • BOOK (Book Id. Title, Author, Stream, Price)
  • MEMBER (Member Id, Name, Phone, Age)
  • ISSUE (Issue No. Date. Member_Id, Book_Id)
  1. Display the title and author of ‘Science’ books whose price is less than or equal to Rs. 250.
  2. Display the name of members who have issued books on 23/02/2018.

(b) Define super key with an example.

(c) What do you mean by Many-to-Many relationship? (2 + 2) + 2 + 1

Or

  1. Explain the Selection and Projection operation with an example.
  2. What is DDL? Give two examples.
  3. What is ‘Database Schema’?

Question 4

  1. Write the syntax and function of
    Product (), Average () and Upper () in MS-Excel.
  2. Write an advantage of Goal Seek. (2 × 3) + 1

Or

  1. Discuss any two types of cell referencing in MS-Excel.
  2. Write the purpose of the sort and filter option in MS-Excel. (2 + 2) + (1½ + 1½)

Question 5

  1. Write the steps to set the relationship between two tables in MS-Access.
  2. State two differences between the Datasheet view and the Design view of MS-Access.
  3. What is the advantage of Query over data records in MS-Access? 3+2+2

Or

  1. What is the relationship between the Validation rule and the Validation text property in MS-Access?
  2. Write the steps for inserting a field in a table of MS-Access.
  3. What will happen if you input text-type data in a number-type field in MS- Access?

≫ You May Also Like