RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Managing DB Objects
Oracle Space Management
Managing Oracle Tables
Managing Oracle Constraints
Oracle Indexes
Oracle TableSpace - Quiz
Setting Oracle extent sizes
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.
