Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple oracle trigger
You are too lazy to read the docs for an exam YOU will get credit for if you
pass. If you send me $500 I'll answer these questions for you.
Jim
"FB" <burnsfrances_at_eircom.net> wrote in message
news:87e910ae.0302200628.4d86a6c2_at_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 - 09:28:53 CST