레이블이 1Z0-048인 게시물을 표시합니다. 모든 게시물 표시
레이블이 1Z0-048인 게시물을 표시합니다. 모든 게시물 표시

2013년 10월 14일 월요일

Oracle 인증 1Z0-048 덤프

IT업계에 종사하는 분이 점점 많아지고 있는 지금 IT인증자격증은 필수품으로 되었습니다. IT인사들의 부담을 덜어드리기 위해ITExamDump는Oracle인증 1Z0-048인증시험에 대비한 고품질 덤프를 연구제작하였습니다. Oracle인증 1Z0-048시험을 준비하려면 많은 정력을 기울여야 하는데 회사의 야근에 시달리면서 시험공부까지 하려면 스트레스가 이만저만이 아니겠죠. ITExamDump 덤프를 구매하시면 이제 그런 고민은 끝입니다. 덤프에 있는 내용만 공부하시면 IT인증자격증 취득은 한방에 가능합니다.

우리 ITExamDump에서는 여러분을 위하여 정확하고 우수한 서비스를 제공하였습니다. 여러분의 고민도 덜어드릴 수 있습니다. 빨리 성공하고 빨리Oracle 1Z0-048인증시험을 패스하고 싶으시다면 우리 ITExamDump를 장바구니에 넣으시죠 . ITExamDump는 여러분의 아주 좋은 합습가이드가 될것입니다. ITExamDump로 여러분은 같고 싶은 인증서를 빠른시일내에 얻게될것입니다.

ITExamDump는 여러분이 빠른 시일 내에Oracle 1Z0-048인증시험을 효과적으로 터득할 수 있는 사이트입니다.Oracle 1Z0-048덤프는 보장하는 덤프입니다. 만약 시험에서 떨어지셨다고 하면 우리는 무조건 덤프전액 환불을 약속 드립니다. 우리ITExamDump 사이트에서Oracle 1Z0-048관련자료의 일부분 문제와 답 등 샘플을 제공함으로 여러분은 무료로 다운받아 체험해보실 수 있습니다. 체험 후 우리의ITExamDump에 신뢰감을 느끼게 됩니다. ITExamDump의Oracle 1Z0-048덤프로 자신 있는 시험준비를 하세요.

Pass4Tes가 제공하는 제품을 사용함으로 여러분은 IT업계하이클래스와 멀지 않았습니다. Pass4Tes 가 제공하는 인증시험덤프는 여러분을Oracle인증1Z0-048시험을 안전하게 통과는 물론 관연전업지식장악에도 많은 도움이 되며 또한 우리는 일년무료 업뎃서비스를 제공합니다.

시험 번호/코드: 1Z0-048
시험 이름: Oracle (Oracle Database 10g R2: Administering RAC)
당신이 구입하기 전에 시도
일년동안 무료 업데이트
100% 환불보장약속
100% 합격율 보장
Q&A: 150 문항
업데이트: 2013-10-13

우리 ITExamDump사이트에서 제공되는Oracle인증1Z0-048시험덤프의 일부분인 데모 즉 문제와 답을 다운받으셔서 체험해보면 우리ITExamDump에 믿음이 갈 것입니다. 우리ITExamDump의 제품을 구매하신다고 하면 우리는 최선을 다하여 여러분들한테 최고의 버전을 제공함으로 한번에Oracle인증1Z0-048시험을 패스하도록 하겠습니다. IT시험이라고 모두 무조건 외우고 장악하고 많은 시간을 투자해야만 된다는 사상을 깨게 될 것입니다.

ITExamDump의 Oracle인증 1Z0-048덤프로 시험공부를 하신다면 고객님의 시간은 물론이고 거금을 들여 학원등록하지 않아도 되기에 금전상에서도 많은 절약을 해드리게 됩니다. Oracle인증 1Z0-048덤프 구매의향이 있으시면 무료샘플을 우선 체험해보세요.

1Z0-048 덤프무료샘플다운로드하기: http://www.itexamdump.com/1Z0-048.html

NO.1 Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database?
(Choose three.)
A.Raw volume
B.ASM disk group
C.Local file system
D.Cluster file system
E.Shared NFS directory
Correct:B D E

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.2 Your company has a combination of high availability and scalability requirements that need to
be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf"
software products and homegrown applications currently in use in your environment that run on
single-instance Oracle databases. You have been asked by the IT director to provide an impact
analysis report to help assess the impact on applications when migrating to RAC. Which three are
among the areas that should be examined for performance impact and application functionality
impact or for both? (Choose three.)
A.applications that use large parallel full table scans
B.applications that truncate tables in a data warehouse process
C.three-tier applications that use application global context variables
D.client/server type applications that use application local context variables
E.applications that access small tables using the same index occasionally
F.applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
Correct:A B C

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.3 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant
wait events. What would you do to fix this issue?
A.Increase the cache size of sequences.
B.Reduce the time of transactions by committing more often.
C.Use larger uniform extent sizes for objects.
D.Reduce the number of updates causing locks on tables accessed by multiple instances.
Correct:C

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.4 You are running a two-instance database with six redo log groups defined and decide to add a
third thread to support a third database instance on the third node of the cluster. Which three
commands would you issue to achieve this using command line administration? (Choose three.)
A.ALTER SYSTEM ENABLE THREAD 3;
B.ALTER DATABASE ENABLE THREAD 3;
C.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Correct:B E F

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.5 You are working as a DBA in a RAC environment that is available for testing. The RAC
environment has all the database files stored in the OCFS file system. You plan to install ASM and
move all the database files to ASM to achieve better performance. During the installation, you
selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A.You want to use hardware mirroring.
B.You do not want to have any mirroring in the disk group.
C.You have two failure groups defined, so you want to use two-way mirroring.
D.You have three failure groups defined, so you want to use three-way mirroring.
Correct:C

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.6 You have a well-tuned, non-RAC single instance Oracle database with several services, all of
which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file
systems would be shared using Oracle Cluster File System. After the migration, you want to
perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A.Interconnect latency
B.Instance recovery time
C.Services with applications that use external tables
D.Services with applications that truncate large tables
E.Services with applications using local context variables
F.Services with query-intensive applications relying on full table scans
G.Services with insert-intensive applications that use Oracle sequences for index keys
H.Services with applications that have occasional queries, using index access on modestly sized tables
I.Services with insert-intensive applications that generate their own keys without Oracle sequences
Correct:A B D F G I

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.7 Which initialization parameter would you use for each RAC instance to make sure that each
listener on each RAC node is aware of the load of all the others?
A.LOCAL_LISTENER
B.REMOTE_LISTENER
C.REMOTE_DEPENDENCIES_MODE
D.PREFER_LEAST_LOADED_NODE_
Correct:B

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.8 You have attended a user group presentation on RAC and based on what you have learned you
feel that your company would benefit from having the RAC option to meet its Oracle database
requirements in several ways. Your manager does not know much about RAC and asks you to
create a presentation to the team explaining RAC, and whether it should be implemented in your
installation. Which three statements explain the benefits and implications of RAC? (Choose three.)
A.RAC alone would not help protect from human errors.
B.RAC would increase availability in the event of data failures.
C.RAC would increase availability in the event of a network failure.
D.RAC alone would increase availability when doing release upgrades.
E.RAC would increase scalability for all application workloads in all cases.
F.RAC would increase availability in the event of node and instance failures.
G.RAC used in conjunction with parallel execution may provide speedup of DSS queries.
H.RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
Correct:A F G

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.9 Which three statements regarding backup of the voting disk are true? (Choose three.)
A.On UNIX platforms, the voting disk can be backed up with the dd command.
B.A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
C.A backup of the voting disk should be taken whenever a new node is added to the cluster.
D.A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
E.Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in
the cluster.
Correct:A C D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.10 Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two
commands? (Choose two.)
A.ocrconfig -import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is an automatically generated
OCR backup
B.ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup
created using the ocrconfig -export command
C.cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where
/ocfs/OCR/crs.dbf is the cluster registry file
D.ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an
automatically generated OCR backup
Correct:B D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.11 You are about to build a new Oracle Clusterware-based cluster and you want to make the
installation process as smooth as possible. You decide to use the Cluster Verification Utility
(CLUVFY) to check whether or not your system administrator has set up the hardware and system
software correctly. Which two statements about CLUVFY are true? (Choose two.)
A.You can run CLUVFY only from a privileged operating system account.
B.You can run CLUVFY directly from the Oracle Clusterware distribution media.
C.CLUVFY cannot be used until the Oracle Clusterware is installed successfully.
D.After the Oracle Clusterware installation, you can run CLUVFY from the Oracle Home that holds the
CRS binaries.
E.You have to install CLUVFY on all cluster nodes in order to use CLUVFY on other nodes than the one
from which you perform the installation.
F.To use CLUVFY during the Oracle Clusterware installation, you have to download CLUVFY from the
Oracle Technology Network (OTN) Web site and install it before you can use it.
Correct:B D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.12 Your company has certain standard practices for technology and you are configuring ASM disk
groups for your four-node RAC cluster. The company guidelines suggest that there is one disk
group for the flash recovery area that is shared by all databases and a separate disk group for the
database area of all databases. Which three exceptions exist that may require you to create
additional disk groups? (Choose three.)
A.The retention policy for backups are different for different databases.
B.There are large nonpartitioned tables accessed frequently using indexes.
C.The disk farm has different disk models with different characteristics and ages.
D.Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.
E.Some database instances are shut down every night while others are always running.
F.Applications using the databases have different Service-Level Agreements for response time and
throughput.
G.There are partitioned tables where the older partitions are in read-only tablespaces and seldom
accessed, but the more recent partitions are frequently accessed.
Correct:C F G

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.13 Several steps must be followed to successfully add a new node to your cluster database.
Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose
three.)
A.Add instances using OUI.
B.Reconfigure listeners for the new node with netca.
C.Configure the OS and hardware for the new node.
D.Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
E.Add the RAC software to the new node using addnode.sh from ORA_CRS_HOME.
Correct:B C D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.14 View the Exhibit, which displays the cluster database performance page after the same
workload has been executed three times on your cluster without varying any non-Oracle
workloads on the cluster. What are the two ways by which you can tell that the corresponding
application was better tuned during the second and third execution? (Choose two.)
A.There is less paging each time.
B.The run queue length is going down each time.
C.It takes less time to execute the workload each time.
D.The number of transactions per second is getting higher each time.
E.The database throughput graphic is below the red dashed line during the last execution.
Correct:C D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.15 After the cluster database has been successfully created, several postinstallation tasks should
be completed. Identify three of them. (Choose three.)
A.Create the ASM instance.
B.Back up the root.sh script.
C.Initialize the cluster backup procedure.
D.Set up additional required user accounts.
E.Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database
-d db_name.
Correct:B D E

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.16 After a power failure, you noticed that one of your cluster database instances did not start
automatically, whereas all other instances came up successfully. What would you do to determine
the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Correct:A C D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.17 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk.
Which are the two ways in which you can accomplish this task? (Choose two.)
A.You should not use symbolic links.
B.You can add additional voting disks online.
C.You must add additional voting disks offline.
D.You may use the VIPCA utility to add new voting disks.
E.You may use the command: crsctl add css votedisk
Correct:B E

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.18 Which two initialization parameters must be set to start up an ASM instance in a RAC
environment? (Choose two.)
A.INSTANCE_TYPE
B.DB_UNIQUE_NAME
C.ASM_DISKSTRING
D.ASM_DISKGROUPS
E.ASM_POWER_LIMIT
F.CLUSTER_DATABASE
Correct:A F

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.19 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize
the access to available listeners?
A.FAILOVER
B.LOAD_BALANCE
C.SOURCE_ROUTE
D.TYPE_OF_SERVICE
Correct:B

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

NO.20 You decide to implement a Data Guard configuration to support a disaster recovery plan for
your RAC database. Your primary database has all shared files and the flash recovery area is
stored on ASM disk groups. Which three options exist for storing the data guard broker
configuration files at the primary location? (Choose three.)
A.can be in any shared ASM disk group
B.can be stored on shared Raw Devices
C.must be stored on Oracle Cluster File System if a cluster file system is used
D.may be stored on any supported cluster file system if a cluster file system is used
E.must be in the same shared ASM disk group as the database data files if the broker configuration files
are stored in ASM disk groups
F.must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files
are stored in ASM disk groups.
Correct:A B D

Oracle   1Z0-048기출문제   1Z0-048덤프   1Z0-048

ITexamdump의 000-N32덤프의 VCE테스트프로그램과 700-104덤프는 한방에 시험을 패스하도록 도와드립니다. ITexamdump 에서는 최신버전의 000-656시험에 대비한 고품질 덤프와 HP0-J62시험 최신버전덤프를 제공해드립니다. 최고품질 JN0-380시험자료는 100% 간단하게 시험패스하도록 최선을 다하고 있습니다. IT인증시험패스는 이토록 간단합니다.

시험자료링크: http://www.itexamdump.com/1Z0-048.html

2013년 8월 5일 월요일

Oracle 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141 인증시험

ITExamDump 안에는 아주 거대한IT업계엘리트들로 이루어진 그룹이 있습니다. 그들은 모두 관련업계예서 권위가 있는 전문가들이고 자기만의 지식과 지금까지의 경험으로 최고의 IT인증관련자료를 만들어냅니다. ITExamDump의 문제와 답은 정확도가 아주 높으며 한번에 패스할수 있는 100%로의 보장도를 자랑하며 그리고 또 일년무료 업데이트를 제공합니다.


멋진 IT전문가로 거듭나는 것이 꿈이라구요? 국제적으로 승인받는 IT인증시험에 도전하여 자격증을 취득해보세요. IT전문가로 되는 꿈에 더 가까이 갈수 있습니다. Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141시험이 어렵다고 알려져있는건 사실입니다. 하지만ITExamDump의Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141덤프로 시험준비공부를 하시면 어려운 시험도 간단하게 패스할수 있는것도 부정할수 없는 사실입니다. ITExamDump의Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141덤프는 실제시험문제의 출제방형을 철저하게 연구해낸 말 그대로 시험대비공부자료입니다. 덤프에 있는 내용만 마스터하시면 시험패스는 물론 멋진 IT전문가로 거듭날수 있습니다.


Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141시험은 중요한 IT인증자격증을 취득하는 필수시험과목입니다Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141시험을 통과해야만 자격증 취득이 가능합니다.자격증을 많이 취득하면 자신의 경쟁율을 높여 다른능력자에 의해 대체되는 일은 면할수 있습니다.ITExamDump에서는Oracle 인증1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141시험대비덤프를 출시하여 여러분이 IT업계에서 더 높은 자리에 오르도록 도움드립니다. 편한 덤프공부로 멋진 IT전문가의 꿈을 이루세요.


ITExamDump의Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141덤프의 인지도는 아주 높습니다. 인지도 높은 원인은Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141덤프의 시험적중율이 높고 가격이 친근하고 구매후 서비스가 끝내주기 때문입니다. ITExamDump의Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141덤프로Oracle인증 1Z0-048 1Z0-045 1Z0-020 1Z0-147 1Z0-141시험에 도전해보세요.


시험 번호/코드: 1Z0-048

시험 이름: Oracle (Oracle Database 10g R2: Administering RAC)

시험 번호/코드: 1Z0-045

시험 이름: Oracle (Oracle database 10g:new features for Oracle8i ocps)

시험 번호/코드: 1Z0-020

시험 이름: Oracle (Oracle8l:new features for administrators)

시험 번호/코드: 1Z0-147

시험 이름: Oracle (Oracle9i program with pl/sql)

시험 번호/코드: 1Z0-141

시험 이름: Oracle (Oracle9i forma Developer:build internet applications)

1Z0-141 덤프무료샘플다운로드하기: http://www.itexamdump.com/1Z0-141.html


NO.1 You are developing a Human Resources form for HR clerks to insert, update, and delete
records from the EMPLOYEES table. When the user commits records, Forms displays the default
informative message "FRM-40400: Transaction complete: records applied and saved." You want
to replace that with the message "Records inserted: Records updated: Records deleted: ", where
represents the number of records inserted, updated, and deleted. Which triggers must you create
or modify to accomplish this?
A.On-Message only
B.Post-Commit and On-Message
C.Post-Database-Commit and On-Message
D.When-Validate-Record and On-Message
E.Post-Insert, Post-Update, Post-Delete, and On-Message
Correct:E

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.2 View the Exhibit. You are running a form in debug mode, but you have not set any breakpoints
in the code. You click a button that invokes the code shown in the exhibit. While the code
executes, you decide to examine the variable values in the loop. Which menu items in the Forms
Builder Debug menu would you choose?
A.Stop, Debug Windows > Variables
B.Pause, Debug Windows > Variables
C.Stop, Debug Windows > Form Values
D.Pause, Debug Windows > Form Values
E.Step Into, Debug Windows > Variables
F.Step Into, Debug Windows > Form Values
Correct:B

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.3 Which two statements correctly describe the relationship between a content canvas and a
window? (Choose two.)
A.Only one content canvas can be associated with a window.
B.Only one content canvas at a time can appear in a window.
C.One or more content canvases can be associated with a window.
D.A content canvas can be associated with two or more windows.
E.A content canvas cannot be larger than the window with which it is associated.
F.A maximum of two content canvases can appear in a window at the same time.
Correct:B C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.4 Which two statements about a Non-Query Record Group are true? (Choose two.)
A.The Record Group is associated with a query at run time or at design time.
B.The Record Group can be created and modified only at run time.
C.The Record Group can be created and modified only at design time.
D.The Record Group can be created and modified at design time or at run time.
E.You can modify the structure of this Record Group by adding columns and rows.
F.The Record Group is associated with a query only at design time.
Correct:B E

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.5 Consider the following scenario: In a multiform application, the user started in FormA. 1. From
FormA, the user invoked FormB using CALL_FORM. 2. From FormB, the user invoked FormC
using OPEN_FORM. 3. From FormC, the user invoked FormD using OPEN_FORM. 4. From FormB,
the user invoked FormE using CALL_FORM. There is an additional form in the application, called
FormF. Which statement is true?
A.FormF can be invoked from FormC using CALL_FORM.
B.FormF can be invoked from FormA using OPEN_FORM.
C.FormF can be invoked from FormD using CALL_FORM.
D.FormF can be invoked from FormE using CALL_FORM.
E.FormF can be invoked from FormB using OPEN_FORM.
Correct:D

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.6 View the Exhibit. You are coding a When-New-Form-Instance trigger to populate a hierarchical
tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the
president of the company, is the only employee who does not have a manager. In the trigger, you
declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record
group to populate the tree. You use the following code to create the record group: rg_emps :=
Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char(employee_id)
from employees connect by prior employee_id = manager_id start with manager_id is null'); You
then programmatically populate the record group, and then populate the tree with the record
group. You run the form to test it. Will the tree initially appear as shown? If not, why not?
A.Yes, the tree will appear as shown.
B.No. The first element selected in the select statement should be 4 because you want four levels of the
tree to be displayed.
C.No. You should eliminate the last element selected in the select statement, because you do not want to
display the employee ID.
D.No. The "connect by" statement should be "connect by prior manager_id = employee_id".
Correct:A

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.7 Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent
(represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the
CUSTOMERS table and has asked you to add an item to your form so that credit ratings can be
recorded. To restrict data entry clerks to one of these three values, you decide to create a radio
group for the Rating item. You want to allow for an undetermined (Null) credit rating, and users
should be able to update the credit rating from a value to an undetermined rating. How can you
implement this?
A.Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the
radio group to Null.
B.Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the
radio group to one of the credit rating values.
C.Create four radio buttons, and leave blank the value for the undetermined credit rating.
D.Choose a different type of input item, because radio groups do not allow entry and update of null values.
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.8 What type of message indicates a Forms message that cannot be suppressed?
A.a Busy message
B.a level 0 message
C.a Working message
D.a level 25 message
E.a level 50 message
F.a message with a level less than 0
G.a message with a level greater than 25
H.a message with a level greater than 50
Correct:G

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.9 In a multiform application, one form must invoke another. The form modules are called
Customers and Orders internally, but the compiled files are saved as CUST.FMX and ORD.FMX,
respectively. There is a button in the Customers form with a When-Button-Pressed trigger to
invoke the Orders form. There is a requirement that only one Orders form can be running at a time,
so the trigger must check to see if the form is already open. If it is open, the focus must be sent to
it. If it is not open, it has to be opened. Which of these trigger codes will achieve the required
functionality?
A.IF NOT FIND_FORM('ord') THEN OPEN_FORM('ord'); ELSE GO_FORM('orders'); END IF;
B.IF ID_NULL(FIND_FORM('ord')) THEN OPEN_FORM('orders'); ELSE GO_FORM('ord'); END IF;
C.IF ID_NULL(FIND_FORM('orders')) THEN OPEN_FORM('ord'); ELSE GO_FORM('orders'); END IF;
D.IF NOT FIND_FORM('orders')) THEN OPEN_FORM('orders'); ELSE GO_FORM('ord'); END IF;
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.10 You want to create a calculated item in the Control block of the Human Resources form. This
item will contain the total of employee salaries for employees in a particular department. Which
statement is true about how to create the calculated item?
A.You can create it by first creating a text item and then changing the item type.
B.You can create it in the Layout Editor using a special tool that creates a calculated item.
C.You can create it by first creating a display item and then setting appropriate properties in its Calculation
property group.
D.You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the
Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to
automatically calculate a sum of the selected Salary item.
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.11 View the Exhibit. You are modifying the New_Orders form. You want to change the navigation
order of the Orders block so that Order_Status is between Order_Date and Order_Mode in the
navigation order. You attempt to drag the Order_Status item in the Object Navigator (as shown in
the exhibit), but Forms does not allow you to release the item in the desired position. Why is this
happening, and what can you do to change the navigation order?
A.Because the data block is subclassed, you cannot change the order of items in the object navigator, but
you can change item properties to affect the navigation order.
B.Because the data block is subclassed, you can only drag objects to a lower position in the Object
Navigator, so you can drag Order_Mode and Customer_Id to a position below Order_Status.
C.Because the data block is subclassed, you will have to delete the object and then create it again in the
desired position.
D.Because the item is subclassed, you cannot change any of its properties.
Correct:A

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.12 The two-column LOCATION Record Group has 10 rows. At run time, the user wants to mark two
or more LOCATION records for use by another Forms Builder object. The rows will be used to
construct a WHERE clause for a subsequent data block query. Which built-in enable individual
rows to be marked?
A.ADD_GROUP_COLUMN
B.SET_RECORD_PROPERTY
C.GET_GROUP_SELECTION
D.SET_GROUP_SELECTION
E.RESET_GROUP_SELECTION
F.GET_GROUP_RECORD_NUMBER
Correct:D

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.13 To centralize some of your processing, you decide to write PL/SQL library modules that contain
procedures that can be called from form triggers or menu items. You need to populate some fields
based on values in other fields. Which code do you use?
A.IF FIND_ITEM('ORDERS.order_total') > 10000 THEN FIND_ITEM('ORDERS.large_order') := 'Y';
MESSAGE('WARNING - large order!'); END IF;
B.IF :ORDERS.order_total > 10000 THEN :ORDERS.large_order := 'Y'; MESSAGE('WARNING - large
order!'); END IF;
C.IF 'ORDERS.order_total' > 10000 THEN 'ORDERS.large_order' := 'Y'; MESSAGE('WARNING - large
order!'); END IF;
D.IF :ORDERS.order_total > 10000 THEN COPY('ORDERS.large_order','Y'); MESSAGE('WARNING -
large order!'); END IF;
E.IF NAME_IN('ORDERS.order_total') > 10000 THEN COPY('Y','ORDERS.large_order');
MESSAGE('WARNING - large order!'); END IF;
Correct:E

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.14 View the Exhibit. The EMPLOYEES table contains 100 records. You are developing a Human
Resources form that has an Employees block with properties as shown in the exhibit. When you
run the form and execute a query in the Employees block, approximately how many network
round trips will be made to the server before records are displayed in the block?
A.1
B.2
C.10
D.50
E.100
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.15 LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached
to the Employees form. There is a stored procedure in the database called Raise_Salary which
must be called without any parameters. There is no Raise_Salary procedure in the form or in the
attached library. A When-Button-Pressed trigger in the Employees form contains this code:
raise_salary; Where does Forms search for the Raise_Salary procedure?
A.first in the attached library, then in the database
B.first in the form module, then in the attached library
C.first in the form module, then in the attached library, then in the database
D.first in the form module, then in the attached library, then in other libraries in the working directory, then
in the database
E.in the form module only
F.in the attached library only
G.in the database only
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.16 You have the Orders form open in Forms Builder. You create an object group in the Orders form
and you try to drag various components in the Object Navigator to the object group. Which two
components will you be unable to place in the object group? (Choose two.)
A.the Orders block of the Orders form
B.the Order_CV canvas of the Orders form
C.the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
D.the When-New-Form-Instance trigger of the Orders form
E.the Product_Id item in the Order_Items block of the Orders form
Correct:C E

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.17 You need to resize the INVENTORY tab canvas. The Viewport Width and Height properties are
200 and 300. You change the values to 150 and 120, respectively. What implication may this have
on your design?
A.Some tab pages may be obscured at run time.
B.By decreasing the Viewport Width property, some tab pages may be deleted.
C.Objects previously within the borders of a tab page may fall outside the tab page border, and you will
get compilation errors.
D.Objects previously within the borders of a tab page may fall outside the tab page border and will be
visible at run time only by navigating to them programmatically.
E.Objects previously within the borders of a tab page may fall outside the tab page border and will be
assigned to the null canvas.
Correct:C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.18 You created a query Record Group at design time. Which built-in can you use to execute the
query defined in the Record Group object?
A.ADD_GROUP_ROW
B.POPULATE _GROUP
C.ADD_GROUP_COLUMN
D.SET_GROUP_SELECTION
E.CREATE_GROUP_FROM_QUERY
F.POPULATE _GROUP_WITH_QUERY
Correct:B

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.19 The Warehouse.fmb module contains two data blocks. You want to display items from each
data block on separate content canvases. You must ensure that both content canvases are visible
together at run time. Which two statements about content canvases are correct? (Choose two.)
A.A window cannot display more than one content canvas during a run time session.
B.A content canvas can be associated with a window by setting the Window property of the canvas.
C.Two or more content canvases can be displayed by associating each of them with a different window.
D.A content canvas can be associated with a window by setting the Primary Canvas property of the
window.
E.A content canvas can be associated with two or more windows by setting the Primary Canvas property
of the windows.
F.Two or more content canvases can be displayed by setting their viewports to be smaller than the
window with which they are to be associated.
Correct:B C

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141

NO.20 In the Orders form you define five LOVs, and you create one button to be used to display any of
the LOVs. The button is enabled only when the user navigates to a field with an attached LOV. If
the user supplies only part of the required input data, the LOVs use that input as search criteria to
automatically reduce the LOV contents. If the LOVs hold only one value that can possibly match
user-supplied input, then the LOVs auto-complete the input field and are not displayed. Which
built-in and properties should you use to display the LOVs?
A.Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO.
B.Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES.
C.Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO.
D.Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YES.
E.Use the Show_LOV built-in, and set the Mouse Navigate property value to YES.
F.Use the Show_LOV built-in, and set the Mouse Navigate property value to NO.
Correct:A

Oracle자료   1Z0-141   1Z0-141덤프   1Z0-141덤프   1Z0-141