Answer to Question #63224 in Databases | SQL | Oracle | MS Access for jonney
2- a range-based partitioning table named p_student with attributes empno,empname,job,salary,department no. Make sure that the data entry of the each department goes to its own provided tablespaces such as the cs department goes to the dept10ts tablespace, the data entry of the cis department goes to the dept20ts tablespace, OTHERS goes to other_dept tablespace. specify the storage size parameter .
3- have the parallel query option, then the fastest method to create a table that has the same columns as the p_STUDENT table, but only for those student in department CS.
SALARY number(9, 2),
partition by list (DEPARTMENT_NO) (
partition q_cs values ('CS') tablespace dept10ts,
partition q_cis values ('CIS') tablespace dept20ts,
partition q_others values (DEFAULT) storage (initial 2M) tablespace other_dept
create table P_STUDENT_CS as
(select * from P_STUDENT where DEPARTMENT_NO = 'CS');
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!