What is a Data Segment ?
Answers were Sorted based on User's Feedback
Answer / narendra
Data Segment is a collection of extents used to store the data of a table and the table can be a non-clustered table, a clustered table, or a partitioned table, so we can also call Data Segment as Table Segment.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / nishi
Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / orawhiz
Each Non-clustered table has a data segment. All of the table's
data is stored in the extents of its data segment. Each
cluster has a data segment. The data of every table in the
cluster is stored in the cluster's data segment.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to define default values for formal parameters?
Give the constructs of a package, function or a procedure.
How you open and close a cursor variable.Why it is required?
What are nested tables?
how to use sequence and what use of sequence cache
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is an Oracle Instance?
What are oracle functions?
How to write date and time literals in oracle?
How many categories of data types in oracle?
What is dictionary cache ?
How to get execution statistics reports on query statements?