Results 1 to 3 of 3

Thread: What is drawback of cursor?

  1. #1
    Banned
    Join Date
    Apr 2009
    Posts
    1,417
    Rep Power
    0

    What is drawback of cursor?

    Advertisement

    What is drawback of cursor?

    Advertisement

    • Implicit cursors are less efficient than explicit cursors
    • Implicit cursors are more vulnerable to data errors
    • Implicit cursors provide less programmatic control

  2. #2
    Banned
    Join Date
    Apr 2009
    Posts
    1,417
    Rep Power
    0

    What is Data Block?

    What is Data Block?


    • Data blocks are also called logical blocks, Oracle blocks, or pages.
    • At the finest level of granularity, Oracle stores data in data blocks.
    • A data block corresponds to a specific number of bytes of physical database space on disk.

  3. #3
    Banned
    Join Date
    Apr 2009
    Posts
    1,417
    Rep Power
    0
    What are the uses of Rollback Segment?


    • Rollback segments undo changes when a transaction is rolled back
    • They also ensure that transactions leave the uncommitted changes unnoticed.
    • They can be used to recover the database to a consistent state in case of failures.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •