显示标签为“1Z0-053”的博文。显示所有博文
显示标签为“1Z0-053”的博文。显示所有博文

2014年6月30日星期一

1Z1-478参考書勉強、1Z0-053資格問題集

進歩を勇敢に追及する人生こそ素晴らしい人生です。未来のある日、椅子で休むとき、自分の人生を思い出したときに笑顔が出たら成功な人生になります。あなたは成功な人生がほしいですか。そうしたいのなら、速くIT-Passports.comのOracleの1Z1-478試験トレーニング資料を利用してください。これはIT認証試験を受ける皆さんのために特別に研究されたもので、100パーセントの合格率を保証できますから、躊躇わずに購入しましょう。

最近のわずかの数年間で、Oracleの1Z0-053認定試験は日常生活でますます大きな影響をもたらすようになりました。将来の重要な問題はどうやって一回で効果的にOracleの1Z0-053認定試験に合格するかのことになります。この質問を解決したいのなら、IT-Passports.comのOracleの1Z0-053試験トレーニング資料を利用すればいいです。この資料を手に入れたら、一回で試験に合格することができるようになりますから、あなたはまだ何を持っているのですか。速くIT-Passports.comのOracleの1Z0-053試験トレーニング資料を買いに行きましょう。

IT-Passports.comの専門家チームがOracleの1Z0-053認証試験に対して最新の短期有効なトレーニングプログラムを研究しました。Oracleの1Z0-053認証試験に参加者に対して30時間ぐらいの短期の育成訓練でらくらくに勉強しているうちに多くの知識を身につけられます。

試験番号:1Z1-478 復習問題集
試験科目:Oracle SOA Suite 11g Essentials
問題と解答:全75問

>>詳しい紹介はこちら

試験番号:1Z0-053 試験過去問
試験科目:Oracle Database 11g: Administration II
問題と解答:全698問

>>詳しい紹介はこちら

関連する研究資料によって、Oracleの1Z1-478認定試験は非常に難しいです。でも、心配することはないですよ。IT-Passports.comがありますから。IT-Passports.comには豊富な経験を持っているIT業種の専門家が組み立てられた団体があって、彼らは長年の研究をして、最も先進的なOracleの1Z1-478試験トレーニング資料を作成しました。資料は問題集と解答が含まれています。IT-Passports.comはあなたが試験に合格するために一番適用なソースサイトです。IT-Passports.comのOracleの1Z1-478試験トレーニング資料を選んだら、あなたの試験に大きなヘルプをもたらせます。

IT-Passports.comのOracleの1Z1-478試験トレーニング資料は受験生が模擬試験場で勉強させます。受験生は問題を選べ、テストの時間もコントロールできます。IT-Passports.comというサイトで、あなたはストレスと不安なく試験の準備をすることができますから、一般的な間違いを避けられます。そうしたら、あなたは自信を得ることができて、実際の試験で経験を活かして気楽に合格します。

ただ一つの試験の準備をするだけで時間をたくさん無駄にすることをやめてください。はやくIT-Passports.comの1Z1-478問題集を入手しましょう。この問題集を持っていたら、どうやって効率的に試験の準備をすべきなのかをよく知るようになります。この1Z1-478問題集はあなたを楽に試験に合格させる素晴らしいツールですから、この成功できチャンスを見逃せば絶対後悔になりますから、尻込みしないで急いで行動しましょう。

IT-Passports.comの1Z0-053問題集というものをきっと聞いたことがあるでしょう。でも、利用したことがありますか。「IT-Passports.comの1Z0-053問題集は本当に良い教材です。おかげで試験に合格しました。」という声がよく聞こえています。IT-Passports.comは問題集を利用したことがある多くの人々からいろいろな好評を得ました。それはIT-Passports.comはたしかに受験生の皆さんを大量な時間を節約させ、順調に試験に合格させることができますから。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード:http://www.it-passports.com/1Z1-478.html

NO.1 Identify two correct descriptions of Oracle Web Services Manager (OWSM).
A. It enables you to externalize web services security from the applications youbuild.
B. It manages policies in a distributed policy manager that serves as a single policy enforcement
point.
C. Use security and management events, captured by OWSM agents, are displayed using Oracle
BAM.
D. It supplies predefined security policies that enable declarative security and management
definition.
E. It uses Oracle Event Processing (OEP) to determine when security violations have occurred.
Answer: B,C

Oracle入門   1Z1-478番号   1Z1-478認定   1Z1-478参考書
Explanation:
Note: *Oracle WSM allows companies to (1) centrally define and store declarative policies applied
to the multiple web services making up a SOA infrastructure, (2) locally enforce security and
management policies through configurable agents, and (3) monitor runtime security events such as
failed authentication or authorization.
*Oracle Web Services Manager offers a comprehensive and easy-to-use solution for policy
management and security of service infrastructure. It provides visibility and control of the policies
through a centralized administration interface offered by Oracle Enterprise Manager.

NO.2 Identify two features of Oracle BAM.
A. Enterprise Manager's monitoring capabilities are central to Oracle BAM's ability to monitor
performance indicators.
B. You can analyze and present Information from activities spanning multiple systems and
applications.
C. Rich browser-based dashboards provide visibility into current values of key performance
indicators (KPIs).
D. There is a built-in trouble ticket system to track assignment and completion of corrective actions.
Answer: A,C

Oracle認定   1Z1-478初心者   1Z1-478内容
Explanation:
Note: *Oracle Business Activity Monitoring (Oracle BAM) gives business executives the ability to
monitor their business services and processes in the enterprise, to correlate KPIs down to the actual
business process themselves, and most important, to change business processes quickly or to take
corrective action if the business environment changes.

NO.3 A partner needs to access services that are defined in one of your Service Composite
Architecture (SCA) applications via a web service interface. Which approach (and accompanying
reasoning) describes a loosely coupled and robust solution?
A. Use Oracle Service Bus to provide an Interface layer over your SCA application. This enables you
to hide the locations of your SCA application, perform load-balancing across those endpoints, and
provide the ability to define service level agreements to help ensure that you are meeting your
contractual obligations to the partner.
B. Use the Mediator component to provide a web service interface to your SCA application. This
arrives you the flexibility of using the industry standard XSLT technology to perform translation and
transformations.
C. Use Oracle Service Bus to provide an interface layer over your SCA application. This enables you
to "skin" your SCA application with a web service interface and still provide a robust experience to
the partner.
D. Allow the partner simply to connect directly to the SCA application. This provides the best
performance and helps keep the partner happy.
Answer: B

Oracle教育   1Z1-478取得   1Z1-478参考書

NO.4 When more than one policy is attached to a policy subject, the combination of policies needs
to be valid. Which statement is true about the valid combination of policies for a policy subject?
A. Only one MTOM policy can be attached to a policy subject.
B. More than one Reliable Messaging policy can be attached to a policy subject.
C. Both a Reliable Messaging policy and a WS-Addressing policy cannot be attached to the same
policy subject.
D. Only one security policy can be attached to a policy subject.
Answer: A

Oracle   1Z1-478教育   1Z1-478科目   1Z1-478学校   1Z1-478認定証   1Z1-478参考書
Explanation:
Note:
*Within a SOA composite application, you must attach the Oracle WS-MTOM policy to service and
reference binding components to receive and send MTOM (MIME binary) attachments within
Oracle SOA Suite.
*Message Transmission Optimization Mechanism (MTOM)
Ensures that attachments are in MTOM format. This format enables binary data to be sent to and
from web services. This reduces the transmission size on the wire.
*ReliabilityPolicy
Supports the WS-Reliable Messaging protocol. This guarantees the end-to-end delivery of
messages.
* Addressing Policy Verifies that simple object access protocol (SOAP) messages include
WS-Addressing headers in conformance with the WS-Addressing specification. Transport-level data
is included in the XML message rather than relying on the network-level transport to convey this
information.

NO.5 In your solution, a web service client needs to invoke a series of three web services in support
of a single transaction. The third web service needs the identity of the original web service client.
Which statement describes how the identity is made available by Oracle Web Services Manager
(OWSM)?
A. The transaction manager accesses an internal table that maintains credentials used to invoke
each individual web service in the chain.
B. Each web service in the chain does its own authentication so the third web service handles its
own identity checking.
C. OWSM sets the user in the Java Authentication and Authorization (JAAS) Subject when the first
web service successfully authenticates, and the Java Subject is used by subsequent web services to
access the identity.
D. OWSM stores a SAML token from the first web service invocation in a database table, and that
table is accessed by subsequent web services in the chain to retrieve identity.
Answer: D

Oracle認証試験   1Z1-478対策   1Z1-478問題集
Explanation:
Oracle Web Services Manager is a component of the Oracle Enterprise Manager Fusion Middleware
Control, a run-time framework that provides centralized management and governance of Oracle
SOA Suite environments and applications. You create and configureOracle Web Services Manager
policies in Oracle Enterprise Manager, and those policies are persisted in a policy store (a database
is recommended). Oracle Web Services Manager lets you define policies against an LDAP directory
and generate standard security tokens (such as SAML tokens) to propagate identities across multiple
Web services used in a single transaction.

NO.6 You expand a business rule component that a colleague added to the BPEL process. You see an
Assign element named Facts_To_Rule_Service.
Which statement is true bout this Assign element?
A. It was added automatically based on entries that your colleague made in the dialog box that
approved when the business rule component was added to the BPEL model.
B. Your colleague manually added this Assign element after adding the business rule component to
the BPEL Model.
C. This Assign element was automatically added when your colleague manually addedthe
corresponding Rule_Service_To_Facts assign to the BPEL model.
D. You can delete this Assign because it was created for documentation purposes only.
Answer: A

Oracle   1Z1-478認定資格   1Z1-478初心者   1Z1-478テスト
Explanation:
Note: *Facts_To_Rule_Service: Assigns the facts to a variable.

NO.7 Which two features are provided by decision tables?
A. Sets of input data can be bucketed and reviewed for gaps.
B. Data sets can be reviewed for conflicts.
C. Data can be used for only one rule evaluation.
D. A rule evaluation can be used only to enter new output data.
Answer: A,B

Oracleふりーく   1Z1-478対策   1Z1-478
Explanation:
After you create a Decision Table there are operations that you may want to perform on the
Decision Table, including the following:
(A)Find and fix gaps in a Decision Table (B)Finding and resolving conflicts between rules in a
Decision Table Compact or split cells in a Decision Table Merge a condition or split a condition in a
Decision Table
A: *Compact the Decision Table
In this step you compact the rules to merge from eighteen rules to nine rules. This automatically
eliminates the rules that are not needed and preserves the no gap, no conflict properties for the
Decision Table.
*The Conditions area in a Decision Table includes one or more condition rows. Each condition row
has a condition expression and, for each rule, a condition cell. A condition expression is an
expression that you build in Rules Designer. The condition expression is often a fact property or a
function result, but it can be any expression that has a type that can be associated with a bucketset.
B:A Decision Table displays multiple related rules in a single spreadsheet-style view. In Rules
Designer a Decision Table presents a collection of related business rules with condition rows, rules,
and actions presented in a tabular form that is easy to understand. Business users can compare cells
and their values at a glance and can use Decision Table rule analysis features by clicking icons and
selecting values in Rules Designer to help identify and correct conflicting or missing cases.

NO.8 Which two approaches are valid when using dynamic partner links in a BPEL process?
A. A WSDL file, which contains multiple services that use the same portType, is available at design
time, but the decision to determine which service is used can only be made at runtime.
B. When the BPEL process is designed, the endpoint URL of the WSDL file is known but the services
and port types are not known.
C. When the BPEL process is designed, the services and port types of the WSDL file are known but
the endpoint URI is not known.
D. A WSDL file, which contains multiple services that use different portTypes, is available at design
time, but the decision to determine which server us used can only be made at runtime.
Answer: A,C

Oracle割引   1Z1-478問題集   1Z1-478難易度   1Z1-478クラムメディア   1Z1-478ガイド
Explanation:
A (not D):How To Create a Dynamic Partner Link at Design Time for Use at Runtime
To create a dynamic partner link at design time for use at runtime:
etc
C (not B):The BPEL specification mandates that only the partner endpoint reference (EPR) can be
changed dynamically. In BPEL terms, only the partnerRole of a partner link element can have a new
value assigned. The myRole value doesn't change after the BPEL has been deployed.
Note: *Dynamic Partner Links and Dynamic Addressing During the design-time of an application,
you may need to configure certain services whose endpoints (addresses) are not known beforehand,
or it may be necessary to change an endpoint reference while the application is running. The
Dynamic Partner link feature allows you to dynamically assign an endpoint reference to the partner
link. This means that you can use onepartner link for subsequent calls to different web-services
(provided that the services use the same interface). *For successful deployment of the process, a
partner link should be completely defined. When you deploy the project, the WSDL file for the
partner link should contain and define both the abstract and the concrete information for the
partner link, including address and port, though later the concrete information can be changed
independently from the WSDL file.

2014年4月25日星期五

最高の参考書でOracle 1Z0-053認定試験に合格しよう

IT-Passports.comはもっぱらITプロ認証試験に関する知識を提供するのサイトで、ほかのサイト使った人はIT-Passports.comが最高の知識源サイトと比較しますた。IT-Passports.comの商品はとても頼もしい試験の練習問題と解答は非常に正確でございます。

IT認証資料を提供したほかのサイトより、IT-Passports.comのプロかつ高品質の製品は最高のものです。IT-Passports.comを選んだら成功を選んだということです。IT-Passports.comのOracleの1Z0-053試験トレーニング資料はあなたが成功への保証です。IT-Passports.comを利用したら、あなたはきっと高い点数を取ることができ、あなたの理想なところへと進むことができます。

試験番号:1Z0-053問題集
試験科目:Oracle 「Oracle Database 11g: Administration II」
問題と解答:全673問

IT-Passports.comのOracleの1Z0-053試験資料は同じシラバスに従って研究されたのです。それに、資料もずっとアップグレードしていますから、実際の試験問題とよく似ています。IT-Passports.comの試験合格率も非常に高いことは否定することができない事実です。IT-Passports.comのOracleの1Z0-053試験トレーニング資料の値段は手頃で、IT認証の受験生のみなさんによく適用します。

Oracleの1Z0-053認定試験を受けて1Z0-053認証資格を取得したいですか。IT-Passports.comはあなたの成功を保証することができます。もちろん、試験の準備をするときに試験に関連する知識を学ぶのは必要です。なお大切なのは、自分に相応しい効率的なツールを選択することです。IT-Passports.comの1Z0-053問題集はあなたに合う最善の勉強法です。この高品質の問題集は信じられないほどの結果を見せることができます。自分が試験に合格できない心配があれば、はやくIT-Passports.comのウェブサイトをクリックしてもっと多くの情報を読んでください。

IT-Passports.comは正確な選択を与えて、君の悩みを減らして、もし早くてOracle 1Z0-053認証をとりたければ、早くてIT-Passports.comをショッピングカートに入れましょう。あなたにとても良い指導を確保できて、試験に合格するのを助けって、IT-Passports.comからすぐにあなたの通行証をとります。

IT業界の中でたくさんの野心的な専門家がいって、IT業界の中でより一層頂上まで一歩更に近く立ちたくてOracleの1Z0-053試験に参加して認可を得たくて、Oracle の1Z0-053試験が難度の高いので合格率も比較的低いです。Oracleの1Z0-053試験を申し込むのは賢明な選択で今のは競争の激しいIT業界では、絶えず自分を高めるべきです。しかし多くの選択肢があるので君はきっと悩んでいましょう。

現在の社会で人材があちこちいます。IT領域でも同じです。コンピュータの普及につれて、パソコンを使えない人がほとんどいなくなります。ですから、IT業界で勤めているあなたはプレッシャーを感じていませんか。学歴はどんなに高くてもあなたの実力を代表できません。学歴はただ踏み台だけで、あなたの地位を確保できる礎は実力です。IT職員としているあなたがどうやって自分自身の実力を養うのですか。IT認定試験を受験するのは一つの良い方法です。1Z0-053試験を通して、あなたは新しいスキルをマスターすることができるだけでなく、1Z0-053認証資格を取得して自分の高い能力を証明することもできます。最近、Oracle 1Z0-053試験の認証資格がとても人気があるようになりましたが、受験したいですか。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード:http://www.it-passports.com/1Z0-053.html

NO.1 You performed the RMAN database backup having a backupset key number 231 with the KEEP
FOREVER option.
After some days, you want to change the status of the database backup and you issued the following
command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy
Answer: D

Oracle   1Z0-053   1Z0-053   1Z0-053認証試験   1Z0-053

NO.2 You plan to have a larger moving window size for the default system-defined moving window baseline
because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window.?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention
period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)
retention period.
Answer: D

Oracle   1Z0-053   1Z0-053認定試験   1Z0-053   1Z0-053

NO.3 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema
owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog
schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,
into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10
catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D

Oracle   1Z0-053練習問題   1Z0-053   1Z0-053過去問   1Z0-053

NO.4 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B

Oracle認定資格   1Z0-053過去問   1Z0-053   1Z0-053参考書

NO.5 View the Exhibit and examine the resource consumption details for the current plan in use by the
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC

Oracle問題集   1Z0-053   1Z0-053   1Z0-053認定資格

NO.6 Which two statements are true regarding hot patching? (Choose two.)
A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment.
Answer: BC

Oracle   1Z0-053   1Z0-053参考書

NO.7 Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007.05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
Answer: AB

Oracle過去問   1Z0-053認証試験   1Z0-053   1Z0-053

NO.8 While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
Answer: AC

Oracle   1Z0-053   1Z0-053過去問

NO.9 The INV_HISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))
partition by range (inv_date) interval
(numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than
(to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006
4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
A. It executes successfully, and the transition point is set to '1-apr-2006'.
B. It executes successfully, and the transition point is set to '15-apr-2006'.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values
stored in the table.
Answer: C

Oracle   1Z0-053   1Z0-053   1Z0-053

NO.10 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains
one redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
Answer: C

Oracle問題集   1Z0-053認定試験   1Z0-053   1Z0-053

NO.11 You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
Answer: B

Oracle練習問題   1Z0-053   1Z0-053認証試験   1Z0-053認定証   1Z0-053過去問

NO.12 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The
PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery
catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes
the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN
executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged
procedure.
D. They produce an error because you need to connect to the target database to execute this packaged
procedure.
Answer: A

Oracle問題集   1Z0-053   1Z0-053練習問題   1Z0-053

NO.13 View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the
Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the
metric.
B. The statistics for the metric values observed over the baseline time period are not examined to
determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value
captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the
metric, has been set to zero.
Answer: A

Oracle認定証   1Z0-053   1Z0-053過去問   1Z0-053

NO.14 You create a new Automatic Database Diagnostic Monitor (ADDM) task:
instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.
What would you do to achieve this?
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
Answer: B

Oracle認定証   1Z0-053   1Z0-053認定試験   1Z0-053参考書

NO.15 Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day
window
Answer: D

Oracle   1Z0-053   1Z0-053   1Z0-053   1Z0-053   1Z0-053認定資格

NO.16 Which three components does the Scheduler use for managing tasks within the Oracle environment?
(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Answer: ABC

Oracle   1Z0-053   1Z0-053   1Z0-053

NO.17 View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the
Significance Level threshold type not available in the threshold setting?
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
Answer: B

Oracle   1Z0-053   1Z0-053   1Z0-053認定資格

NO.18 A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the
online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next
time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during
online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets
revalidated the next time it is used.
Answer: A

Oracle参考書   1Z0-053認証試験   1Z0-053   1Z0-053参考書

NO.19 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile
LOBs?
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
Answer: B

Oracle認定資格   1Z0-053認定試験   1Z0-053

NO.20 Because of a logical corruption in your production database, you wanted to perform Tablespace Point
in Time Recovery (TSPITR). But before you start the recovery, you queried the
TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that
would be dropped when you start the recovery by using this method. You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object?
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Answer: A

Oracle   1Z0-053   1Z0-053

IT-Passports.comのOracleの1Z0-053試験トレーニング資料は全てのオンラインのトレーニング資料で一番よいものです。我々の知名度はとても高いです。これは受験生の皆さんが資料を利用した後の結果です。IT-Passports.comのOracleの1Z0-053試験トレーニング資料を選んだら、100パーセントの成功率を保証します。もし失敗だったら、我々は全額で返金します。受験生の皆さんの重要な利益が保障できるようにIT-Passports.comは絶対信頼できるものです。

2013年11月12日星期二

最新なOracleの1Z0-053認定試験の問題集

IT-Passports.comは専門的な、受験生の皆さんを対象とした最も先進的なOracleの1Z0-053試験の認証資料を提供しているサイトです。IT-Passports.comを利用したら、Oracleの1Z0-053試験に合格するのを心配することはないです。

Oracleの1Z0-053認証試験のために少ないお金でよい成果を取られるのIT-Passports.comのは最良の選択でございます。IT-Passports.comは例年試験内容を提供したあなたに後悔しないように価値があるサイトだけではなく、無料の一年更新サービスも提供するに最も賢明な選択でございます。

IT-Passports.comはその近道を提供し、君の多くの時間と労力も節約します。IT-Passports.comはOracleの1Z0-053認定試験に向けてもっともよい問題集を研究しています。もしほかのホームページに弊社みたいな問題集を見れば、あとでみ続けて、弊社の商品を盗作することとよくわかります。ass4Testが提供した資料は最も全面的で、しかも更新の最も速いです。

多くの人々は高い難度のIT認証試験に合格するのは専門の知識が必要だと思います。それは確かにそうですが、その知識を身につけることは難しくないとといわれています。IT業界ではさらに強くなるために強い専門知識が必要です。

IT-Passports.comはOracleの1Z0-053認定試験についてすべて資料を提供するの唯一サイトでございます。受験者はIT-Passports.comが提供した資料を利用して1Z0-053認証試験は問題にならないだけでなく、高い点数も合格することができます。

試験番号:1Z0-053問題集
試験科目:Oracle 「Oracle Database 11g: Administration II」
問題と解答:全673問

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード:http://www.it-passports.com/1Z0-053.html

NO.1 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains
one redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
Answer: C

Oracle過去問   1Z0-053   1Z0-053認定資格   1Z0-053   1Z0-053認証試験

NO.2 Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day
window
Answer: D

Oracle   1Z0-053問題集   1Z0-053

NO.3 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema
owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog
schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,
into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10
catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D

Oracle認定資格   1Z0-053   1Z0-053問題集   1Z0-053認定証   1Z0-053

NO.4 You performed the RMAN database backup having a backupset key number 231 with the KEEP
FOREVER option.
After some days, you want to change the status of the database backup and you issued the following
command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy
Answer: D

Oracle   1Z0-053認定試験   1Z0-053認定証   1Z0-053練習問題   1Z0-053   1Z0-053

NO.5 The INV_HISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))
partition by range (inv_date) interval
(numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than
(to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006
4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
A. It executes successfully, and the transition point is set to '1-apr-2006'.
B. It executes successfully, and the transition point is set to '15-apr-2006'.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values
stored in the table.
Answer: C

Oracle   1Z0-053   1Z0-053   1Z0-053

NO.6 A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the
online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next
time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during
online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets
revalidated the next time it is used.
Answer: A

Oracle問題集   1Z0-053   1Z0-053   1Z0-053   1Z0-053認定証

NO.7 Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007.05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
Answer: AB

Oracle   1Z0-053   1Z0-053問題集   1Z0-053

NO.8 View the Exhibit and examine the resource consumption details for the current plan in use by the
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC

Oracle   1Z0-053練習問題   1Z0-053問題集   1Z0-053認定証   1Z0-053

NO.9 While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
Answer: AC

Oracle   1Z0-053   1Z0-053認証試験   1Z0-053

NO.10 Because of a logical corruption in your production database, you wanted to perform Tablespace Point
in Time Recovery (TSPITR). But before you start the recovery, you queried the
TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that
would be dropped when you start the recovery by using this method. You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object?
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Answer: A

Oracle練習問題   1Z0-053   1Z0-053認証試験   1Z0-053参考書   1Z0-053

NO.11 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The
PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery
catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes
the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN
executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged
procedure.
D. They produce an error because you need to connect to the target database to execute this packaged
procedure.
Answer: A

Oracle問題集   1Z0-053   1Z0-053認定資格   1Z0-053

NO.12 You plan to have a larger moving window size for the default system-defined moving window baseline
because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window.?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention
period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)
retention period.
Answer: D

Oracle   1Z0-053   1Z0-053

NO.13 Which three components does the Scheduler use for managing tasks within the Oracle environment?
(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Answer: ABC

Oracle   1Z0-053練習問題   1Z0-053過去問   1Z0-053   1Z0-053認証試験

NO.14 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B

Oracle参考書   1Z0-053   1Z0-053認定試験

NO.15 View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the
Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the
metric.
B. The statistics for the metric values observed over the baseline time period are not examined to
determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value
captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the
metric, has been set to zero.
Answer: A

Oracle   1Z0-053   1Z0-053   1Z0-053   1Z0-053

NO.16 You create a new Automatic Database Diagnostic Monitor (ADDM) task:
instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.
What would you do to achieve this?
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
Answer: B

Oracle認定証   1Z0-053認定試験   1Z0-053過去問   1Z0-053認証試験   1Z0-053   1Z0-053練習問題

NO.17 You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
Answer: B

Oracle過去問   1Z0-053認定試験   1Z0-053

NO.18 Which two statements are true regarding hot patching? (Choose two.)
A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment.
Answer: BC

Oracle   1Z0-053   1Z0-053問題集   1Z0-053認証試験   1Z0-053   1Z0-053

NO.19 View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the
Significance Level threshold type not available in the threshold setting?
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
Answer: B

Oracle   1Z0-053参考書   1Z0-053   1Z0-053認定証   1Z0-053   1Z0-053参考書

NO.20 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile
LOBs?
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
Answer: B

Oracle   1Z0-053   1Z0-053

IT-Passports.comのIT認証試験問題集は長年のトレーニング経験を持っています。IT-Passports.com Oracleの1Z0-053試験トレーニング資料は信頼できる製品です。当社のスタッフ は受験生の皆様が試験で高い点数を取ることを保証できるように、巨大な努力をして皆様に最新版の1Z0-053試験トレーニング資料を提供しています。IT-Passports.com Oracleの1Z0-053試験材料は最も実用的なIT認定材料を提供することを確認することができます。

2013年10月5日星期六

Oracleの1Z0-053認定試験の問題集

現在でOracleの1Z0-053試験を受かることができます。IT-Passports.comにOracleの1Z0-053試験のフルバージョンがありますから、最新のOracleの1Z0-053のトレーニング資料をあちこち探す必要がないです。IT-Passports.comを利用したら、あなたはもう最も良いOracleの1Z0-053のトレーニング資料を見つけたのです。弊社の質問と解答を安心にご利用ください。あなたはきっとOracleの1Z0-053試験に合格できますから。

IT-Passports.comの1Z0-053 問題集はあなたが1Z0-053認定試験に準備するときに最も欠かせない資料です。この問題集の価値は試験に関連する他の参考書の総合の価値に相当します。このアサーションは過言ではありません。IT-Passports.comの問題集を利用してからこのすべてが真であることがわかります。

なんで悩んでいるのですか。Oracleの1Z0-053認定試験にどうやって合格するかということを心配していますか。確かに、1Z0-053認定試験に合格することは困難なことです。しかし、あまりにも心配する必要はありません。試験に準備するとき、適当な方法を利用する限り、楽に試験に合格することができないわけではないです。では、どんな方法が効果的な方法なのかわかっていますか。IT-Passports.comの1Z0-053問題集を使用することが最善の方法の一つです。IT-Passports.comは今まで数え切れないIT認定試験の受験者を助けて、皆さんから高い評判をもらいました。この問題集はあなたの試験の一発合格を保証することができますから、安心に利用してください。

Oracleの1Z0-053認定試験に合格するためにたくさん方法があって、非常に少ないの時間とお金を使いのは最高で、IT-Passports.comが対応性の訓練が提供いたします。

試験番号:1Z0-053問題集
試験科目:Oracle 「Oracle Database 11g: Administration II」
問題と解答:全673問

逆境は人をテストすることができます。困難に直面するとき、勇敢な人だけはのんびりできます。あなたは勇敢な人ですか。もしIT認証の準備をしなかったら、あなたはのんびりできますか。もちろんです。 IT-Passports.comのOracleの1Z0-053試験トレーニング資料を持っていますから、どんなに難しい試験でも成功することができます。

Pass4のOracleの1Z0-053試験トレーニング資料を利用したら、最新のOracleの1Z0-053認定試験の問題と解答を得られます。そうしたらPass4のOracleの1Z0-053試験に合格することができるようになります。Pass4のOracleの1Z0-053試験に合格することはあなたのキャリアを助けられて、将来の異なる環境でチャンスを与えます。Pass4のOracleの1Z0-053試験トレーニング資料はあなたが完全に問題と問題に含まれているコンセプトを理解できることを保証しますから、あなたは気楽に一回で試験に合格することができます。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード:http://www.it-passports.com/1Z0-053.html

NO.1 View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the
Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the
metric.
B. The statistics for the metric values observed over the baseline time period are not examined to
determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value
captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the
metric, has been set to zero.
Answer: A

Oracle   1Z0-053   1Z0-053   1Z0-053   1Z0-053   1Z0-053

NO.2 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The
PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery
catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes
the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN
executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged
procedure.
D. They produce an error because you need to connect to the target database to execute this packaged
procedure.
Answer: A

Oracle練習問題   1Z0-053練習問題   1Z0-053   1Z0-053

NO.3 Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007.05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
Answer: AB

Oracle過去問   1Z0-053参考書   1Z0-053

NO.4 The INV_HISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))
partition by range (inv_date) interval
(numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than
(to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006
4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
A. It executes successfully, and the transition point is set to '1-apr-2006'.
B. It executes successfully, and the transition point is set to '15-apr-2006'.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values
stored in the table.
Answer: C

Oracle過去問   1Z0-053認定証   1Z0-053練習問題

NO.5 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains
one redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
Answer: C

Oracle認定証   1Z0-053認定資格   1Z0-053認定試験   1Z0-053   1Z0-053参考書   1Z0-053

NO.6 Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day
window
Answer: D

Oracle   1Z0-053過去問   1Z0-053認定資格   1Z0-053参考書

NO.7 Which two statements are true regarding hot patching? (Choose two.)
A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment.
Answer: BC

Oracle   1Z0-053   1Z0-053   1Z0-053   1Z0-053参考書

NO.8 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema
owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog
schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,
into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10
catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D

Oracle認定証   1Z0-053   1Z0-053過去問   1Z0-053

NO.9 You plan to have a larger moving window size for the default system-defined moving window baseline
because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window.?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention
period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)
retention period.
Answer: D

Oracle   1Z0-053認証試験   1Z0-053過去問   1Z0-053過去問   1Z0-053   1Z0-053過去問

NO.10 Because of a logical corruption in your production database, you wanted to perform Tablespace Point
in Time Recovery (TSPITR). But before you start the recovery, you queried the
TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that
would be dropped when you start the recovery by using this method. You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object?
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Answer: A

Oracle練習問題   1Z0-053   1Z0-053

NO.11 While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
Answer: AC

Oracle   1Z0-053認定資格   1Z0-053参考書   1Z0-053認証試験   1Z0-053問題集

NO.12 View the Exhibit and examine the resource consumption details for the current plan in use by the
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC

Oracle認定資格   1Z0-053練習問題   1Z0-053

NO.13 You performed the RMAN database backup having a backupset key number 231 with the KEEP
FOREVER option.
After some days, you want to change the status of the database backup and you issued the following
command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy
Answer: D

Oracle   1Z0-053問題集   1Z0-053   1Z0-053

NO.14 A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the
online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next
time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during
online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets
revalidated the next time it is used.
Answer: A

Oracle   1Z0-053   1Z0-053

NO.15 View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the
Significance Level threshold type not available in the threshold setting?
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
Answer: B

Oracle練習問題   1Z0-053   1Z0-053参考書

NO.16 Which three components does the Scheduler use for managing tasks within the Oracle environment?
(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Answer: ABC

Oracle問題集   1Z0-053   1Z0-053練習問題   1Z0-053認定資格

NO.17 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile
LOBs?
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
Answer: B

Oracle練習問題   1Z0-053練習問題   1Z0-053   1Z0-053

NO.18 You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
Answer: B

Oracle認定試験   1Z0-053   1Z0-053   1Z0-053過去問

NO.19 You create a new Automatic Database Diagnostic Monitor (ADDM) task:
instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.
What would you do to achieve this?
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
Answer: B

Oracle過去問   1Z0-053過去問   1Z0-053   1Z0-053   1Z0-053認定資格

NO.20 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B

Oracle   1Z0-053過去問   1Z0-053認定資格

IT-Passports.comがOracleの1Z0-053のサンプルの問題のダウンロードを提供して、あなはリスクフリーの購入のプロセスを体験することができます。これは試用の練習問題で、あなたにインタフェースの友好、問題の質と購入する前の価値を見せます。弊社はIT-Passports.comのOracleの1Z0-053のサンプルは製品の性質を確かめるに足りて、あなたに満足させると信じております。あなたの権利と利益を保障するために、IT-Passports.comは一回で合格しなかったら、全額で返金することを約束します。弊社の目的はあなたが試験に合格することに助けを差し上げるだけでなく、あなたが本物のIT認証の専門家になることを願っています。あなたが仕事を求める競争力を高めて、自分の技術レベルに合わせている技術職を取って、気楽にホワイトカラー労働者になって高い給料を取ることをお祈りします。