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 update values in a table in oracle?
What is the difference between hot backup and cold backup in oracle?
What is the usage of synonyms?
How would you design a database for an e-commerce website?
What is a dynamic performance view in oracle?
waht is the difference between primary key and super key?
what are the advantages of running a database in archive log mode?
what is a view?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
candidate key is subset of super key but not vice-verse explain
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.