IT 인증시험덤프

Microsoft MCTS 70-667최신덤프,9월 4일 업데이트

admin — Mon, 06 Sep 2010 03:33:52 +0000

Microsoft MCTS 70-667최신덤프를 여러분께 소개해드립니다. 70-667덤프는 지난 9월4일 v8.,02 버전으로 최신업데이트 진행되였습니다. 더는 유효기간 지난 덤프에 정력과 시간을 허비하지

마시고 killtest를 찾아주세요.

VUE/Prometric Code: 70-667

Exam: TS: Microsoft SharePoint Server 2010, Configuring (Available in 2010)

Ver:V8.02
Q&A:50 Q&As
업그레이트:2010-09-04

덤프보기:

1. You have a SharePoint Server 2010 server farm that contains a web application named WebApp1 and
a site collection named Site1. Users deploy several SharePoint user solutions to Site1.
You need to view tho average resource usage of the SharePoint user solutions for the last 14 days. What
should you view?
A. tha General Settings of WebApp1
B. the Site Web Analytics reports of Site1
C. the content of tho solution gallery of Site1
D. the health reports of WebApp1 from Central Administration
Answer: A
2. You have a SharePoint Server 2010 server farm. You need to enable trace logging for the Search
service. What should you configure?
A. diagnostic logging
B. the Health Analyzer rule definitions
C. the Search service application
D. usage and health data collection
Answer: A
3. You have a SharePoint Server 2010 server that contains two Web servers named Server1 and Server2.
You discover that the average CPU utilization on Server1 is 99 percent and the average CPU utilization
on Server2 is 1 percent. You need to decrease CPU utilization on Server1.
What should you do?
A. Create an additional application pool.
B. Create an extended Web application zone.
C. Configure Windows Network Load Balancing.
D. Configure the maximum number of worker processes
Answer: C
4. You have a SharePoint Server 2010 server farm. You modify the Web application default settings to
prevent views from displaying more than 2,000 Items. You discover a custom SharePoint user solution
that contains a custom Web Part display with more than 2,000 items. You need to prevent all Web Parts
from displaying more than 2,000 items. What should you do?
A. From Library Settings, modify the Validation Settings.
B. From Library Settings, modify the Per-location view settings.
C. From Central Administration, modify the Resource Throttling settings.
D. From Central Administration, modify the User Solutions Management settings.
Answer: C
5. You have a SharePoint Server 2010 server farm. You create two site collections named Site1 and Site2
that use the same template. You update the content and several Web Part pages in Site1. You need to
ensure that all changes in Site1 are automatically copied to Site2 every night.
What should you do?
A. Create a content deployment path.
B. Configure the Data Retrieval Service.

C. Configure the default backup and restore settings.
D. Modify the content database settings.
Answer: A
6. You have a SharePoint 2010 server farm. You need to ensure that you can restore the contents of a list
without restoring an entire site. You want to achieve this goal while using the minimum amount of
administrative effort. What should you do
A. From Central Administration, export the list.
B. From Central Administration, perform a full backup.
C. From Microsoft SQL Server Management Studio, configure differential backups.
D. From the SharePoint 2010 Management Shell, run the backup-spfarm cmdlet.
Answer: A
7. You have a SharePoint Server 2010 server farm. You need to change the location of the usage data
collection log files. What should you do?
A. From Central Administration, configure Diagnostic Logging.
B. From Central Administration, configure usage and health data collection.
C. From the SharePoint 2010 Management Shell, run the new-spusagelogfile cmdlet.
D. From the SharePoint 2010 Management Shell, run the set-spdiagnosticconfig cmdlet.
Answer: A

BEA 인증 0B0-109최신덤프

admin — Sat, 04 Sep 2010 01:31:37 +0000

WebLogic Server 9 0B0-109 시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 0B0-109 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /BEA9CertifiedDeveloperCertification/ 0B0-109.asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.

VUE/Prometric Code: 0B0-109

Exam: WebLogic Server 9

Ver:V8.02
Q&A:120 Q&As
업그레이트:2010-08-14

덤프문제:
1. A system exception is one that indicates that the business method of an EJB was prevented from
successfully executing because of some system-level error. Which of these statements is true about a
system exception?
A.It is a subclass of RemoteException or RuntimeException
B.It is propagated to clients as a RemoteException
C.It is caught and logged by the container
D.All of the above
Answer: D
2. What is the command to create a new web application archive (.war) file?
A.jar -Mvf someArchive.war *
B.jar -tvf someArchive.war *
C.jar -vf someArchive.war *
D.jar -cvf someArchive.war *
Answer: D
3. If cookies are disabled on the client browser, which of these methods on the HttpServletResponse
object can help in rewriting the URL with a session ID?
A.session.encodeURL()
B.session.writeURL()
C.session.encodeSessionIDinURL()
D.session.encodeSessionID()
Answer: A
4. Consider the following code snippet.
Context ctx = new InitialContext(); DataSource ds = (DataSource)ctx.lookup(”SomeDatasource”);
Which of these statements gets a JDBC connection successfully?
A.Connection con = ds.createConnection();
B.Connection con = ds.getConnection();
C.Connection con = ds.retrieveConnection();
D.Connection con = ctx.getConnection();
Answer: B
5. Entity bean activation involves
A.EJB Container providing a primary key identity to a pooled EJB
B.EJB Container moves an EJB from secondary storage to main memory
C.EJB Container creates a new EJB instance and adds to the active pool
D.None of the above
Answer: A
6. Which of these tags forces the EJB to be executed within a transaction started either
by the client or container?
A.Supports
B.Required
C.RequiresNew
D.Mandatory
Answer: B

Cisco Others 642-165최신덤프,합격율 100%

admin — Fri, 03 Sep 2010 03:17:00 +0000

Unified Communications Contact Center Express Implementation(UCCX) 642-165시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 642-165 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /Others/ 642-165 .asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.

VUE/Prometric Code: 642-165

Exam: Unified Communications Contact Center Express Implementation(UCCX)

Ver:V8.02
Q&A:89 Q&As
업그레이트:2010-08-28

덤프문제보기:

1. Which step can be used to trap runtime script errors and recover gracefully?
A. set
B. call subflow
C. on exception goto
D. get reporting statistic
Answer: C
2. which three tasks are supported by the cisco supervisor desktop?
A. push a web page to an agent s cisco agent desktop
B. chat with an agent
C. log in an agent
D. change an agent s state to ready
E. send an email to an agent
Answer: ABD
3. A preview outbound dialer uses which source and destination resources?
A. a CTI port to the custormer
B. the ACD line of the agent to the customer
C. the personal line of the agent to the customer
D. a CTI port the agent then redirected to the customer
Answer: D
4. Presence integration is a Cisco unified CCX teature available in which of these packages?
A. premium, enhanced,and standard
B. premium only
C. premium with high availability only
D. premium and enhanced\
Answer: A
5. which step would you use to get information about the numbet of contacts currently in queue?

A. get contact info
B. get session info
C. get call contact info
D. get reporting statistics
Answer: D
6. what is the maximux number of concurrent emails an agent can have ?
A. 1 email
B. 2 emails
C. 5 email s
D. 10 emails
Answer: C
7. how do you remove a phantom call (sometimes also referred to as ghost call) that is stuck in queue in
the CSQ real-time report?
A. log out all agents
B. restart the browser-based real-time reporting client
C. select the phantom call from the list of waiting contacts and select clear contact from the tools menu
D. reset the real-time reports
Answer: C

Cisco CCDP 642-873

admin — Thu, 02 Sep 2010 02:46:09 +0000

Designing Cisco network Service Architectures (ARCH) 642-873 시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 642-873 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /CCDP/642-873.asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다

VUE/Prometric Code: 642-873

Exam: Designing Cisco network Service Architectures (ARCH)

Ver:V8.02
Q&A:219 Q&As
업그레이트:2010-08-14

덤프문제보기:
1. You are the network consultant from Cisco.com. Please point out which Layer 2 access designs does
not support VLAN extensions?
A. FlexLinks
B. loop-free U
C. looped square
D. looped triangle
Answer: B
2. Which typical enterprise campus requirement ensures that the network supports the required
applications and that data flows within the required time frames?
A. availability
B. performance
C. functionality
D. manageability
Answer: C
3. You are the Cisco Network Designer in Cisco.com. Which of these is a Layer 2 transport architecture
that provides packet-based transmission optimized for data based on a dual ring topology?
A. Dynamic Trunking Protocol
B. Resilient Packet Ring
C. Synchronous Digital Hierarchy
D. Coarse Wave Division Multiplexing
Answer: B
4. What two choices can you make when redundancy is required from a branch office to a regional office?
(Choose two.)
A. multiple Frame Relay PVCs
B. dual Wan links to the regional office
C. dual Wan links to another branch office
D. single links - one to the regional office and one to another branch office
Answer: BD
5. Which one is not the feature of the Cisco Unified Wireless Network architecture?
A. network unification
B. remote access
C. mobility services
D. network management
Answer: B
6. What type of Call Admission control in CallManager allows for limits to the bandwidth consumed by
active calls?
A. regions
B. partitions
C. locations
D. device Pools
Answer: C

Microsoft MCSE 070-685최신덤프

admin — Wed, 01 Sep 2010 07:37:03 +0000

Pro: Windows 7, Enterprise Desktop Support Technician 070-685 덤프가 8월31일 최신업데이트를 진행하였습니다. 070-685시험준비신 분들은 killtest를 찾아주세요.^^ killtest는 고객님께서 보다 쉽게 시험에서 통과하도록 도와드립니다.

Microsoft MCSE 070-685

VUE/Prometric Code: 070-685

Exam: Pro: Windows 7, Enterprise Desktop Support Technician

Ver:V9.02
Q&A:60 Q&As
업그레이트:2010-08-31

덤프보기:

1. All client computers on your company network run Windows 7 and are members of an Active Directory
Domain Services domain.
The application control method was established by using Software Restriction Policies. These Software
Restriction Policies were deployed in a single Group Policy object (GPO) linked to the Organizational Unit
(OU) that contains the computers.
You plan to deploy Microsoft Office 2007 and configure AppLocker as the control within the GPO.
You need to ensure that core business applications continue to function.
What should you do?
A. Move the AppLocker rules to a different GPO.
B. Create new AppLocker rules that allow only digitally signed applications.
C. Create a new GPO. Apply the Software Restriction Policy and the AppLocker rules to the new GPO.
D. Recreate the AppLocker rules and apply them to the local security policy of each computer.
Answer: A
2. All client computers on your company network run Windows 7 and are members of a Windows Server
2008 R2 domain. The R&D department staff are local administrators on their computers and are members
of the R&D global security group.
A new version of a business software application is available on the network.
You plan to apply an AppLocker security policy to the R&D group.
You need to ensure that members of the R&D group are not allowed to upgrade the software.
What should you do?
A. Create an Audit only restriction based on the version of the software.
B. Create an Audit only restriction based on the publisher of the software.

C. Create an Enforce rule restriction based on the version of the software.
D. Create an Enforce rule restriction based on the publisher of the software.
Answer: C
3. All client computers on your company network run Windows 7 and are members of an Active Directory
Domain Services domain.
AppLocker is configured to allow only approved applications to run.

Employees with standard user account permissions are able to run applications that install into the user
profile folder.
You need to prevent standard users from running unauthorized applications.
What should you do?
A. Create Executable Rules by selecting the Create Default Rules option.
B. Create Windows Installer Rules by selecting the Create Default Rules option.
C. Create the following Windows Installer Rule:
Deny Everyone - %OSDRIVE%\Users\\Downloads\*
D. Create the following Executable Rule:
Deny - Everyone - %OSDRIVE%\Users\\Documents\*
Answer: A
4. All client computers on your company network run Windows 7. A standard Windows 7 image is loaded
on all new computers on the network.
A department in your company purchases several tablet computers. Employees report that the pen
interface does not work on the tablet computers.
You need to ensure that employees can use the pen interface.
What should you do?
A. Turn on the Media Features.
B. Turn on the Tablet PC Components.
C. Start the WMI Performance Adapter service and set it to Automatic.
D. Start the Human Interface Device Access service and set it to Automatic.
Answer: B

5. All client computers on your company network run Windows 7.
The preview displayed in the Content view of Windows Explorer and the Search box is considered a
security risk by your company.
You need to ensure that documents cannot be previewed in the Content view.
What should you do?
A. Change the Windows Explorer view to the List view and disable all Search indexes.

B. Set Group Policy to enable the Remove See More Results/Search Everywhere link setting.
C. Set Group Policy to enable the Turn off the display of snippets in Content view mode setting.
D. Set Group Policy to enable the Turn off display of recent search entries in the Windows Explorer
search box setting.
Answer: C

117-302최신덤프

admin — Mon, 30 Aug 2010 06:29:20 +0000

VUE/Prometric Code: 117-302

Exam: LPI 302 Mixed Environment Exam

Ver:V3.30
Q&A:146 Q&As
업그레이트:2010-08-14

LPICLevel3 117-302문제는 시험문제의 변화에 따라 업데이트가 될것입니다.시험문제가 매번 바뀐 후, 2일내에 시험문제 117-302 를 수정하여 다시 조정함으로서117-302:LPI 302 Mixed Environment Exam가 시험문제의 점유률을 항상 96% 이상으로 확보합니다.

덤프문제:

1. Which of the following should be backed up before a Samba version upgrade? (Choose TWO correct
answers.)
A. Libraries
B. TDB files
C. Configuration files
D. Binaries
E. winbindd_privileged directory
Answer: BC
2. How is VFS (Virtual File System) support enabled in Samba?
A. Samba does not support VFS.
B. Compile and load vfs.ko kernel module.
C. Compile and load vfs.ko and its dependent smbfs kernel modules.
D. Compile and load pvfs.ko kernel module.
E. Compile Samba with VFS module support.
Answer: E
3. Which of the following commands will mount a remote Samba share when the user is Winuser and the
password is
somepass?
A. mount -t smbfs -o username=Winuser,password=somepass //SERVER/share /media/sambashare
B. mount -t smbfs -o username=Winuser,password=somepass \\SERVER\share /media/sambashare
C. mount -t smbfs -o Winuser%somepass //SERVER/share /media/sambashare
D. mount -t smbfs -o username=Winuser%somepass //SERVER/share /media/sambashare
Answer: A
4. After installing a network with one Samba server and several clients, users are complaining that they
receive an
Unable to browse the network error when trying to visit a public share. What is the most likely cause of
this?
A. The user entered the wrong username and/or password.
B. The nmbd process is not running on the Samba server.
C. The user hasn’t mapped the share to a local drive letter yet.
D. The Samba server is not configured as a Domain Master Browser.
Answer: B
5. Which node type will use only NetBIOS broadcast requests using UDP broadcast?
A. b-node (type 0×01)
B. p-node (type 0×02)
C. m-node (type 0×04)
D. h-node (type 0×08)
Answer: A
6. By default, Windows XP requires that passwords on your Samba server:
A. do not exceed 32 characters.
B. contain both numbers and letters.
C. are encrypted.
D. are changed every 30 days.
Answer: C

Avaya 인증 133-S-713덤프

admin — Sat, 28 Aug 2010 05:53:12 +0000

Avaya Proactive Contact Solutions Implementation Exam (beta) 133-S-713 시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 133-S-713 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /AVAYA-CERTIFICATION/133-S-713 .asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.

업그레이트:2010-08-14

덤프문제보기:

1.Which Avaya software is used to provide consolidated reporting with Avaya Proactive Contact 4.X
and other Avaya communication solutions?
A. CMS
B. WebLM
C. Avaya IQ
D. Analyst
Answer: C
2.Which Avaya CM circuit pack is necessary if the customer expects to do predictive dialing on
Proactive Contact with CTI?
A. TN744 Call classifier
B. TN2602 Media interface
C. TN799 C-LAN
D. TN464 DS1 Interface
Answer: A
3.Which Proactive Contact component allows clients residing off the dialer to obtain events and real-
time data from the dialer?
A. Event Service
B. STATSPUMP
C. Historical Data Service Component (HDSC)
D. Dialer Command and Control Service (DCCS)
Answer: A
4 .Which two commands are used to configure the cti_passwd.cfg file for an Avaya Proactive Contact
with CTI with Agent Blending? (Choose two.)
A. cti_passwd
B. cti_passwd
C. cti_passwd -b
D. cti_passwd
Answer: C,D
5 .How does Proactive Contact move digitized messages from the CPU to the Large Port Voice Card
(LPVC)?
A. Remote Copy (RCP)
B. Network File System (NFS)
C. File Transfer Protocol (FTP)
D. Address Resolution Protocol (ARP)
Answer: B
6 .Which parameter in master.cfg is required to ensure correct agent capacity on a Proactive Contact
system?
A. PORTS
B. LINEASSIGN
C. QUOTA
D. MAXHIDSLOTS
Answer: D

Symantec 인증 250-510최신 업데이트 덤프

admin — Fri, 27 Aug 2010 07:36:03 +0000

Administration of SymantecTM Data Loss Prevention 10.5 - BETA 250-510 덤프가 8월25일 최신업데이트를 진행하였습니다. Killtest의 덤프제작팀은 프로급수준을 갖춘 IT전문가들로 구성되였으며 고객님들께 보다 완벽한 덤프를 제공해드리기 위해 전념하고 있습니다.250-510 덤프가 필요하신분은 Killtest를 찾아주세요.

VUE/Prometric Code: 250-510

Exam: Administration of SymantecTM Data Loss Prevention 10.5 - BETA

Ver:V8.02
Q&A:198 Q&As
업그레이트:2010-08-25

일부시험문제보기:

1. Which two products can be run on virtual servers? (Select two.)
A.Endpoint Discover
B.Endpoint Prevent
C.Network Monitor
D.Enforce
E.Network Prevent
Answer: DE
2. How is the incident count for a new system managed in order to avoid overwhelming the incident
response team?
A.Match count thresholds are set.
B.More than one policy is enabled.
C.Many incident responders are allowed access to the system.
D.Incidents are auto-filtered to hide false positives.
Answer: A
3. Which response rule action will be ignored when using an Exact Data Matching (EDM) policy?
A.Endpoint: Notify
B.Network: Block HTTP/HTTPS
C.Protect: Quarantine File
D.Network: Remove HTTP/HTTPS Content
Answer: A
4. Which two recommendations should an organization follow when deploying Endpoint Prevent? (Select
two.)
A.test the agent on a variety of end-user images
B.initially enable monitoring of the local file system
C.enable monitoring of many destinations and protocols simultaneously
D.configure, test, and tune filters
E.configure blocking as soon as the agents are deployed

Answer: AD
5. Which plug-in can connect to Microsoft Active Directory (AD)?
A.CSV Lookup
B.Live LDAP Lookup
C.Active Directory Integration Lookup
D.Directory Server Lookup
Answer: B
6. Which information is recommended to be included in an Exact Data Matching (EDM) data source?
A.date fields
B.numeric fields with fewer than five digits
C.column names in the first row
D.country, state, or province names
Answer: C

640-802덤프 Cisco Certified Network Associate(CCNA) 인증시험

admin — Tue, 10 Aug 2010 01:18:40 +0000

Cisco Certified Network Associate(CCNA) 640-802 시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 640-802 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /CCNA/640-802.asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.

VUE/Prometric Code: 640-802

Exam: Cisco Certified Network Associate(CCNA)

Ver:V21.02
Q&A:434 Q&As
업그레이트:2010-07-13

덤프먼저보기:

1. Refer to the exhibit. What could be possible causes for the “Serial0/0 is down” interface status?

(Choose two.)

A. A Layer 1 problem exists.

B. The bandwidth is set too low.

C. A protocol mismatch exists.

D. An incorrect cable is being used.

E. There is an incorrect IP address on the Serial 0/0 interface.

Answer: AD

2. Before installing a new, upgraded version of the IOS, what should be checked on the router, and which

command should be used to gather this information? (Choose two.)

A. the amount of available ROM

B. the amount of available flash and RAM memory

C. the version of the bootstrap software present on the router

D. show version

E. show processes

F. show running-config

Answer: BD

4. Refer to the exhibit. Which two statements are true about interVLAN routing in the topology that is

shown in the exhibit? (Choose two.)

A. Host E and host F use the same IP gateway address.

B. Router1 and Switch2 should be connected via a crossover cable.

C. Router1 will not play a role in communications between host A and host D.

D. The FastEthernet 0/0 interface on Router1 must be configured with subinterfaces.

E. Router1 needs more LAN interfaces to accommodate the VLANs that are shown in the exhibit.

F. The FastEthernet 0/0 interface on Router1 and Switch2 trunk ports must be configured using the same

encapsulation type.

Answer: DF

5. Refer to the exhibit. Which two statements are true about the loopback address that is configured on

RouterB? (Choose two.)

A. It ensures that data will be forwarded by RouterB.

B. It provides stability for the OSPF process on RouterB.

C. It specifies that the router ID for RouterB should be 10.0.0.1.

D. It decreases the metric for routes that are advertised from RouterB.

E. It indicates that RouterB should be elected the DR for the LAN.

Answer: BC

6. A network administrator is explaining VTP configuration to a new technician. What should the network

administrator tell the new technician about VTP configuration? (Choose three.)

A. A switch in the VTP client mode cannot update its local VLAN database.

B. A trunk link must be configured between the switches to forward VTP updates.

C. A switch in the VTP server mode can update a switch in the VTP transparent mode.

D. A switch in the VTP transparent mode will forward updates that it receives to other switches.

E. A switch in the VTP server mode only updates switches in the VTP client mode that have a higher VTPrevision number.

F. A switch in the VTP server mode will update switches in the VTP client mode regardless of the

configured VTP domain membership.

Answer: ABD

7. Which two locations can be configured as a source for the IOS image in the boot system command?

(Choose two.)

A. RAM

B. NVRAM

C. flash memory

D. HTTP server

E. TFTP server

F. Telnet server

Answer: CE

link:http://www.killtest.kr/

tag:640-802

Oracle OCA 1Z0-147최신덤프

admin — Tue, 10 Aug 2010 01:17:31 +0000

Oracle9i program with pl/sql 1Z0-147시험문제는IT 인증강사 및 제품 전문가가 시험문제를 완벽하게 만들었습니다. 최근 출제되었던 시험문제에서 1Z0-147 가 모든 문제와 정답을 맞추었습니다.Killtest 인증시험문제를 구매한 고객분들은 일년 동안 무료로 업그레이드 서비스를 받을 수 있습니다. /OCA/1Z0-147.asp 시험문제는 고객님이 한번에 인증시험을 통과할 수 있는 것을 도와 줄 것입니다. 떨어지는 경우 전액 환불을 약속합니다.

VUE/Prometric Code: 1Z0-147

Exam: Oracle9i program with pl/sql

Ver:V4.56
Q&A:132 Q&As
업그레이트:2010-07-13

일부덤프문제보기:
1.What can you do with the DBMS_LOB package?
A.Use the DBMS_LOB.WRITE procedure to write data to a BFILE.
B.Use the DBMS_LOB.BFILENAME function to locate an external BFILE.
C.Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.
D.Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed.
Correct:D
2.Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER,
V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID,
V_LAST_NAME); COMMIT; END; This procedure must invoke the UPD_BAT_STAT procedure and
pass a parameter. Which statement, when added to the above procedure, will successfully invoke
the UPD_BAT_STAT procedure?
A.EXECUTE UPD_BAT_STAT(V_ID);
B.UPD_BAT_STAT(V_ID);
C.RUN UPD_BAT_STAT(V_ID);
D.START UPD_BAT_STAT(V_ID);
Correct:B
3.Which three describe a stored procedure? (Choose three.)
A.A stored procedure is typically written in SQL.
B.By default, a stored procedure executes with the privileges of its owner.
C.A stored procedure has three parts: the specification, the body, and the exception handler part .
D.A stored procedure is stored in the database and can be shared by a number of programs.
E.A stored procedure offers some advantages over a standalone SQL statement, such as programmable
functionality and compiled code.
Correct:B D E
4.Examine this package: CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT
prodid FROM product ORDER BY prodid DESC; PROCEDURE proc1; PROCEDURE proc2; END
pack_cur; / CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodid NUMBER;
PROCEDURE proc1 IS BEGIN OPEN c1; LOOP FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE(’Row is: ‘ || c1%ROWCOUNT); EXIT WHEN c1%ROWCOUNT >= 3; END
LOOP; END proc1; PROCEDURE proc2 IS BEGIN LOOP FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE(’Row is: ‘ ||c1%ROWCOUNT); EXIT WHEN c1%ROWCOUNT >= 6; END
LOOP; CLOSE c1; END proc2; END pack_cur; / The product table has more than 1000 rows. The
SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table has more than
1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table
has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session.
You execute the procedure PROC1 from SQL*Plus with the command: The product table has more
than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 What is the
output in your session? EXECUTE pack_cur.proc1 What is the output in your session? What is the
output in your session? A. ERROR at line 1: What is the output in your session? A. ERROR at line
1: A. ERROR at line 1: B. Row is:
A.ERROR at line 1:
B.Row is:
C.Row is:
D.Row is: Row is:
E.Row is: 1 Row is:
F.Row is: 1 Row is: 2
G.Row is: 1 Row is: 2 Row is: 3
H.Row is: 1 Row is: 2 Row is: 3 Row is: 2 Row is: 3
I.Row is: 4
J.Row is: 4 Row is: 5
K.Row is: 4 Row is: 5 Row is: 6 Row is: 5 Row is: 6
Correct:E F G H
5.Examine this procedure: CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER,
V_CITY in VARCHAR2 DEFAULT ‘AUSTIN’, V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM
(id, city, name) VALUES (v_id, v_city, v_name); COMMIT; END; Which two statements will
successfully invoke this procedure in SQL*Plus? (Choose two.)
A.EXECUTE INSERT_TEAM;
B.EXECUTE INSERT_TEAM(3, V_NAME=>’LONGHORNS’, V_CITY=>’AUSTIN’);
C.EXECUTE INSERT_TEAM(3,’AUSTIN’,'LONGHORNS’);
D.EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := ‘LONGHORNS’, V_CITY := ‘AUSTIN’);
E.EXECUTE INSERT_TEAM (3,’LONGHORNS’);
Correct:B C
6.You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)
A.table
B.DML event
C.trigger body
D.package body
E.package name
F.trigger name
G.system event
H.trigger timing
Correct:A B C F H

1Z0-147 덤프다운로드바로가기: http://www.killtest.kr/OCA/1Z0-147.asp