Create tables and load Data

Jun 18th, 2015
Studypool Tutor
Arizona State University
Course: General
Price: $20 USD

Tutor description

Case 1 : Create tables and load Data 1. Create a database and few tablespaces 2. Create below tables TableA AC1 integer AC2 char(5) AC3 varchar(10)

Word Count: 625
Showing Page: 1/4
Case Studies on DB2Case 1 : Create tables and load Data1. Create a database and few tablespaces2. Create below tables TableA AC1 integerAC2 char(5)AC3 varchar(10)AC4 dateAC5 timestampAC6 integerUniq index - AC1Secondary index - AC2 and AC4TableB BC1 integerBC2 char(5)BC3 BLOBBC4 CLOBUniq clustered index - BC1Secondary index - BC2 3. Insert 10 records each 4. Export data and import it back5. Create a file of 2-3 K records for TableA and load replace the dataCase 2 : Referential integrity1. Create RI between TABLEA and TABLEB2. Illustrate the ON delete cascade/restrict /set NULL options.3. Load replace the child table and check the table status4. DROP RICase 3 : Triggers and Stored procedure1. Create a trigger which will insert a row in TABLEC (New table) when a row is deleted from TABLEA2. Create a SP which will insert a record to TableA and then read all the rows from TableA and display the result setSelect * from TableA where AC6 =3. Do a explain of the package and run advise4. Create an index on TableA / AC6 5. Runstats on TableA6. Rebind the package and check explain againCase 4 : Range Partitioned table and Views1. Cre

Review from student

Studypool Student
" Excellent work as always thanks so much "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors