Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 12602 Views
- I also Faced
- E-Mail Answers
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 |
a query to select maxmun 3 salaries of employee table
After using set unused can we enable the column again to use? Please give me some answers....
How a database is related to tablespaces?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is a Sequence ?
What happens to the current transaction if a ddl statement is executed?
What is a tns service name?
What is the sql query to concatenate column values from multiple rows in oracle?
Why is oracle used?
What are the database administrators utilities available?
What are the execution control statements?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Oracle General 
