Simple oracle trigger

From: FB <burnsfrances_at_eircom.net>
Date: 20 Feb 2003 06:28:32 -0800
Message-ID: <87e910ae.0302200628.4d86a6c2@posting.google.com>

I have a technical exam and need help with some oracle questions! I would be really grateful for help especially on writing a simple trigger as in question 8

8. Write separate triggers for Oracle and Microsoft SQLServer that will set
'ZIP_YN' to '0' if 'ZIP_CODE' is empty and set 'ZIP_YN' to '1' if
'ZIP_CODE'

has a value when a record is added or modified.

4. In Oracle 8i, which command will delete all data from a table and will
not write to the rollback segment?

a. Drop
b. Delete
c. Cascade
d. Truncate
 
5. Select the VALID trigger types in Oracle 8i
a. AFTER statement trigger
b. INSERT row trigger

c. DELETE row trigger
d. UPDATE row trigger

6. In Oracle 8i, which of the following contains the records of all transactions that occur in the database and plays an essential part in database recovery?

a. Control files
b. Datafiles
c. Parameter file
d. Redo log files

Received on Thu Feb 20 2003 - 08:28:32 CST