Normalization in SQL, What is Cursor in SQL

Question

Accepted Answer

Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity. A cursor in SQL is a database object used to retrieve and manipulate data row by row.

Normalization in SQL involves breaking down a large table into smaller tables and defining relationships between them to reduce redundancy.
Cursors in SQL are used to fetch and process individual rows returned by a query.
Example of normalization: dividing a 'customer' table into 'customer' and 'orders' tables, linked by a customer ID.
Example of cursor: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

Accepted Answer

Cursor is a Temporary Memory or Temporary Work Station. It is Allocated by Database Server at the Time of Performing DML(Data Manipulation Language) operations on the Table by the User. Cursors are used to store Database Tables.

Normalization in SQL, What is Cursor in SQL

Top Hitachi System Engineer interview questions & answers

Popular interview questions of System Engineer