Why ‘Data Redundancy’ is higher in 1st Normal Form than other normal forms? Explain with example.
SIKSHAPATH Latest Questions
Given relation R (A,B,C,D) and the following FD’s. Identify the candidate key for R and highest normal form C->D, C->A, B->C
Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.
Write a PL/SQL block to display the last name of manager, and their departments for a particular city, using parameters with a default value in explicit cursor.
Draw the queue structure in each case when the following operations are performed on an empty queue. (a) Add A, B, C, D, E, F (b) Delete two letters (c) Add G (d) Add H (e) Delete four letters (f) Add I
Reverse the order of elements on stack S a. using two additional stacks b. using one additional queue c. using one additional stack and some additional non-array variables