Home » Other » Training & Certification » 10g dba administration queries
10g dba administration queries [message #253737] Tue, 24 July 2007 14:31 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am preparing for 1Z0 - 042 exam . I came across a few questions in which I was not sure of the answer . Let me know the correct choice .

1) which two steps are performed the first time any update statement is issued after instance is started ?

a) creating parse tree of statement
b) writing modified data blocks to data files
c) writing modified data blocks to archived redo log files
d) updating control file to indicate most recent checkpoint
e) updating data file header to indiacte most recent checkpoint
f) reading blocks to database buffer cache if they are not alreay there

2) users with dba role are using more cpu resources that allocated in their profiles .
which action should be taken to ensure that resource limits are imposed on those users ?

a) assign default profile to users
b) set resource limit parameter to true in parameter file
c) create new profile with cpu restrictions and assin it to users
d) specify users as members of default_consumer_group

3) database has been configured with automatic undo management . undo retention is set to 3 hrs .
i wanna flshback a table that was created last year ? how far back can flashback query go

a) 3 hours
b) until point when unto tablespace winstance would abort in such cases as refreshed
c) until database is shutdown and memeory erased

4) media failure has occurred resulting in loss of all control files in database . which statement regarding database instance is true ?

a) instance would hang
b) instance needs to be shut down
c) instance would remain open
d) instance would abort in such cases
e) instance would be open and invalid
f) instance would be open but background process will be restarted

5) index has been created on column containing 10000 rows.later a value of column is updated
how does the change affect the index?

a) leaf will be marked invalid
b) update of leaf row takes place
c) index will be updated automatically on commit
d) leaf row will be deleted and inserted

6) database is in noarchivelog mode . database has been configured with 3 redo log groups and 5 log switches.
one non system critical datafile is lost . how to recover datafile now ?

a) recover all datafiles and open database.
b) create datafile and perform tablespace recovery .
c) no need to restore any datafile , just can recover database.
d) recover only lost datafile and perform tablespace recovery.

7) whether a tablespace created in oracle 9.2.0 is dictionary managed or locally managed by default ?

8 ) which statement regarding logging clause of create tablespace is correct ?

a) this clause not valid for temporary and undo tablespace
b) if tablespace is in nologging mode no operation will generate redo
c) tablespace level logging attribute can be overriden by logging specification at
table , view , index , partition level.


Please provide me the correct answers .
Re: 10g dba administration queries [message #253743 is a reply to message #253737] Tue, 24 July 2007 14:36 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Google doesn't work ?

It sure would be a better learning process than being spoon fed the answers.
Re: 10g dba administration queries [message #253746 is a reply to message #253737] Tue, 24 July 2007 14:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please provide me the correct answers

Please provide your answers and why you think it is or it is correct.

Regards
Michel
Re: 10g dba administration queries [message #253753 is a reply to message #253737] Tue, 24 July 2007 14:56 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
1) which two steps are performed the first time any update statement is issued after instance is started ?

a) creating parse tree of statement
b) writing modified data blocks to data files
c) writing modified data blocks to archived redo log files
d) updating control file to indicate most recent checkpoint
e) updating data file header to indiacte most recent checkpoint
f) reading blocks to database buffer cache if they are not alreay there

answer according to me : a,f

but in the book that i am studying it has been specified as c,d . so was confused

2) users with dba role are using more cpu resources that allocated in their profiles .
which action should be taken to ensure that resource limits are imposed on those users ?

a) assign default profile to users
b) set resource limit parameter to true in parameter file
c) create new profile with cpu restrictions and assin it to users
d) specify users as members of default_consumer_group

answer according to me : c and b

in the book it has been given as b

3) database has been configured with automatic undo management . undo retention is set to 3 hrs .
i wanna flshback a table that was created last year ? how far back can flashback query go

a) 3 hours
b) until point when unto tablespace was refreshed
c) until database is shutdown and memeory erased

anwer according to me : a

but i dont understand what is meant by undo tablespace being refreshed

4) media failure has occurred resulting in loss of all control files in database . which statement regarding database instance is true ?

a) instance would hang
b) instance needs to be shut down
c) instance would remain open
d) instance would abort in such cases
e) instance would be open and invalid
f) instance would be open but background process will be restarted

i am not aware of this

5) index has been created on column containing 10000 rows.later a value of column is updated
how does the change affect the index?

a) leaf will be marked invalid
b) update of leaf row takes place
c) index will be updated automatically on commit
d) leaf row will be deleted and inserted

answer according to me : c

answer given in book is : d

6) database is in noarchivelog mode . database has been configured with 3 redo log groups and 5 log switches.
one non system critical datafile is lost . how to recover datafile now ?

a) recover all datafiles and open database.
b) create datafile and perform tablespace recovery .
c) no need to restore any datafile , just can recover database.
d) recover only lost datafile and perform tablespace recovery.

i am not aware of this

7) whether a tablespace created in oracle 9.2.0 is dictionary managed or locally managed by default ?

think so all tablespaces are locally managed by default from oracle 9i

8 ) which statement regarding logging clause of create tablespace is correct ?

a) this clause not valid for temporary and undo tablespace
b) if tablespace is in nologging mode no operation will generate redo
c) tablespace level logging attribute can be overriden by logging specification at
table , view , index , partition level.

according to me : a,b

answer given in book : a,c

pls guide me .
Re: 10g dba administration queries [message #253754 is a reply to message #253753] Tue, 24 July 2007 14:57 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CAUTION::Most of the testking,actualtest dumps answers are wrong.
Re: 10g dba administration queries [message #253769 is a reply to message #253737] Tue, 24 July 2007 15:41 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
Let me know if the answers specified by me are correct or wrong
Re: 10g dba administration queries [message #253778 is a reply to message #253769] Tue, 24 July 2007 16:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I will recommend you to study ADMIN1 and ADMIN2,you wil get all answer in detail.
Re: 10g dba administration queries [message #253788 is a reply to message #253737] Tue, 24 July 2007 16:47 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
are they any materials available in this site or are you speaking about the general admin 1 and admin 2 books for certification ?
Re: 10g dba administration queries [message #253831 is a reply to message #253769] Wed, 25 July 2007 00:55 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Let me know if the answers specified by me are correct or wrong

Post why you think about these answers.

Regards
Michel
Previous Topic: Oracle 9i OCA Logo
Next Topic: wants address of oracle application training centers in delhi/NCR
Goto Forum:
  


Current Time: Thu Dec 08 02:24:59 CST 2016

Total time taken to generate the page: 0.26750 seconds