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 ?
|
|