PLSQL= 1.What is cursor &types 2. Diff btw primay key &unique key. 3.triggers & its type. 4. View &its types. 4.bulk collection. 5.what is dynamic query & how to implement.

Question

Accepted Answer

Answers to questions related to PL/SQL concepts like cursor, primary key, unique key, triggers, views, bulk collection, and dynamic queries.

A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statement
Primary key uniquely identifies each record in a table, while a unique key ensures that all values in a column are distinct
Triggers are stored programs that are fired automatically in response to specific events or changes in the database
Views are virtual tables that are based on the result of an SQL statement and can be used to simplify complex queries
Bulk collection is a feature that allows you to process multiple rows of data at once
Dynamic queries are SQL statements that are constructed at runtime based on user input or other factors

PLSQL= 1.What is cursor &types 2. Diff btw primay key &unique key. 3.triggers & its type. 4. View &its types. 4.bulk collection. 5.what is dynamic query & how to implement.

Top Amdocs Software Engineer interview questions & answers

Popular interview questions of Software Engineer

Top HR questions asked in Amdocs Software Engineer

PLSQL= 1.What is cursor &amp;types 2. Diff btw primay key &amp;unique key. 3.triggers &amp; its type. 4. View &amp;its types. 4.bulk collection. 5.what is dynamic query &amp; how to implement.

Top Amdocs Software Engineer interview questions & answers

Popular interview questions of Software Engineer

Top HR questions asked in Amdocs Software Engineer

PLSQL= 1.What is cursor &types 2. Diff btw primay key &unique key. 3.triggers & its type. 4. View &its types. 4.bulk collection. 5.what is dynamic query & how to implement.