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
SIKSHAPATH Latest Questions
Q.Write a block in PL/SQL to print the specific number of rows from a table.
Write a program in PL/SQL to show the uses of SQL%FOUND to determine if a DELETE statement affected any rows.
Write a query to create a view to getting a count of how many customers we have at each level of a grade.
Write a program in PL/SQL to FETCH multiple records and more than one columns from the same table.
Q.Write a program in PL/SQL to insert records from one table to another.