M. Sc. I.T., SEMESTER - III
ADVANCED RDBMS WITH ORACLE
Duration -3 Hrs Max Marks: 60
Note: 1. Attempt any five questions.
2. All question carry equal marks.
Q1. What problems are caused by data redundancies? Can data redundancies be completely eliminated when the database approach is used? Why or why not?
Q2. Explain the Oracle Architecture in brief.
Q3. Identify each background process with its primary purpose, its interaction with other background processes and when the background process is active.
Q4. Briefly explain and categorize the SGA memory structures.
Q5. Explain the following terms:
a) User
b) Schema
c) Data File
d) Control File
Q6. Every object you create has a logical segment stored in a table space. Do you agree with this statement? If yes give the types of segments.
Q7. List the components of a database block and their attributes.
Q8. (a) If indexes are good then why not index every column on every table?
(b) Explain the creation, alteration and deletion of an index in Oracle.
Q9. (a) Illustrate the importance of backup.
(b) What is offline backup? What is the general process for taking an offline backup?
M. Sc. C S / MCA, SEMESTER- I
PROGRAMMING FUNDAMENTALS USING ‘C’
Time: 3 Hours Total Marks: 60
Note:
1. Attempt any FIVE questions.
2. Each question carries equal marks
1. What the difference is between DO loop and DO WHILE loop? Explain with the help of two examples that will print the same output on the console.
2. a) What is a function call?
b) What is the difference between call by reference and call by value?
3. Distinguish between local and global variables with the help of an example.
4. What is a recursion? Write a program to find the factorial of a number using recursion.
5. What is operator precedence? How is it useful in evaluation of an expression?
6. What is a String? What are different operators in C for manipulating Strings?
7. Write a program to display following output:
*
* *
* * *
* * * *
* * * * *
8. Write a program to check whether the string entered is a palindrome or not
9. What are various data types available in C? Give their range, precision and size of memory, storage bytes.
M. Sc. C S / MCA, SEMESTER- III
COMPUTER NETWORK AND DATA COMMUNICATION
Time: 3 Hours Total Marks: 60
Note:
1. Attempt any FIVE questions.
2. Each question carries equal marks
Q1. (a) Explain Bandwidth, Data rate, Channel capacity and Error rate?
(b) Explain and describe the working of modem. Explain conversion of an analog signal into digital signal?
Q2. What do you understand by data communication? Explain some of the following hardware
i. Bridges
ii. Router
iii. Repeater
iv. Amplifier
v. Switch
vi. Hub
Q3. (a) What do you understand by multiplexing? When you require multiplexing
(b) Draw and explain following types of multiplexing
i. FDM
ii. TDM
iii. WDM
Q4. (a) What is Protocol? Explain OSI Architecture with diagram.
(b) Explain cyclic redundancy code error detection and correction algorithm with an example
Q5. What do you understand by protocols? Draw and explain OSI and TCP/IP model in detail?
Q6. (a) Explain HDLC model in detail
(b) Explain the packet of ATM. Explain working of ATM
Q7. What do you understand by synchronous and asynchronous modes in data communication? Explain any flow control mechanism in detail
Q8. (a) Explain the following topologies with diagram
i. Star
ii. Ring
iii. Mesh
iv. Bus
v. Hybrid
(b) Explain LAN MAN and WAN? Also explain the concept of intranet, internet and extranet?
Q9. (a) Explain token Ring algorithm?
(b) Explain RS232C with its application?
DIPLOMA COMPUTER SCIENCE, SEMESTER –V
COMPUTER NETWORKS
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
1. What is network Models of network computing?
2. Describe OSI Model in detail.
3. Explain types of Transmission Media in detail.
4. What are various Network Topologies?
5. What are various Protocol Suites?
6. Explain the Network Architecture
7. What are Network Trouble Shooting Techniques
8. Explain Network Administration in detail.
M. Sc. I.T., SEMESTER - I
PROGRAMMING FUNDAMENTALS USING ‘C’
Duration -3 Hours Max Marks: 100
Note: 1. Attempt any FIVE questions.
2. All questions carry equal marks.
1. What is computer? Draw a block diagram of computer and describe the characteristics of computer?
2. Describe all Input and Out Put devices in detail?
3. What do you mean by Operating System? Explain all the functions of an Operating system in detail.
4. Write the brief notes over C programming? Define all the data types available in C programming.
5. What is array? Describe all types of array ? write a program for the example of two dimensional array?
6. Describe the term Call by Value and Call by Reference? Explain with the help of the program?
7. What do you mean by String? Define strcat(), strcmp() and strlen() function with example?
8. I) Write a program to Print the table of user given Number?
II) Write a program to find the number is even or odd?
9. Convert in other base
I) 10010=? 4 II) 171510=? 12
III) 5456=? 4 IV) 110100112=? 16
V) 5628=? 2 VI) 67518=? 2
VII) 2AB16=? 2 VIII) ABC16=? 2
BACHELOR OF COMPUTER APPLICATION, SEMESTER - III
Data Structures & Algorithms
Duration -3 Hours Max Marks: 60
Note: 1. Attempt any FIVE questions.
2. All questions carry equal marks.
1. What is a data structure? Why is such a concept required? What is an abstract data type?
2. What are the different operations performed on data structures ? Why are they required?
3. What is a stack? What different operations can be performed on stacks? How are stacks used?
4. What is the concept of Garbage Collection ?
5. In what different ways can insertions be done in linked list? How do you delete elements from a linked list?
6. Explain the concept of recursion. What are Polish Notations?
7. Write a program to generate a linked list of prime numbers.
8. What is meant by the complexity factor of an algorithm? How is it optimized?
9. Write a program that will reverse a linked list while traversing it only once. At the conclusion each node should point to the node that was previously its predecessors ,the head should point to the node that was formerly at the end and the node that was formerly first should have a NULL link.
INTEGRATED MCA, SEMESTER - III
Data Structures & Algorithms
Duration -3 Hours Max Marks: 60
Note: 1. Attempt any FIVE questions.
2. All questions carry equal marks.
1. What is a data structure? Why is such a concept required? What is an abstract data type?
2. What are the different operations performed on data structures ? Why are they required?
3. What is a stack? What different operations can be performed on stacks? How are stacks used?
4. What is the concept of Garbage Collection ?
5. In what different ways can insertions be done in linked list? How do you delete elements from a linked list?
6. Explain the concept of recursion. What are Polish Notations?
7. Write a program to generate a linked list of prime numbers.
8. What is meant by the complexity factor of an algorithm? How is it optimized?
9. Write a program that will reverse a linked list while traversing it only once. At the conclusion each node should point to the node that was previously its predecessors ,the head should point to the node that was formerly at the end and the node that was formerly first should have a NULL link.
DIPLOMA IN INFORMATION TECHNOLOGY, YEAR –1
FUNDAMENTALS OF INFORMATION TECHNOLOGY
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
Q1. What is Internet? Why is it needed? ? Explain advantages of E-mail and Internet
Q.2 What is CDROM? What is the capacity of a typical CDROM today? What are its application?
Q.3 What is word processing? What are the facilities provided by a word processor?
Q.4 What is system software? What is an application of software? Give an example of an application software.
Q.5. Explain different types of Memories and Explain the factors that effects the speed of processors.
Q.6. Explain various types at information systems and operating system
Q.7 Explain computer network. Why is a network useful?
Q.8. Draw a block diagram of computer and explain function of each unit of the blocks.
BACHELOR OF COMPUTER APPLICATION, SEMESTER – V
INTERNET & WEB SITE MANAGEMENT
Duration -3 Hours Max Marks: 60
Note: 1. Attempt any FIVE questions.
2. All questions carry equal marks.
1. What are different types of Protocols? Explain HTTP protocol.
2. Explain HTML frames in detail. Describe the different attributes of FRAME SET elements
3. What is image map? Describe the different types of image maps.
4. What are compliers and interpreters? How do we compile a program?
5. What is the difference between served and applets?
6. Give a brief description of DHTML. What is different ways to insert a style sheet in DHTML?
7. What are filters? Explain with examples. Give a detail of different types of filters.
8. What is structured graphics control? Explain.
9. How to connect the database using Perl? Discuss the different methods of connecting the database.
DIPLOMA COMPUTER SCIENCE, SEMESTER –III
OBJECT ORIENTED PROGRAMING
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
Q1 Attempt any Two of the following :
a) Describe the syntax of multilevel inheritance.
b) What is an abstract class? Explain with suitable example.
c) Compare overloading and overriding with examples.
Q 2 : Attempt the following:
a) Write a program to find the length of a string using operator
overloading.
b) Write a program to implement the inheritance as shown in figure.
Assume suitable member function to accept and display data.
Q3 Write a program to count the number of lines, spaces and tabs in a file.
Q 4: Attempt any Six of the following:
a) List the features of Object oriented programming.
b) Draw the structure of a c++ program.
c) What is dynamic memory allocation?
d) Describe the term – Object.
e) Define Constructor.
f) What is operator overloading?
g) Enlist the operators that can not be overloaded.
h) How to initialize a pointer?
Q 5 : Attempt any Two of the following :
a) Explain the concept of 'this' pointer.
b) Write a program to swap two integer values by using call by refernce.
c) What is runtime polymorphism
Q 6 Attempt any Two of the following :
a) Give syntax and use of following with respect to file. i. Open() ii. Close()
b) Explain stream classes and give stream classes for console operation.
c) What is the difference between opening a file with constructor function and
opening a file with open() function.
Q 7 : In procedure oriented programming all data are shared by all functions. Is
this statement TRUE? Justify your answer.
PGDCA, YEAR –1
PROGRAMMING FUNDAMENTAL USING C
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
1. What are primary and secondary constants? Give example of each type of constants.
2. What is difference between pre increment and post increment? Give example. Write a program to check whether the character entered is vowel or not.
3. Write a program entering string as your name and then enter your surname. Concatenate these two strings in the target string and display it.
4. Write a program to check whether the string entered is a palindrome or not. Distinguish between local and global variable with Examples.
5. What do you mean by preprocessor? Give examples of some preprocessor directives.
6. What is the difference between call by value and call by reference? What do you mean by variable initialization? How will you initialize a 2-d array?
7. What are keywords and identifiers? How many types of constants do we have in C?
How many keywords are supported by C?
8. Answer the following:-
What is the difference between WHILE loop and DO WHILE loop. Write a program to swap two values entered.
INTEGRATED MCA, SEMESTER- I
PROGRAMMING FUNDAMENTALS USING ‘C
Duration -3 Hrs Max Marks: 60
Note: 1. Attempt any five questions.
2. All question carry equal marks.
1. (a) What are the different types of Operators in a C language? Explain them briefly.
(b) What are the various Data types in C language? Explain them briefly.
2. (a) What is a function? What are the different ways of passing values using functions?
(b)Write a program to check whether the number entered by the user is positive or negative.
3. What are C tokens? Taking an expression, write its various tokens. What are keywords and identifiers? Give examples.
4. (a) What is the difference between WHILE loop and DO WHILE loop.
(b) Write a program to swap two values entered without using third variable.
5. (a) What is recursion? Write a program to find the factorial of a function using recursion.
(b) What do you mean by these manipulators: \n, \t,%0.0f , % .
6. (a) What is a user defined function? What is a function call? What is the difference between call by value and call by reference?
(b) What do you mean by variable initialization? How will you initialize a 2-d array?
7. What is a user-defined function? What is a function call? What is the difference between call by value and call by reference?
8. Write a program to sort the elements in descending order in an array. What do you mean by preprocessor?
9. What is a user-defined function? What is a function call? What is the difference between call by value and call by reference?
B.SC. INFORMATION TECHNOLOGY, SEMESTER –I
PROGRAMMING FUNDAMENTALS USING C
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
1. Describe the different input output statements in “C”.
2. Explain the various condition statements in “C” with an example.
3. What are the different looping structures in “C”? Explain with an example.
4. How to declare arrays in “C”? How the array elements are actual stored in memory. Explain with an example.
5. What is meant by recursion? Write a program to find factorial of a number.
6. How to declare a structure in “C”? Write a small code to implement the structures.
7. What is a pointer? What are the different operations that are permitted in them?
8. What is meant by file? Write a small code to open and write data into a file.
DIPLOMA IN COMPUTER APPLICATION, YEAR –1
PROGRAMMING FUNDAMENTALS USING C
Time: 3 hours M.Marks:60
Note: - Attempt any 5 questions.
All questions carry equal marks.
1. Write an algorithm for swapping two elements without using an extra temporary variable.
2. Write a C program to convert a given decimal number to binary.
3. What are the control structures in C? Give an example each.
4. Write a C program to sort a set of n elements using bubble sort.
5. Declare a 12-element array of pointers to functions. Each function will accept two pointers to double-precision quantities as arguments and will return a pointer to a double-precision quantity.
6. Write a program to find the transpose of a given n x n matrix A. The matrix A should be declared using pointers. Your program should store the resultant in A only. No additional matrix be used.
7. Write a C Program to find the Kth smallest element of a given array.
8. Write a program that reads a line of text from a data file character by character and displays the text on the screen.
BCA\DCA, SEMESTER – I
PROGRAMMING FUNDAMENTALS USING C
Duration -3 Hours Max Marks: 60
Note: 1. Attempt any FIVE questions.
2. All questions carry equal marks.
1. What is binary mathematical operator? What is operator procedure in 'c'
2. What is the while statement? Write a for loop which sums all between 10 and 100 into a variable called total. Assume that total has NOT been initialized to zero.
3. What do you mean by Nested Loops? Discuss their implications
4. Describe what you understand by switch statement. Give an example.
5. What do you mean by a function and discuss its various parts?
6. What is an Array? Why do we need an array in our programs?
7. What do you understand by a character input and character output?
8. Discuss the scope of function parameters.
9. What is typeset keyword? What are its advantages?
MCA, SEMESTER- V
SERVER SIDE PROGRAMMING
Time: 3 Hours Total Marks: 60
Note:
1. Attempt any FIVE questions.
2. Each question carries equal marks
1. Write HTML programs to:
a) Add a background color
b) Add a background image
c) Create hyperlinks
d) Open a link in a new browser window
2. How will you make your own objects in Perl? Show with an example.
3. How Get method is different from Post method. Explain with the help of an example.
4. Explain following library functions with example:
a. Chop ()
b. Push ()
c. Pop ()
d. Shift ()
5. Create HTML form to enter total marks of 5 students out of 100 & when submitted to server, by using ASP file display the grade of each student according to following criteria:
If marks>90 then grade is A, if marks>70 then grade is B, if marks>60 then grade is C else grade is D.
6. a. What are the different data types available in perl explain in detail?
b. Explain working of CGI with suitable diagram.
7. Explain different objects of ASP with their properties & methods.
8. By using select-case write a program in ASP to get the capital of country selected by the user from list. Create list of 5 to 10 countries in html form.
9. Which Language is best for CGI and why?
Posts
No comments:
Post a Comment