Search Interview Questions
Question: How would you determine who has added a row to a table?
Answer: A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the entire statement or once for every row that is inserted, updated, or deleted. For any one table, there are twelve events for which you can define database triggers. A database trigger can call database procedures that are also written in PL/SQL
|
|||||||||||
Question: How would you determine who has added a row to a table?
Answer: A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the entire statement or once for every row that is inserted, updated, or deleted. For any one table, there are twelve events for which you can define database triggers. A database trigger can call database procedures that are also written in PL/SQL Source: CoolInterview.com If you have the better answer, then send it to us. We will display your answer after the approval Rules to Post Answers in CoolInterview.com:-
|
Related Questions | ||
Name the three major set of files on disk that compose a database in Oracle? |
|
|
How do you communicate with an RDBMS? |
|
|
What is the job of the information stored in Data-Dictionary in case of DBMS? |
|
|
Name the Sub-Systems of a RDBMS? |
|
|
What is RDBMS Kernel? |
|
|
What are the Primitive Operations, common to all record management systems? |
|
|
What are Subqueries or Nested Queries in case of DBMS? |
|
|
What is a Query in case of DBMS? |
|
|
What is Transparent DBMS? |
|
|
What do you mean by flat file database? |
|
|
What are the different Phases of a Transaction in case of DBMS? |
|
|
What is a Checkpoint in case of DBMS and When does it occur? |
|
|
What is a Phantom Deadlock in case of DBMS? |
|
|
What do you mean by Atomicity and Aggregation in case of DBMS? |
|
|
What is Durability in DBMS? |
|
|
What are the different Parameter types in case of RDBMS? |
|
|
What is Indexing in case of DBMS and what are the different kinds of Indexing? |
|
|
What are Partial, Alternate, Artificial, Compound and Natural Key in case of DBMS? |
|
|
What is DKNF in case of DBMS? |
|
|
What is 5NF in case of DBMS? |
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All DBA Interview Questions & Answers - Exam Mode / Learning Mode
India News Network |