DBMS PRACTICE QUESTIONS 1
1. What is indexing? Explain different types of indexing with example. (UNIT 6)
2. What is hashing? Explain types of hashing. Explain open hashing and closed hashing. (UNIT 6)
3. Explain query processing steps with diagram. (UNIT 5)
4. Create a b tree for following key values. 2,3,5,7,11,17,19,23,29,31) Assume that the tree is initially empty and values are added in ascending order. Consider the number of pointers in each node as four. (UNIT 5)
DBMS PRACTICE QUESTIONS 2
1. Explain all types of JOINS in relational algebra with example. (UNIT 3)
2. Explain SET OEPRATIONS in relational algebra with example. (UNIT 3)
3. How can we measure cost of Join query? Explain using example. (UNIT 5)
4. Explain query optimization process. (UNIT 5)
1. Write a program to find maximum from 3 numbers using else if ladder structure.
2. Write a program to find minimum from 3 numbers using nested if else.
3. Write a program to find factorial of a number.
4. Write a program to print fibonacci series upto first n terms.
5. Write a program to create a user defined function check_prime(). Return 1 if number is not prime, return 0 if number is prime.
6. Develop a menu-based program to perform addition, multiplication, subtraction and division using user-defined function.
7. Write a program to print below pattern.
a b c d
a b c
a b
a
8. Write a program to print below pattern.
*
* *
* * *
* * * *
Preparation Questions 4:
1) One Dimensional Array (With Syntax and Program)
2) Write a Program to find maximum and minimum from 1-Dimensional array.
3) Write a Program to find sum and average of array elements.
4) Two Dimensional Array (With Syntax and Program)
5) Program of Sum of two 3*3 array.
6) Program of Multiplication of two 3*3 array.
Preparation Questions 3:
1) WHILE Loop (With Syntax and Program)
2) DO WHILE Loop (With Syntax and Program)
3) FOR loop (With Syntax and Program)
4) Practical 3 Programs
5) Practical 4 Programs
DBMS PRACTICE QUESTIONS 1 1. What is indexing? Explain different types of indexing with example. (UNIT 6) 2. What is hashing? Explain types...