Modern Computer Application Question paper 2023|WBCHSE|West Bengal Board
This is the Computer Application Question paper for the year 2023. I have also solved the question paper for your help. This will help for future use.
Multiple Choice Questions
1.
i. (A' .B')' = (A')' + (B')' [ Applying De Morgan's law]
A+B = OR gate
Option b
ii. Input will Be 0,0
Option C
iii. Option C
iv. Option C
v. Selection Line will be 2^2 = 4
Option b
vi. Option b
vii. Option c Star Topology
viii.Option b Home Page
Ix. Option d <font Type>
x. Option C <A>
xi. Option a
xii. Option c ( Data manipulation language)
xiii.Option C ( Tuple)
xiv. Option a ( Rectangle)
xv. Option d (Telephone Directory)
xvi. Option d
xvii. Option d
xviii. Option d (NOW())
xix. Option c ( Absolute , Mixed , Relative Cell Referencing)
xx. Option b (Application)
xxi. Option b (memo)
Short Answer type Question
2. i. Design AND gate using NOR gate
ii. Design 2*1 Multiplexer Block Diagram.
OR
Design the truth table of 1*2 De-Multiplexer
iii. Define two level circuit.
OR
Why multiplexer is called Data Selector.
iv. Difference between Half Duplex and Full Duplex mode.
OR
Design Class C Address structure of IPv4 addressing on Internet.
v. How many link is required to construct a Mesh topology of 10 Computers.
vi. What is Firewall?
OR
Construct the Structure of Email id.
vii.Give two example of Search engines.
viii. How can you break aline in HTML?
Or
Write the syntax of <OL> tag
ix. How many types of paragraph alignments are there in HTML and what are those?
Or
What are the full form of HREF?
X. What is candidate key?
Or
What do you mean by database instance?
xii. What is cardinality in a relation ?
Or
Define data dictionary?
Xii. What is the last column in Ms Excel ?
Or
What is the use of show table dialog box in MS Access?
Descriptive Type Questions
3. a. Derive the logical expression for difference and borrow of full subtracted circuit using truth table.
Draw the circuit diagram of a 1×4 de multiplexer.
Or
a. Write the truth table of 3 to 8 decoder and also draw the logic diagram of it.
b. Write two difference between Decoder and Encoder.
c. Construct a Full adder by using two Half adder.
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 web page .
c. Write the name of any two attributes and their functions of "BODY" tag in HTML.
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.
5. Explain with example
a. Cartesian product.
b. Selection.
c. Projection.
OR
Look at the following table:
Product(Pid, Pname, Price, Company)
Write the SQL Query
a. Show the name and price of the product whose prices are more than 20000.
b.Show the dtails of the product whose manufacturing company is "LG"
c. Arrange the records of all products according to their price in ascending order.
6. a. Write the steps to perform cell merge operation in MS-Excel 2007.
b. Write the purpose of TODAY() and COUNT IF() functions.
OR
a. What do you mean by cell range in MS-Excel? Give two example.
b. How can you insert a new records in MS-Excel?
c.Write a short notes on relative cell reference.
7. a. Write two difference between design view and Data sheet 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.
OR
Write the procedure to make an auto form in MS-Access.
b. Write two difference "Select Query" and Cross tab Query.
c. Write the functions of OLE object and MEMO data type in MS-Access.
0 Comments