OraFAQ Forum: Training & Certification » In 10g Which of the following statements is not always true?

Home » Other » Training & Certification » In 10g Which of the following statements is not always true? (Solaris, 10.2g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

In 10g Which of the following statements is not always true? [message #310121]

Mon, 31 March 2008 06:20

Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh

Member

In 10g Which of the following statements is not always true?(select multiple if meet)
A. Every database has at least three tablespaces.
B. Every database has at least three datafiles.
C. Every database has at least three multiplexed redo logs.
D. At least three types of segments can exist in a database.

[Updated on: Mon, 31 March 2008 06:21]

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310123 is a reply to message #310121]

Mon, 31 March 2008 06:23

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Interview question must be posted in "Homework, certification, training" topic.

Answer is in Database Concepts

Regards
Michel

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310129 is a reply to message #310121]

Mon, 31 March 2008 06:31

Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh

Member

Thank you, I already read the concepts manual.
I want here answer, please so that we can discuss based on answer.

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310143 is a reply to message #310129]

Mon, 31 March 2008 07:15

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is your opinion BASED on the book?

Regards
Michel

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310308 is a reply to message #310121]

Mon, 31 March 2008 20:46

Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh

Member

All of the above.

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310338 is a reply to message #310308]

Tue, 01 April 2008 00:16

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Give complete answer: which ones for A, B and D?
What is the link/section in doc. you see they are all correct?

Regards
Michel

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310354 is a reply to message #310121]

Tue, 01 April 2008 00:44

Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh

Member

A. Every database has at least three tablespaces. is not always true
as I have only one system tablespace in my database , no more tablespace.

and also is for B.

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #310365 is a reply to message #310354]

Tue, 01 April 2008 00:58

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There are at least 3 tablespace: SYSTEM, SYSAUX and a UNDO tablespace or a tablespace containing rollback segments. Also it is hard to work without a temp tablespace but possible (for boundaries test only).

Regards
Michel

Report message to a moderator

Re: In 10g Which of the following statements is not always true? [message #311218 is a reply to message #310365]

Thu, 03 April 2008 14:13

kskywr
Messages: 1
Registered: April 2008

Junior Member

I agree with Michel. You need at least 3 tablespaces. Which would mean that B is true as well.

Report message to a moderator

Previous Topic:	syntax issue
Next Topic:	How long the training certificate valid for

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 23:22:32 CDT 2024