Please solve time : 1 hour

There is a table with collection (nested table): COMPANIES(C_NUMB, C_NAME, C_TYPE, CLERKS (C_NUM, C_NAME, GENDER, SALARY). Please create the object view to achieve companies names and sum of clerks salaries in every company. Write a corresponding SQL, to extract data from object view. Create table STUDENTS with complex row type objects. Row type object STUDENT has attributes: NUM, NAME, MARKS. Attribute MARKS is sub-object with attributes: MARK_1, MARK_2, MARK_3. Insert two row data in the table STUDENTS. There is relational table DATABASE_SYSTEMS(S_NUM, S_NAME, S_TYPE). Write a PL/SQL program, what extracts all object-relational (S_TYPE) database systems numbers and names in PL/SQL table RESULT. There are two object types: COMPUTER (C_NUM, C_NAME, C_TYPE) and PRINTER (P_NUM, P_NAME, P_TYPE). Please: create appropriate tables; insert 2 rows in both tables; connect tables with object reference 1 1; write object SQL query to achieve computer names and appropriate printer names. There is a collection of rings. Every ring has number (NUM) and radius (RAD). Please create object table RINGS(NUM, RAD) with row type objects and object method COMPARE, which compare rings by squares. Please write object SOL query, using created object method, to achieve a sorted list of rings. In database we have table STUDENTS (S_NUM, S_NAME, GENDER, GROUP). Please write Java program and comment the commands to extract all womens from table. What types of XML data storage in database you use and what characteristic features they have