Question Paper of BCA 4th Sem of May2012-June2012
Roll No........ Total No. of Page:2
BCA/M12:901
B.C.A-246-Management Information System
Time:3 Hours Maximum Marks:90
Note: First question is compulsory.In addition to that attempt any four question, selecting one question from each unit. All question carry equal marks.
(Compulsory Question)
Q.1 Define the following terms:
a) Information b) Data Structures
c) Cohesion d) Input and Output forms
e) E-business f) Black box
g) Interface h) OLTP
i) Data validation
UNIT - I
Q.2 Define System. Briefly explain various types of systems.
18
Q.3 Distinguish Between 6,6,6
a) MIS and DSS
b) Data and Information
1
|
c) Open and Closed systems
UNIT - II
Q.4 Describe Simon's Model of decision Making. 18
Q.5 Distinguish Between: 9,9
a) Formal and Informal Information System.
b) Structured and Unstructured decisions.
UNIT - III
Q.6 Explain various methods of evaluating the cost and 18
benefits.
Q.7 Explain Top-Down design. What are its advantages. 18
UNIT - IV
Q.8 What do you mean by e-commerce? Explain various
benifits & limitations of e-commerce. 18
Q.9 What do you mean by DSS? Explain various objectives
of DSS. 18
2
|
Roll No. ............... Total No. of Page:4
BCA/M12:900
BCA -244 - Releational Data Base Management
System
Time:3 Hours Maximum Marks: 90
Note: A candidate is required to attempt five question in all,selecting one question from each unit. Question no. 1 is compulsory.
Q.1 Define following terms: 3*6=18
i) Primary Key
ii) Candidate Key
iii) Project Operation
iv) Transitive Dependency
v) Data Defination command
vi) BCNF Normal Form
UNIT - I
Q.2 (a) Explain Relational Constraints with example. 9
1
|
(b) What do you mean by joint operation. Explain equi
join, natural join & thetha join operation with
example 9
Q.3(i) Explain following terms using Tuple oriented
Releational calculus:
(a) Tuple variable
(b) Well formed formulas
(c) Free & bound variables. 9
(ii) Consider the following relational schema. An
employee can work in more than on department. 9
Emp(eid,ename,salary)
Works(eid,did)
Dept(did,dname,managerid,floormem)
Write the following quaries:
(a) Print the names of all emp. who can work on the
10th floor and make less than Rs. 50,000.
(b) Print the names of all managers who manage three
or more department on the same floor.
2
|
(c) Print the names of the departments that employee
santa work in.
UNIT - II
Q.4 What do you mean by normalization. Expalin 1NF, 2NF,
3NF with example in detail. 18
Q.5 a) What do you mean by functional dependency.
Explain fully functional dependency & transitive
functional dependency with example. 9
b) Explain BCNF. If a relation is in 3NF then whether
the relation will be in BCNF or not. 9
UNIT - III
Q.6 (a) What is SQL. Expalin its Advantages and
Disadvantages of SQL. 9
(b)Expalin Select statement with various type of
option available in SELECT. 9
Q.7 (a) Explain various Data Type used in SQL . 9
3
|
(b) What do you mean by DDL Command in SQL
Explain two DDL commands with example. 9
UNIT - IV
Q.8 Explain various control structure in PL/SQL.
Explain with example. 18
Q.9 (a) Write a program in PL/SQL to find the sum of first
n natural no. using while loop & for loop. 9
(b) Explain the structure of PL/SQL Block int detail. 6
4
|
Roll No. ............... Total No. of Page:2
BCA/M12:898
BCA -242 - Data Structure - II
Time:3 Hours Maximum Marks: 90
Note: Question no. 1 is compulsory and attempt four more questions selecting one from each unit.
(Compulsory Question)
Q.1 (a) What are the applications of binary search tree?
(b) Find prefix polish notation for the expression.
E=(2a+5b)^ 3 *(x-7y)^ 4
(c) What are the various representation of graphs in
compurter memory?
(d) Differentiate between serial & sequential file
organisation.
(e) Describe Kruskal algorithm for minimum spanning
tree.
(f) How deletion is performed in B tree? 6*3=18
UNIT -I
Q.2 Explain the procedure of insertion & deletion in binary
search tree using suitable example. 18
1
Q.3 What is m.way search tree? Write the procedure for
operations used in m-way search tree. 18
UNIT -II
Q.4 Expalin in detail of the Depth First Search Technique
for traversing the graph with suitable example. 18
Q.5 What is Topological sorting? Write the algorithm and
explain the process using suitable exapmle 18
UNIT -III
Q.6 (a) Compare various sorting & searching techniques
on the basis of their complexity.
(b) Write algorithm for Radix sort 9*2=18
Q.7 What is Quick sort? Write the algorithm for Quick
sorting & explain it with suitable example 18
UNIT -IV
Q.8 Write notes on:
(a) Collision Resolution
(b) Sequential File Organisation 9*2=18
Q.9 Describe Indexed & Random file Organisation and their
access mechanism. 18
2
|
Roll No. ............... Total No. of Page:2
BCA/M12:897
BCA -241 - Web Designing - I
Time:3 Hours Maximum Marks: 90
Note: Answer five questions. Question no. 1 is compulsory select one from each
unit.
(Compulsory Question)
Q.1 (a) Write steps to views HTML document.
(b) List attributes of (HR) Tag.
(c) Define HTML & DHTML.
(d) What is default alignment of Image. Text inserted
in webpage.
(e) Write Tag for Inserting Table. 18
UNIT - I
Q.2 What do you understand by the term Internet. Give its
application in education 18
Q.3 (a) Define www. Explain key components of www.
(b) What is webcasting. Give types of webcasting
services 18
UNIT - II
Q.4 Explain various steps to develop a website.
1
Q.5 (a) Discuss terms Home-Page & DNS.
(b) Explain Client-Server Model. 18
UNIT - III
Q.6 (a) State features of HTML document. Explain with
exapmle
(b) Give use of following:
BODY
TITLE
BR
HTML 18
Q.7 (a) Differentiate basefont and font tag.
(b) Explain block - level elements.
(c) Discuss Tags for Inserting Links 18
UNIT - IV
Q.8 (a) Differentiate ordered and unordered list.
(b) Write Purpose, syntax and exaple of form- Tag
Registration 18
Q.9 Create a form using ordered list, Radio button and
Check boxes 18
2 |
Roll No. ............... Total No. of Page:3
BCA/M12:899
BCA -243 - Computer Architecture - II
Time:3 Hours Maximum Marks: 90
Note: First question is compulsory.In addition to that attempt any four question,
selecting one question from each unit. All question carry equal marks.
(Compulsory Question)
Q.1 Define the following: 9*2=18
(a) Floating point number representation.
(b) Normalised floating point representation.
(c) r's complement.
(d) Rise
(e) CISC
(g) Program status word.
(h) Program counter
(i) Instruction cycle
(j) MIMD
UNIT - I
Q.2 (a) Draw a flow chart for add and subtract operations.
1
(b) Show the register configration for hardware
implementation of the add and subtrat operations.
9,9
Q.3 (a) Derive an algorithm in flow chart form for floating
-point multiplication of two numbers.
(b) Solve the following using normalized floating point
numbers:
(i) .4525 E5 * .3575 E7
(ii) .7680 E6 * .5465 E4
(iii).5543 E2 * .4111 E7 9,9
UNIT - II
Q.4 (a) Define Program Interrupt. Write short notes on:
(i) Interrupt cycle
(ii) Priority Interrupt 9
(b) Explain various types of Interrupts. Also give three
exapmles of each type of Interrupts. 9
Q.5 (a) Explain briefly the characteristics of reduced
instruction set computer.
(b) Write a short note on RISC Instruction set. 12,6
UNIT - III
Q.6 (a) Explain the Pipeline organisation with the help of
example.
2
(b) Determine the no. of clock cycles that if takes to
process 200 tasks in a six-segement pipeline. 9,9
Q.7 (a) Write the steps taken in the execution of an
instruction. i.e.(instruction cycle).
(b) Briefly explain the three major difficulties that
cause the instruction pipeline to deviate from
its normal operation. 3,5,5,5
UNIT - IV
Q.8 What wre the consideration in flynn's classification of
parallel processing. Explain the following on the basis
of above classification.
(a) SISD (b) SIMD
(c) MISD (d) MIMD 18
Q.9 (a) Discuss the difference between tightly coupled
multi processors and loosly coupled multi
processors.
(b) Briefly explain the multistage switching Network.
9,9
3
|
No comments:
Post a Comment