Tablespaces question

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
g_suri24
Posts: 22
Joined: Thu Feb 22, 2007 8:39 am
Location: India

Tablespaces question

Post by g_suri24 »

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 ..
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post by amirtai »

<font color="maroon">Apparently B and C are the correct choices. But "C" is also true for SALES db as well that's using LMT as a default.

"E" is not a correct answer, SALES db is by default creating LMT.

Amir
</font id="maroon">
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests