Problem 1: [40 points] Write a PL/SQL function that given email of an editor, compute the number of papers assigned to the editor with pending reviews. A paper with pending review means that the paper has some reviews with NULL receive_date. This function also checks a special case when the editor email does not match any existing editors, and returns -1 in this case. Please also write an anonymous PL/SQL program to call this function with a few different editor emails to test both the regular and special case.

4. a1. vince owns a television repair shop that is insured undera commercial package policy. the policy includes thebuilding and personal property coverage form and thecauses-of-loss broad form. the declarations page indicatesthat coverage applies to both the building and the namedinsured's business property. explain whether or not thefollowing losses would be covered under his policy.a. a fire occurs on the premises, and the building isbadly damaged.b. a burglar steals some money and securities from anunlocked safe.c. a business computer is damaged by vandals whobreak into the shop after business hours.d. a tornado touches down near the store. several tel-evision sets of customers in the shop for repair aredamaged in the storm.til

Match the file formats with the types of multimedia they can store

How does the use of e-mail benefit business communications? it can be sent at any time. it is faster than regular mail. it improves writing skills. it is less expensive than using a courier. it reduces the need for proofreading.