|
INTERVIEW QUESTIONS
DATABASE
DBA
DETAILS
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.2) By 8862 users |
Added on |
8/29/2016 |
Views |
69076 |
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
|