How would you determine who has added a row to a table? - 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

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

Category	DBA Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 1653 users
Added on	8/29/2016
Views	13430
Rate it!

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:-

There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.

	Related Questions	View Answer
	Name the three major set of files on disk that compose a database in Oracle?	View Answer
	How do you communicate with an RDBMS?	View Answer
	What is the job of the information stored in Data-Dictionary in case of DBMS?	View Answer
	Name the Sub-Systems of a RDBMS?	View Answer
	What is RDBMS Kernel?	View Answer
	What are the Primitive Operations, common to all record management systems?	View Answer
	What are Subqueries or Nested Queries in case of DBMS?	View Answer
	What is a Query in case of DBMS?	View Answer
	What is Transparent DBMS?	View Answer
	What do you mean by flat file database?	View Answer
	What are the different Phases of a Transaction in case of DBMS?	View Answer
	What is a Checkpoint in case of DBMS and When does it occur?	View Answer
	What is a Phantom Deadlock in case of DBMS?	View Answer
	What do you mean by Atomicity and Aggregation in case of DBMS?	View Answer
	What is Durability in DBMS?	View Answer
	What are the different Parameter types in case of RDBMS?	View Answer
	What is Indexing in case of DBMS and what are the different kinds of Indexing?	View Answer
	What are Partial, Alternate, Artificial, Compound and Natural Key in case of DBMS?	View Answer
	What is DKNF in case of DBMS?	View Answer
	What is 5NF in case of DBMS?	View Answer

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

Post your answer here