Some tips to get good grades in 470 !!

ü Designing the Database normalized to at least 3NF or BCNF.

ü Creating the database through PL/SQL scripts

ü Using Views and Indexes

ü Creating functions, procedures, triggers and exceptions in PL/SQL

ü Using Alerts, Images, LOVs etc to make your interface user-friendly

ü Creating self-explanatory reports !

ü Using oracle sequences to generate unique identifiers for your primary key values.

ü Drawing ER-Model with cardinalities.

ü Using Form triggers for data validation.

ü Making use of PL/SQL CURSORS.

Sample Questions for Midterm and Final :

Q1. What five constraints are available in Oracle database?

Ans. NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK

Q2. Views restrict access to the database because the view can display selective portion of the database (True | False)

Ans. True.

Q3. What are three Logical block sections in PL/SQL.

Ans. Declarative, Executable, Exception Handling

Q4. What is the difference between char and varchar2 variables.

Ans. Varchar2 is a variable length character data type. Char is fixed length.

Q5. What is the difference between DDL and DML commands.

Q6. How do you get the next value from the sequence.

Ans. SequenceName.nextval.

Q7. How do you get the current value from the sequence.

Ans. SequenceName.currval.

Q8. How do you change the default Menu from the Form.

Ans. Changing the Form property using property pallet.

Q9. How you use parameter input in report.

Q10. What are different kinds of canvases available in Oracle Forms.

Q11. In Oracle forms, which should you compile, the .fmb file or the .fmx file ?

Q.12. How can you view database objects in Forms Builder ?

Q.13. A schema contains a table called "building" and a table called "lecture_hall".

A given building can have one or many lecture halls.

How would you create the master-detail form based on these two tables?(Which

table will be Master and which Detail ?

Q.14. When should you use an LOV?

Q.15. At what level can a WHEN-BUTTON-PRESSED trigger be created?