ASSIGNMENT Lab 05: Table Management 1. Your manager wants to view how many table

Question

ASSIGNMENT Lab 05: Table Management

1. Your manager wants to view how many tables are index-organized and how many tables are partitioned. Write a script to find out those tables and view them in two separate lists with their pertinent details.

2. What is different between dropping a table, truncating a table, and deleting a table? Also, explain High Water Mark.

3. A user came to you and informed you that he/she has dropped a table from his/her schema. What would you suggest? Provide your solutions.

4. List information about segments, such as the extents, blocks, freelists, and buffer used for each table in the database.

5. Explain the different between USER_, ALL_, and DBA_ data dictionary tables.

Explanation / Answer

2. Answer :-

Dropping a Table :-

Dropping a Table removes a table from the database.

Truncating a Table :-

Truncating a Table removes all rows from a table.

Deleting a Table :-

Deleting a Table removes rows from a table.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.