Home » Other » Training & Certification » In 10g Which of the following statements is not always true? (Solaris, 10.2g)
In 10g Which of the following statements is not always true? [message #310121] Mon, 31 March 2008 06:20 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion BASED on the book?

Regards
Michel
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 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
All of the above.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
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 Go to previous messageGo to next message
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.

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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
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 Go to previous message
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.
Previous Topic: syntax issue
Next Topic: How long the training certificate valid for
Goto Forum:
  


Current Time: Fri Dec 09 07:41:22 CST 2016

Total time taken to generate the page: 0.14320 seconds