최신 1z1-034 무료덤프 - Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
정답: A,C
Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.
S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table
$ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1
What would be achieved by running the above commands?
S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table
$ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1
What would be achieved by running the above commands?
정답: C
UNDO__RETENTION is set to 1000 and retention is not guaranteed.
You configure the database with a fixed size undo tablespace.
Which is true about undo retention in this configuration?
You configure the database with a fixed size undo tablespace.
Which is true about undo retention in this configuration?
정답: C
Note the following parameter settings: Which setting is NOT allowed?
정답: B
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.
What would you suggest to analyze this performance problem for the user?
What would you suggest to analyze this performance problem for the user?
정답: B
You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the
retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the
retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
정답: B
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:
정답: A,B,D
The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?
정답: A,D
설명: (DumpTOP 회원만 볼 수 있음)
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?
How would you achieve this?
정답: C