RelationalDBDesign
RelationalDBDesign
SiteMap
Creation
Admin
Connect
Objects
Space Management
«Prev
Next»
Managing Objects
Space Management
Coalesce Tablespace
Storage Management Concepts
Setting Extent Size
Table Space Fragmentation
Correct Table Space
Data System Blocks
Managing Tables
Schema Manager Table
Creating Table Syntax
Managing Constraints
Four Basic Constraints
Primary Key Constraints
Data Dictionary Constraints
Oracle Indexes
Oracle Database Index
Drop Index Oracle
Managing Privileges
Listing Privileges Columns
Revoking Object Privileges
Oracle TableSpace - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following SQL statements will not allow you to set storage parameters?
Please select the best answer.
A.
CREATE TABLE
B.
CREATE TABLESPACE
C.
CREATE DATABASE
D.
CREATE INDEX
2.
If the
NEXT
parameter for an extent is 100K and the
PCTINCREASE
parameter is 50, the third extent allocated will be?
Please select the best answer.
A.
50K
B.
100K
C.
150K
D.
225K
3.
Specifying default storage parameters for a tablespace can do which two things?
Please select all the correct answers.
A.
You can set storage parameters when you create or alter a table.
B.
If you specify storage parameters for a table, all segments in the table use them.
C.
You must specify storage parameters for each object.
D.
Specifying default storage parameters for a tablespace can decrease maintenance overhead.