| 8 Questions req. clarification for funda II exam [message #254439] |
Thu, 26 July 2007 14:28  |
itguru
Messages: 19
Registered: July 2007
|
Junior Member |
|
|
Answer are marked in bold letter. But I have some doubts written in ‘[ ]’ after q. If anyone can clarify it.
Thanks in advance.
-----------------------------------
29. Which two statements regarding the control file and Recovery
Manager are true? (Choose two)
A. The control file can grow in size.
B. The control file can store RMAN scripts.
C. CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN
records.
D. The RMAN catalog can exist solely in the control file of the
target database.
[ Is A also not correct ]
-----------------------------------
73. What is the purpose of importing from an export, and specifying
that no rows be imported and that the output goes to a log file?
A. To verify space requirements in the target database before
importing.
B. To generate the SQL for the DDL operations that would occur during
import.
C. To check character set compatibility between the export file and
the target database.
D. To check for integrity constraint violations that would occur in
the target database.
[many dumps says B too ]
-----------------------------------
Question: 92
You want to drop the TBS1 table space from your database.
You also want to delete the corresponding data files automatically,
and not have to do it
manually. What should you do?
A. Use the DROP DATA FILE command.
B. Use the DROP TABLE SPACE command.
C. Ensure that all database files are Oracle Managed Files before
using the DROP
TABLE SPACE command.D. Ensure that the DB_FILE_CREATE_DEST initialization parameter is
set before using the
DROP TABLE SPACE command
-----------------------------------
Question: 148
You need to import all definitions of objects belonging to the
TS_EMPLOYEES
table space by using the export file expdat.dmp.
Which import statement is correct?
A. imp hr/hr TABLES=(ts_employees) rows=y
B. imp system/manager FROMUSER=hr file=expdat.dmp
C. imp hr/hr TRANSPORT_TABLE SPACE=y file=expdat.dmp
D. imp system/manager TRANSPORT_TABLE SPACE=y
TABLE SPACE=ts_employees
[ is C & D both correct]
-----------------------------------
Question: 168
Your database runs in ARCHIVE LOG mode, and is backed up every Sunday
night
using RMAN scripts. On Friday your database crashes. Now you want to
use the
backups from last Sunday night to restore your database. How can you
do this?
A. You need to perform the restore manually, because your database
was running in ARCHIVE
LOG mode.
B. Issue the RECOVER command from within RMAN. RMAN determines which
data files to
restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN. RMAN
determines
which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATA FILES, RESTORE ARCHIVE LOGS, and RECOVER
commands from within RMAN.MAN determines which data files to restore,
and which archive
logs to use.
[What about C]
-----------------------------------
Question: 257
Users in your development database complain that they are getting the
following error while trying
to execute a query on the SALES_HISTORY table:
ERROR at line 1:
ORA-00942: table or view does not exist
While investigating the reason, you find that a hardware failure
occured, resulting in the loss of
one of the available disk drives used by the database. While waitinig
for a replacement drive, the
OBA removed the un-needed data from the database and during the
removl the
SALES_HISTORY table was dropped accidentally.
Within few minutes a second hardware failure corrupted another disk
drive, resulting in
the loss of the current online redo log files and the logical back
ups of the database. The redo log
files were not multiplexed and the current redo log file is not yet
archived.
Which recovery method would you follow to recover the SALES_HISTORY
table?
A - Open Database complete recovery
B - Cancel-Based incomplete recoveryC - Change-Based incomplete recovery
D - Closed Database complete recovery
E - Recovery using the backup control file
[ But how that will restore sales_history table, as when it got drop implicitly issue commit , switch redo log file]
-----------------------------------
Question: 318
Which statement is true regarding database writer process (DBWn)?
A - It writes only committed data to the data riles.
B - It synchronizes the database buffer cache and the data files
regularly.C - It makes changes to data blocks in the database buffer cache when
required.
D - It is possible to configure more than one database writer
process, but this is useful only on
uniprocessor systems
[ Is D also not correct ]
-----------------------------------
When We select naming method TSN_name [local] only SqlNET.ora file get updated or tnsname.ora too ?
|
|
|
|
|
|
|
|
| Re: 8 Questions req. clarification for funda II exam [message #254816 is a reply to message #254444] |
Sat, 28 July 2007 12:03  |
itguru
Messages: 19
Registered: July 2007
|
Junior Member |
|
|
| Michel Cadot wrote on Thu, 26 July 2007 14:41 | Do you want the answers to pass the test or do you want the correct answers?
Regards
Michel
|
Exam is over I am just now looking for answer. That too now of only 6 Questions
29. Which two statements regarding the control file and Recovery
Manager are true? (Choose two)
A. The control file can grow in size.
B. The control file can store RMAN scripts.
C. CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN
records.
D. The RMAN catalog can exist solely in the control file of the
target database.
[ Is A also not correct ]
-----------------------------------
73. What is the purpose of importing from an export, and specifying
that no rows be imported and that the output goes to a log file?
A. To verify space requirements in the target database before
importing.
B. To generate the SQL for the DDL operations that would occur during
import.
C. To check character set compatibility between the export file and
the target database.
D. To check for integrity constraint violations that would occur in
the target database.
[many dumps says B too ]
-----------------------------------
Question: 92
You want to drop the TBS1 table space from your database.
You also want to delete the corresponding data files automatically,
and not have to do it
manually. What should you do?
A. Use the DROP DATA FILE command.
B. Use the DROP TABLE SPACE command.
C. Ensure that all database files are Oracle Managed Files before
using the DROP
TABLE SPACE command.
D. Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLE SPACE command
-----------------------------------
Question: 148
You need to import all definitions of objects belonging to the
TS_EMPLOYEES
table space by using the export file expdat.dmp.
Which import statement is correct?
A. imp hr/hr TABLES=(ts_employees) rows=y
B. imp system/manager FROMUSER=hr file=expdat.dmp
C. imp hr/hr TRANSPORT_TABLE SPACE=y file=expdat.dmp
D. imp system/manager TRANSPORT_TABLE SPACE=y
TABLE SPACE=ts_employees
[ I feel D is more correct which will only import selected TS even expdat.dmp contain fill database]
-----------------------------------
Question: 168
Your database runs in ARCHIVE LOG mode, and is backed up every Sunday
night
using RMAN scripts. On Friday your database crashes. Now you want to
use the
backups from last Sunday night to restore your database. How can you
do this?
A. You need to perform the restore manually, because your database
was running in ARCHIVE
LOG mode.
B. Issue the RECOVER command from within RMAN. RMAN determines which
data files to
restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN. RMAN
determines
which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATA FILES, RESTORE ARCHIVE LOGS, and RECOVER
commands from within RMAN.MAN determines which data files to restore,
and which archive
logs to use.[What about C]
-----------------------------------
Question: 257
Users in your development database complain that they are getting the
following error while trying
to execute a query on the SALES_HISTORY table:
ERROR at line 1:
ORA-00942: table or view does not exist
While investigating the reason, you find that a hardware failure
occured, resulting in the loss of
one of the available disk drives used by the database. While waitinig
for a replacement drive, the
OBA removed the un-needed data from the database and during the
removl the
SALES_HISTORY table was dropped accidentally.
Within few minutes a second hardware failure corrupted another disk
drive, resulting in
the loss of the current online redo log files and the logical back
ups of the database. The redo log
files were not multiplexed and the current redo log file is not yet
archived.
Which recovery method would you follow to recover the SALES_HISTORY
table?
A - Open Database complete recovery
B - Cancel-Based incomplete recovery
C - Change-Based incomplete recovery
D - Closed Database complete recovery
E - Recovery using the backup control file
[ But how that will restore sales_history table, as when it got drop implicitly issue commit , switch redo log file]
| Quote: | [ One thing I feel to say to everyone Nothing personal & not target to a particular individual that if you know answer & want to post. But Y always trying to boost own ego thinking other one is duffer & seeking your help to clear exam. This thing I have even seen oracle.com]
|
[Updated on: Sat, 28 July 2007 12:21] by Moderator Report message to a moderator |
|
|
|
| Re: 8 Questions req. clarification for funda II exam [message #254817 is a reply to message #254816] |
Sat, 28 July 2007 12:34 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| itguru wrote on Sat, 28 July 2007 19:03 | One thing I feel to say to everyone Nothing personal & not target to a particular individual that if you know answer & want to post. But Y always trying to boost own ego thinking other one is duffer & seeking your help to clear exam. This thing I have even seen oracle.com
|
This is because there are a lot of people trying to squeeze their way through the exams the 'easy way'. We advise them that learning questions by heart, hoping to make it through the exam, will only lead to frustration afterwards, as they will fail each interview.
This has nothing to do with ego-busting, but purely a well-meant advice. We love Oracle and would like to see motivated people as out (future) collegues, not the lazy types.
|
|
|
|
| Re: 8 Questions req. clarification for funda II exam [message #254819 is a reply to message #254817] |
Sat, 28 July 2007 14:09 |
itguru
Messages: 19
Registered: July 2007
|
Junior Member |
|
|
It better to let them decide what better for them.
I am Oracle Student. Not working practically on it.
& As I am not working on Oracle so my most doubts on R&D I did & dumps questions.
I always look forward to discuss same with people who are working in it.
[As you can’t reply solely on faculty, as many times we are able to correct them, happen with me lot]
But dot know Y till date never got logical answer in 1st attempt.
Where i am doing wrong.
| Frank wrote on Sat, 28 July 2007 12:34 | | itguru wrote on Sat, 28 July 2007 19:03 | One thing I feel to say to everyone Nothing personal & not target to a particular individual that if you know answer & want to post. But Y always trying to boost own ego thinking other one is duffer & seeking your help to clear exam. This thing I have even seen oracle.com
|
This is because there are a lot of people trying to squeeze their way through the exams the 'easy way'. We advise them that learning questions by heart, hoping to make it through the exam, will only lead to frustration afterwards, as they will fail each interview.
This has nothing to do with ego-busting, but purely a well-meant advice. We love Oracle and would like to see motivated people as out (future) collegues, not the lazy types.
|
[Updated on: Sat, 28 July 2007 14:45] Report message to a moderator |
|
|
|
| Re: 8 Questions req. clarification for funda II exam [message #254824 is a reply to message #254819] |
Sat, 28 July 2007 16:00 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I can't help with any question except 73 as I'm not a DBA. So, why would ROWS=N LOG=some_logfile.txt SHOW=Y be helpful?
Imagine that you'd like to transfer functions and procedures from one database to another one. There's no option for doing that (using EXPORT and IMPORT utilities), but deciding NOT to import any records (it means that, if tables were empty, they would remain empty after importing) and logging output into a log file.
Log file would then contain all CREATE statements. You'd easily browse through it and - using the copy-paste technique - take out code you need.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
