Home » RDBMS Server » Server Administration » tablespaces (oracle 10g and 9i)
tablespaces [message #420169] Thu, 27 August 2009 06:28 Go to next message
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 #420171 is a reply to message #420169] Thu, 27 August 2009 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Answer: B, E

Correct.

Quote:
I think E is not a right option because by default in 9i tablespaces are locally managed. right?

Wrong.

Regards
Michel
Re: tablespaces [message #420176 is a reply to message #420171] Thu, 27 August 2009 07:25 Go to previous messageGo to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
Please can u explain.

And what about the option C .
Re: tablespaces [message #420190 is a reply to message #420169] Thu, 27 August 2009 08:33 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I do not know why E is correct either? Am I having a stroke?
Re: tablespaces [message #420196 is a reply to message #420176] Thu, 27 August 2009 09:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
g_suri24 wrote on Thu, 27 August 2009 14:25
Please can u explain.

And what about the option C .

Because you can have DMT tablespace in 10g and this is the default if SYSTEM tablespace is DMT.

Regards
Michel

Re: tablespaces [message #420199 is a reply to message #420190] Thu, 27 August 2009 09:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
joy_division wrote on Thu, 27 August 2009 15:33
I do not know why E is correct either? Am I having a stroke?

Because default format for SYSTEM tablespace is DMT and, if you don't change it, default format for other tablespaces is DMT.

Regards
Michel

Re: tablespaces [message #420241 is a reply to message #420199] Thu, 27 August 2009 13:26 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Really? I always thought the default even for SYSTEM tablespace was LMT starting in v9.
Re: tablespaces [message #420243 is a reply to message #420241] Thu, 27 August 2009 13:51 Go to previous message
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

Previous Topic: Basic questions on Oracle
Next Topic: index problem
Goto Forum:
  


Current Time: Sat Nov 09 16:41:28 CST 2024