Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 33 of 95
26. What are the advantages of VIEW ? To protect some of the columns of a table from other users. To hide complexity of a query. To hide complexity of calculations. 27. Can a view be updated/inserted/deleted? If Yes under what conditions ? 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. 28.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. FORMS 3.0 BASIC 1.What is an SQL *FORMS ? SQL *forms is 4GL tool for developing and executing; Oracle based interactive application. 2. What is the maximum size of a form ? 255 character width and 255 characters Length. 3. Name the two files that are created when you generate the form give the filex extension ? INP (Source File) FRM (Executable File) 4. How do you control the constraints in forms ? Select the use constraint property is ON Block definition screen. BLOCK 5. Commited block sometimes refer to a BASE TABLE ? True or False. False. 6. Can we create two blocks with the same name in form 3.0 ? No. 7. While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. True. 8. What is a Trigger ? |