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
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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