Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is TABLE SPACE?

Answers were Sorted based on User's Feedback



What is TABLE SPACE?..

Answer / hssk

A database is divided into logical storeage unit called
tablespaces.A tablespace is used to grouped related logical
structures together.

Is This Answer Correct ?    6 Yes 0 No

What is TABLE SPACE?..

Answer / dileep

A Table space is a logical group of data files in a data
base. a typical data base consists at least one table space,
and usually two or more. In a database a table space plays a
role similar to that of a folder on the hard drive of a
computer.

Is This Answer Correct ?    5 Yes 0 No

What is TABLE SPACE?..

Answer / m.m

Tablespace:
A database storage unit that groups related logical
structures together.

logical structures:
Logical structures of an Oracle database include table
spaces, schema objects, data blocks, extents, and segments.
Because the physical and logical structures are separate,
the physical storage of data can be managed without
affecting the access to logical storage structures.

physical structures:
Physical database structures of an Oracle database include
data files, redo log files, and control files.

data block:
Smallest logical unit of data storage in an Oracle
database. Also called logical blocks, Oracle blocks, or
pages. One data block corresponds to a specific number of
bytes of physical database space on disk.( a common block
size is 8k)

extent:
Second level of logical database storage. An extent is a
specific number of contiguous data blocks allocated for
storing a specific type of information.

segment:
Third level of logical database storage. A segment is a set
of extents, each of which has been allocated for a specific
data structure, and all of which are stored in the same
tablespace.


Datafile:
A physical operating system file on disk that was created
by Oracle and contains data structures such as tables and
indexes. A datafile can only belong to one database.

Is This Answer Correct ?    2 Yes 0 No

What is TABLE SPACE?..

Answer / mohan

Database is logically divided into three tablespaces. once
creates the database then automatically create tablespace
is also called SYSTEM tablepace.tablespace contain dta
dictionary of all data.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More SQL PLSQL Interview Questions

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  


what are the drivers in mysql? : Sql dba

0 Answers  


How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,


What are views in sql?

0 Answers  


What is sql keyword?

0 Answers  






what are null values? : Sql dba

0 Answers  


wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,


What are system versioned tables?

0 Answers  


When is a declare statement required?

0 Answers  


What is pl sql block structure?

0 Answers  


What is sql and how does it work?

0 Answers  


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  






Categories