• About
    1. Asked: October 20, 2021In:

      Write a program in PL/SQL to FETCH multiple records and more than one columns from the same table.

      Professor
      Professor

      DOWNLOAD ATTACHMENT FOR ANSWER ALSO THUMBS UP FOR SUPPORT.

      DOWNLOAD ATTACHMENT FOR ANSWER

      ALSO THUMBS UP FOR SUPPORT.

      See less
      Attachment

    2. Asked: October 20, 2021In:

      Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.

      Professor
      Professor

      DOWNLOAD ATTACHMENT:

      DOWNLOAD ATTACHMENT:

      See less
      Attachment

    3. Asked: October 20, 2021In:

      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.

      Professor
      Professor

      DOWNLOAD ATTACHMENT FOR ANSWER:

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    4. Asked: October 20, 2021In:

      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

      Professor
      Professor

      DOWNLOAD ATTACHMENT FOR ANSWER:

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    5. Asked: October 20, 2021In:

      Why ‘Data Redundancy’ is higher in 1st Normal Form than other normal forms? Explain with example.

      Professor
      Professor

      DOWNLOAD ATTACHMENT FOR ANSWER:

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    6. Asked: October 20, 2021In:

      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

      Professor
      Professor

      DOWNLOAD ATTACHMENT FOR ANSWER:

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment