AceTheInterview
Jobs in Pune | Work better in teams | Socialize with friends | Submit Q&A | Tell a friend
Search site for 

Top 100 Interview Questions & Answers in a convenient and easy to read book!

“I bought this guide a few days ago to prepare for my interview with Oracle. Many of the questions they asked me were from this guide. I found this book absolutely great!”

– Ravi, California

Read more comments...

Interview Questions And Answers RSS Feed

Answers »

  1. Submitted By: Earl Kirkland — March 20, 2007
    +12 votes
      + -

    Data Warehousing is the technologies and STORAGE OF DATA so that the data is organized is such a way that it can be easily analyzed, extracted, synthesized, and otherwise understood by the end user.

    Data Mining is the actual QUERYING OF THE DATA in a Data Warehouse to understand the data by identifying patterns in the relationships between the data objects.

  2. Submitted By: kayn — May 5, 2007
    -1 votes
      + -

    dataware housing is responsible for keeping data while data mining is searching for a certain data

  3. Submitted By: gabriel — June 5, 2007
    +2 votes
      + -

    keeping the data in organized and user friendly way is data ware housing where as searching is data mining.

  4. Submitted By: amit — July 19, 2008
    +4 votes
      + -

    In a DBMS, a trigger is a SQL procedure that initiates an action (i.e., fires an action) when an event (INSERT, DELETE or UPDATE) occurs. Since triggers are event-driven specialized procedures, they are stored in and managed by the DBMS. A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion.

  5. Submitted By: Shemi — September 30, 2008
    +3 votes
      + -

    Triggers are stored procedures which are invoked automatically by the database server in response to DML statemants like insert, update and delete on the associated table. They are used to specify integrity constraints.

    Triggers can be areore triggers or after triggers.

    Row triggers : executed once for every record that is affected by DML statement.

    Statement trigger : executed only once(for a particular record) irrespective of the number of records that are affected.

  6. Leave an Answer/Comment

    To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
    Click to hear an audio file of the anti-spam word

Our Sponsors
Our Sponsors
Contact Us | FAQ | Sitemap | Terms of Use | Privacy Policy | Tell a Friend

Copyright © 1999-2006 Jeeve Technologies LLC. All rights reserved.