RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Oracle Indexes
«Prev
Next»
Managing Objects
Space Management
Storage Management Concepts
Data Blocks
Data System Blocks
Segment Role
Oracle extents Data
Extent Allocation
Setting Extent Size
Tablespace Default
Data Dictionary Storage
Oracle Free Space
Oracle Lists
Space Blocks
Free Space
Table Space Fragmentation
Tablespace Database Objects
Correct Table Space
Space Management Conclusion
Managing Tables
Create Oracle Table
Column Datatypes
Schema Manager Table
Generate Table List
Describing Table Columns
Modify Table Column
Delete Oracle Table
Schema Manager Conclusion
Managing Constraints
Four Basic Constraints
Primary Key Constraints
Database Table Constraints
Create Foreign Constraints
Unique Foreign Key Constraints
Table Trigger
Adding Table Constraints
Implement Column Constraints
Data Dictionary Constraints
Managing Constraints
Oracle Indexes
Oracle Database Index
Oracle Data Index
Index Types
Create Table Index
Separate Indexes-
Alter Index Attributes
Rebuilding Oracle Index
Data Dictionary Views
Drop Index Oracle
Using Oracle Indexes
Managing Privileges
Granting Privileges
Grant Command
Using Security Manager
Listing Table Privileges
Listing Privileges Columns
Revoking Object Privileges
Object Privileges Conclusion
Database Security Roles
Database Roles
Creating Roles
Granting Role Privileges
Default non Default Roles
Password Protected Roles
WITH ADMIN OPTION
Security granted By Roles
Invoker Caller Routine
View Information about Roles
Listing Granted Roles
Drop Database Role
Altering Oracle Indexes - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following is not a valid option for altering an index?
Please select the best answer.
A.
DROP COLUMN
B.
RENAME TO
C.
REBUILD
D.
COALESCE
2.
Which of the following are benefits from rebuilding indexes?
Please select all the correct answers.
A.
Save disk space for the index
B.
Resort the index
C.
Change the order of columns in the index
D.
Potentially improve I/O performance on the index
3.
What is the key difference between rebuilding and index and coalescing an index?
Please select the best answer.
A.
Coalescing an index saves more space.
B.
Rebuilding an index causes the index to be put in sorted order, while coalescing an index does not sort the index values.
C.
Rebuilding an index works on the whole index, while coalescing an index only affects the leaf blocks.
D.
Rebuilding an index works on the whole index, while coalescing an index only affects the index nodes.