| 10g dba administration queries [message #253737] |
Tue, 24 July 2007 14:31  |
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 #253753 is a reply to message #253737] |
Tue, 24 July 2007 14:56  |
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 .
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
