Explain the relationship among Database, Tablespace and Data
file?
Answers were Sorted based on User's Feedback
Answer / chaudhry
Each databases logically divided into one or more
tablespaces One or more data files are explicitly created
for each tablespace.
Is This Answer Correct ? | 8 Yes | 2 No |
Each data base is divided into logical units called table
spaces and each table space is again divided into segments.
Data files are created for table spaces.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
database contain atleast one tablespace and tablespace must have atleast one datafile
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / riddhi
An Oracle database consists of one or more logical storage
units called tablespaces.
tablespaces is consist of one or more datafiles.
Is This Answer Correct ? | 0 Yes | 0 No |
How to delete a column in an existing table in oracle?
What is memory advisor in Oracle?
What is an oracle and why it is used?
Can anyone give me information about oracle certification
How to set a transaction to be read only in oracle?
How to retrieve data from an explicit cursor?
what is query and types of query
Define Normalization with example?
What is redo log?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How to create tables for odbc connection testing?
Explain implicit cursor.