Latest Answer : Drop user username cascade ...
Latest Answer : step1) Search "demobld.sql" file in the directory where you installed Oracle using Search option. step2) Make a copy of it (demobld.sql) in C drive or D drive step3)Execute "@c:demobld.sql" in sql prompt(If you copied that in C drive).step4)Oracle ...
What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?
Latest Answer : component based Arc:The database building structure depends upon to the component such as Kernel level.Advantage:The accessing speed will be more than other component. ...
You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen. For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies
What are latches in Oracle 9i Database? Can you name the latches.How do you resolve contention on latches.
Latest Answer : Navigation Trigger ...
What is meant by type of participation? Name the three types of relationship participation.
Latest Answer : I just know two types of Participation: Total and Partial.Lets take an example of 2 entities Department and Employee.
Relation: For each department there is an Head of the Department (who is an employee again). (Dept-Head-of-emp)So now for this relation ...
“Bigger the size of a Oracle package, the better”. Do you agree? Justify.
Latest Answer : No - I do not agreeFunctionality depends..What are you trying to do in a
package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete..
Purpose of a Package, For Eg.. If you create a Month End Package for a Co. It ...
