SE UNIT 9 MATERIAL FOR MID SEM EXAM

 3 UNIT 9 MATERIAL (FOR MID SEM EXAM ONLY) : DOWNLOAD

CNS UNIT 9 MATERIAL FOR MID SEM EXAM

CNS UNIT 9 MATERIAL (FOR MID SEM EXAM): DOWNLOAD

DBMS PRACTICE QUESTIONS 1

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

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)

DBMS MID SEM SQL QUESTIONS

 DBMS MID SEM EXAM SQL QUERY QUESTIONS: DOWNLOAD

PPS PROGRAMS FOR PRACTICAL EXAM

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.

      *

    *  *

  *  *  *

*  *  *  *

PPS PREPARATION 4:

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.

PPS PREPARATION 3:

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

UNIT 4 ARRAY : PROGRAMS

UNIT 4 : ONE DIMENSIONAL ARRAY PROGRAMS : VIEW

PPS PREPARATION 2

Preparation Questions 2:

1) If Statement (With Syntax and Program)

2) If Else Statement (With Syntax and Program)

3) Nested If Else Statement (With Syntax and Program)

4) Else If Ladder Statement (With Syntax and Program)

5) Switch case Statement (With Syntax and Program)

6) GOTO Statement (With Syntax and Program)

7) Practical 2 Programs

PPS PRACTICAL 2 EXTRA PROGRAM FOR PRACTICE

1. Write a C program to accept two integers and check whether they are equal or      not.

2. Write a program to check whether a number is odd or even. (if else statement).

3. Write a C program to check whether a given number is positive or negative. (if else statement).

4. Write a C program to read the age of a candidate and determine whether he is eligible to cast his/her own vote. (if else statement).

5. Write a C program to accept the height of a person in centimeters and categorize the person according to their height. ()

< 150.0 CM	person is Dwarf
150.0 >= && < 165.0	person is average heighted
>= 165.0 && <= 195.0	person is taller
>195	abnormal height

6. Write a program in C to accept a grade and declare the equivalent description:

    Grade    Description

        E     Excellent

        V     Very Good

        G     Good

        A     Average

        F     Fail

7. Write a C program for reading any Month Number and displaying the Month name as a word. (Using Switch Case)

8. Write a C program to read temperature in centigrade and display a suitable message according to the temperature state below: (Using Else If Ladder)

Temp < 0 then Freezing weather

Temp 0-10 then Very Cold weather

Temp 10-20 then Cold weather

Temp 20-30 then Normal in Temp

Temp 30-40 then Its Hot

Temp >=40 then Its Very Hot

PPS PREPARATION 1

Preparation Questions 1:

1) Explain Basic structure of C Program with example.

2) List Data Types in C. Explain Primary Datatypes.

3) List and explain all operators with a program.

4) Practical 1 programs.

PPS PRACTICAL 1 EXTRA PROGRAM FOR HOME WORK

1. Write a program to find sum of two numbers.

2. Write a program to find area of rectangle. (Area = length * width)

3. Write a program to find area of square. (Area = length * length)

4. Write a program to calculate inch from centimeter. (inch = centimeter * 2.56)

5. Write a program to calculate average of two numbers.

6. Write a program to print ASCII value of a number.

PPS UNIT 2 MATERIAL

UNIT 2 MATERIAL : DOWNLOAD

ORACLE SOFTWARE DOWNLOAD LINK AND INSTALATION STEPS

ORACLE SOFTWARE DOWNLOAD LINK : DOWNLOAD

USER CREATE STEPS : DOWNLOAD