B.C.A. DEGREE EXAMINATION,
NOVEMBER 2018
First Semester
Computer Application
C AND DATA STRUCTURE
(CBCS – 2017 onwards)
Time
: 3 Hours
Maximum
: 75 Marks
Part A (10 ´ 2 =
20)
1.
Define
trigraph characters.
2.
Define
string constants.
3.
Define
two-dimensional arrays.
4.
What
are getchar( ) and gets( ) functions?
5.
What
is the need for user-defined function?
6.
How
to declare a union?
7.
How
to initialize pointers?
8.
What
are the uses of getw( ) and putw( ) functions?
9.
What
is abstract data type?
10.
Define
stack.
Part
B
|
(5 ´ 5 = 25)
|
11.
(a)
Discuss the precedence of operators in C. Or
(b)
Explain
nested if statement with example.
12.
(a)
Write a program to find the median of a list of numbers.
Or
(b)
Write
a program to check if a string is a palindrome or not.
13.
(a)
Explain the general format of function definition – Give example.
Or
(b)
Explain
arrays within structures with example.
14.
(a)
Explain the declaration of pointer variables with example.
Or
(b)
Explain
the various file opening modes.
15.
(a) Write and explain the data structure
operations. Or
(b)
Write
an algorithm for delete an from the linked list.
2
Part
C
|
(3 ´ 10 = 30)
|
Answer any three questions.
16.
Discuss
about formatted input in C.
17.
Write
a program to find the sum of two matrices.
18.
Discuss
the scope and life time of variables.
19.
Explain
the I/O operations on files.
20.
Discuss
about queue as ADT.
—————
F–0915
|
Sub. Code
|
||
7BCA2C1
|
|||
B.C.A. DEGREE EXAMINATION,
NOVEMBER 2018
Second Semester
Computer Application
PROGRAMMING IN C++
(CBCS – 2017 onwards)
Time
: 3 Hours
Part A
Answer all questions.
1.
What
is a Token? Give an example.
2.
What
is the use of continue statement?
3.
How
will you define member function outside the class?
4.
What
is a Constructor?
5.
Define
Inheritance.
6.
What
is a Virtual function?
7.
What
is an ASCII File?
8.
What
is the difference between sequential file and random access file?
9.
What
are the advantages of function Template?
10.
Write
any four exceptions in C++.
Part
B
|
(5 ´ 5 = 25)
|
Answer all questions, choosing either (a) or (b).
11.
(a) Explain any five functions in C++ with
example. Or
(b)
Explain
else — if statement with an example.
12.
(a)
Explain parameterized constructor with an example.
Or
(b)
How
will you construct 2D arrays? Explain.
13.
(a) Explain any five manipulators with example.
Or
(b)
Explain
Pointer to derived class with an example.
14.
(a)
Explain the classes for File stream operations with diagram.
Or
(b)
Explain
Command-Line argument with a program.
15.
(a)
Explain the exception handling model with an example.
Or
(b)
Explain
the rules for handling exceptions successfully.
Part
C
|
(3 ´ 10 = 30)
|
Answer any three questions.
16.
Explain
any two loop statements in C++ with example.
17.
Explain
array of objects with a program.
2 
18.
Explain
multiple inheritance with a program.
19.
Write
a C++ program to store the employee details in a binary file using write( ).
20.
Write
a C++ program to interchange (swap) the two numbers (ie, int, float and char
types) using function template.
————————
F–0916
|
Sub. Code
|
|||
7BCA3C1
|
||||
B.C.A. DEGREE EXAMINATION,
NOVEMBER 2018
Third Semester
Computer Applications
DATABASE MANAGEMENT SYSTEMS
(CBCS – 2017 onwards)
Time : 3 Hours Maximum : 75 Marks
Part A (10 ´ 2 =
20)
1.
Write
the database languages.
2.
Define
Query.
3.
What
is a Temporal data?
4.
Define
Tuple.
5.
What
do you mean by Heterogeneous database?
6.
Define
Server.
7.
What
is a Schema?
8.
Define
Index.
9.
What
are the parts of PL/SQL?
10.
Define
Trigger.
Part
B
|
(5 ´ 5 = 25)
|
11.
(a) Explain the Database system applications.
(b)
Explain
the Transaction Management.
12.
(a)
Explain Decomposition using Multivalued dependency with example.
(b)
Explain
the features of good relational designs.
13.
(a) Explain the client-server architecture.
(b)
Explain
distributed query processing.
14.
(a)
How will you create a View? Explain with an example.
Or
(b)
Explain
Synonyms with an example.
15.
(a) Explain trigger with an example.
(b)
How
will you create a Package? Explain with an example.
2 F–0916
Part
C
|
(3 ´ 10 = 30)
|
Answer any three questions.
16.
Explain
E-R model with diagram and example. Discuss its design issues.
17.
Explain
Boyce-Code Normal form with an example.
18.
Explain
various network types.
19.
Create
a EMPLOYEE table with the attributes empno, name, age, basic_pay. Insert five
records into the table.
20.
Write
a procedure to calculate the phone bill. [Assume your own data].
————————
F–0992
|
Sub. Code
|
||
7BCAA1
|
|||
U.G DEGREE EXAMINATION,
NOVEMBER 2018
Computer Application
Allied — OFFICE AUTOMATION
(Offered by the department of
BCA)
(CBCS – 2017 onwards)
Time
: 3 Hours
Part A
Answer all questions.
1.
Write
the differences between Notepad and Wordpad.
2.
Write
the steps for Install a software in MS-Windows.
3.
Define
Icon.
4.
What
are the contents of a Font dialog box in MS-Word.
5.
Write
the steps for Fill Command in MS-Excel.
6.
How
will you Select a range of cells and the entire sheet in Excel?
7.
What
are the types of views available in MS-Powerpoint?
8.
What
is a Presentation?
9.
What
are the parts of an Access Window?
10.
Define
Database.
Part
B
|
(5 ´ 5 = 25)
|
11.
(a)
Explain the procedure for sharing information between Computers.
(b)
Write
the steps for create, search, rename a folder.
12.
(a)
Write the steps for Insert Pagenumbers and Pictures.
Or
(b)
Explain
the text editing Features Bullets and numbering in detail.
13.
(a)
Explain about the text alignment in the Excel cell. Or
(b)
Explain
about how formulas, functions are handled in Excel Worksheet.
14.
(a)
How will you add graphics and Sounds effect to a Slide?
Or
(b)
Explain
about the Slide show option in Power point.
15.
(a) How will you create a table using design
view?
(b)
How
will you design a Report?
Part
C
|
(3 ´ 10 = 30)
|
16.
Explain
the concepts and features of MS-Windows.
17.
Describe
about Tabs and Indents Settings in a Word document.
18.
Explain
the steps to create a Bar graph in Excel.
19.
Explain
about the Autocontent Wizard to create a Presentation.
20.
How
will you create a query in MS-Access? Give an example.
——————
F–0993
|
Sub. Code
|
|||
7BCAA2
|
||||
U.G. DEGREE EXAMINATION,
NOVEMBER 2018
Computer Application
Allied : PROGRAMMING IN C
(CBCS – 2017 onwards)
Time
: 3 Hours
Maximum
: 75 Marks
Part A
(10 ´ 2 =
20)
Answer all questions.
1.
What
are the types of programming languages?
2.
Define
variable. Give an example.
3.
How
will you declare 2D array?
4.
How
will you initialize string variables?
5.
How
will you call a function with argument?
6.
What
is the difference between a Structure and Union?
7.
What
is a Pointer?
8.
What
is scaling factor?
9.
What
is a text File?
10.
What
is a random access File?
Part
B
|
(5 ´ 5 = 25)
|
11.
(a)
Explain the fundamental data types in C language. Or
(b)
Explain
the scanf( ) and printf( ) functions in C with example.
12.
(a) Write a C program to reverse the given
string.
Or
(b)
Write
a C program to count the number of odd numbers in an integer array.
13.
(a) What is recursion? Explain with an example.
Or
(b)
Explain
the scope of a variable with example.
14.
(a)
Explain pointer expression with example. Or
(b)
Explain
pointers and structures with an example.
15.
(a) Explain the I/O operations on files with
example. Or
(b)
Explain
Command line argument with an example.
Part
C
|
(3 ´ 10 = 30)
|
Answer any three questions.
16.
Explain
any two loop statements in C with example.
17.
Write
a C program to add two rectangular matrices.
18.
Explain
structures within structure with an example.
19.
Write
a C program to arrange the set of numbers in descending order in an array using
pointers.
20.
Write
a C program to copy the content of one File into another File.
————————
F–0994
|
Sub. Code
|
|||
7BCAA3
|
||||
U.G. DEGREE
EXAMINATION, NOVEMBER 2018
Computer Application
Allied — FUNDAMENTALS OF COMPUTERS AND
INFORMATION TECHNOLOGY
(CBCS – 2017 onwards)
Time
: 3 Hours
Part A
Answer all questions.
1.
Write
the names of Input, Output, Storage devices.
2.
What
are the number systems are used in computer architecture?
3.
Write
the names of operating systems of digital computers.
4.
Write
the names of microprocessors used in the CPU.
5.
What
is a computer network?
6.
What
is meant by virtual reality?
7.
What
are the challenges of E-Commerce?
8.
What
are the benefits of data mining?
9.
Write
the applications of computer in Home.
10.
Write
the applications of computer in Education.
Part
B
|
(5 ´ 5 = 25)
|
Answer all questions, choosing either (a) or (b).
11.
(a) Explain the generations of computer system.
Or
(b)
Do
the following :
(i)
Convert
into decimal : (FFFF)16
(ii)
Convert
into decimal : (326)8.
12.
(a)
Explain the development of programming languages.
Or
(b)
Explain
the applications of Database Management System.
13.
(a)
Describe the E-Commerce market place representation model.
Or
(b)
Explain
about Data warehouse.
14.
(a) Describe about Multimedia tools.
Or
(b)
Explain
about the communication systems.
15.
(a)
Describe the applications of computers in Entertainment.
Or
(b)
Describe
the applications of computers in Medicine.
Part
C
|
(3 ´ 10 = 30)
|
Answer any three questions.
16.
Explain
in detail about magnetic disk and floppy disk.
17.
Explain
about general software features.
18.
Explain
about the World Wide Web concepts.
19.
Describe
about datamart.
20.
Describe
the applications of Information Technology in Engineering.
F–0995
|
Sub. Code
|
|||
7BCAA4
|
||||
U.G. DEGREE EXAMINATION,
NOVEMBER 2018
Computer Application
Allied : DATAMINING AND
WAREHOUSING
(CBCS – 2017 onwards)
Time
: 3 Hours
Maximum
: 75 Marks
Part A
(10 ´ 2 =
20)
Answer all questions.
1.
What
is KDD?
2.
What
is Meta Data?
3.
What
is the need for data preprocessing?
4.
Define
Smoothing.
5.
Define
Association rule.
6.
What
is Prediction?
7.
What
is Model-Based Clustering?
8.
Define
CURE.
9.
What
is Time-Series database?
10.
What
is the web usage mining?
Part
B
|
(5 ´ 5 = 25)
|
11.
(a) Explain the major issues in Data mining.
(b)
Write
from data warehousing to data mining.
12.
(a) Discuss about Data Integration.
(b)
Write
about data mining primitives.
13.
(a) Explain the methods to improve Appiori’s
efficiency.
(b)
Write
the issues regarding classification and prediction.
14.
(a) Discuss about DBSCAN.
(b)
Explain
Grid based clustering methods.
15.
(a) Explain the mining of spatial databases.
(b)
Explain
the social impacts of data mining.
Part
C
|
(3 ´ 10 = 30)
|
16.
Discuss
about data warehouse implementations.
17.
Explain
discretization and concept hierarchy generation.
2 F–0995
18.
Discuss
about Bayesian classification.
19.
Explain
the Partition methods.
20.
Discuss
about trends in Data Mining Web.
————————