tablespaces [message #420169] |
Thu, 27 August 2009 06:28 |
g_suri24
Messages: 13 Registered: January 2007 Location: hyderabad
|
Junior Member |
|
|
Please see the attached file for database_properties view and read the question
You have two database, SALES and HR; created on the same machine using Oracle database 10g. For the SALES database, the
initialization parameter COMPTIBLE is set to 9.2.0 and for the HR database, COMPATIBLE is set to 10.0 .0.
The sales_tbs tablespace is create in the SALES database as follows:
CREATE TABLESPACE sales_tbs DATAFILE '/Company/Companydata/sales_tbs.dbf';
The hr_tbs tablespace created in the HR database is as follows:
CREATIVE TABLESPACE hr_tbs DATAFILE '/Company/Companydata/hr_tb s.dbf' SIZE 50M
Which two statements are correct in this scenario?
A. Hr_tbs is a bigfile tablespace.
B. A bigfile tablespace cannot be created in the SALES database
C. All tablespaces in HR database will be locally managed by default.
D. Sales_tbs and hr_tbs tablespaces can share the same data file.
E. All the tablespaces in the SALES database will be dictionary managed by default.
Answer: B, E
for the above question i suspect B,C is the answer. what do u say ?
I think E is not a right option because by default in 9i tablespaces are locally managed. right?
Please do reply ..
|
|
|
|
|
|
|
|
|
Re: tablespaces [message #420243 is a reply to message #420241] |
Thu, 27 August 2009 13:51 |
|
Michel Cadot
Messages: 68711 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
This is a common mistake because DBCA creates SYSTEM tablespace as LMT by default (not sure you can change it) but the default for CREATE DATABASE statement is DMT.
Regards
Michel
[Updated on: Thu, 27 August 2009 13:53] Report message to a moderator
|
|
|