InterviewUp – Job Interview Questions and Answers – Difference between database triggers and form...

Difference between database triggers and form triggers.

Comments (0) |

Inappropriate

Asked By: deke

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

a) Data base trigger(DBT) fires when a DML operation is performed on a data base table.Form trigger(FT) Fires when user presses a key or navigates between fields on the screen b) Can be row level or statement level No distinction between row level and statement level. c) Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms. d) Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger. e) Can cause other database triggers to fire.Can cause other database triggers to fire,but not other form triggers.

Tags

Edit

oracle

Asked At

Edit

oracle

Job Titles

Edit

systems administrator

Comments (0) :

Your Name:

Add your comment text

Tags

database

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

Rachit

Saturday, July 04, 2009 1:57 PM

gdb is 1 of the debuggers used in Unix

See all 1 comments

305

What is Fully Functional dependency?

Add or view comments about this interview question

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: mariann |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It is based on concept of full functional dependency. A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

Create Date

Tuesday, May 13, 2008

Tags

database, RDBMS, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

279

What is database?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

210

What is DBMS?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

283

What is a Database system?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The database and DBMS software together is called as Database system.

Create Date

Tuesday, May 13, 2008

Tags

database, RDBMS, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

227

Describe the three levels of data abstraction?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The are three levels of abstraction:
Physical level: The lowest level of abstraction describes how data are stored.
Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level: The highest level of abstraction describes only part of entire database.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions