 Related Questions Answer posted by Scott on 2005-05-25 18:39:48: When you create a sequence with CYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will start over at the MINVALUE. This is not Latest Answer : when a sequence is created with CYCLE option, this mean that when a sequence reaches its MAXVALUE, it will start over at the MINVALUE. The CYCLE option is not wise for the primary key column.And when a sequence is created with NOCYCLE option, this ... Latest Answer : Hi Rampratap, U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?Thanks Pratima ... Latest Answer : If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers. ... Latest Answer : if a view based on one table or multiple table matter is it should contain all not null columns and additionaly no calculated column then ant DML statement will cause changes in base table. ... Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version; Latest Answer : Just type define on your sql prompt ..you will get required info.. ... When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed. Latest Answer : Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true ... To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations. Latest Answer : Advantages of view:1. Restricts the access to particular columns and rows of the base tables.2. Hide the data complexity.3. Can access the data for two different base tables with out performing a join.4. Can display the data in different form from the ... A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible. Latest Answer : Take an example Table : Employee(id number primary key,name varchar2(20),departmentid number)If created view in such a fashion, it includes all Not Null attribues & it does not contains group by and disctinct key word, then view is updatableUpdatab;e/insertable ... If a View on a single base table is manipulated will the changes be reflected on the base table ? If changes are made to the tables which are base tables of a view will the changes be reference on the view. Latest Answer : In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to prevent access from users on complete data on table. whenever ... Read Answers (2) | Asked by : ashok
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
