QUESTION 1 View the Exhibit and examine the structure of the ORDERS table. You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101. Which query would give you the desired output? A. SELECT order_id, order_date FROM orders […]
QUESTION 1 You have assigned rights profiles directly to the uses frank and now you want to add another profile. Which command enables you to list profiles directly assigned to frank? A. userattr profiles frank B. profiles – p frank C. useratter -p frank D. profiles frank Answer: B Explanation: http://docs.oracle.com/cd/E26502_01/html/E36219/rights-1.html (see the example 9-1)
QUESTION 1 What determines which bits in an IP address represent the subnet, and which represent the host? A. Subnet B. unicast C. netmask D. multicast E. broadcast Answer: C QUESTION 2 Which two accurately identify features of a Solaris 10 branded zone? A. executes in a Solaris 10 global zone B. is created by […]
QUESTION 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. Answer: […]
QUESTION 1 Examine the parameters for your database instance: NAMETYPE VALUE ————————– ——————————- ————————— undo_management string AUTO undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1 You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario? A. Undo data is written to flashback logs after 1200 seconds. B. Inactive undo […]
QUESTION 1 You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the credit period. 2) The data in the column should be stored in a format such that it can […]
QUESTION 1 You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance? A. Enable Memory Access Mode, which reads performance […]
QUESTION 1 Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.) A. An extent cannot spread across data files. B. A segment cannot spread across data files. C. A data file can belong to only one tablespace. D. A data file can have only one segment […]
QUESTION 1 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? (Choose three.) A. INSERT INTO employees VALUES ( NULL, ‘John’, ‘Smith’); B. INSERT INTO employees( first_name, last_name) VALUES( ‘John’, ‘Smith’); C. INSERT INTO employees VALUES ( ‘1000’, ‘John’, NULL); […]
QUESTION 81 Your company has a main office and a branch office. A portable computer runs Windows 7. On the computer, you configure a printer for each office. You need to configure printing on the computer to meet the following requirements: – When you are located in the main office, all documents must automatically print […]
QUESTION 1 You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber? A. Drop Journal, remove existing subscribers, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces […]
QUESTION 1 Which Layer 2 mechanism should be used to authenticate wireless or wired users before allowing them access to network resources? A. 802.1X B. MIMO C. 802.1Z D. WPA Answer: A QUESTION 2 Which HP switch supports nine switches in an IRF topology? A. 5120-SI B. 9 5820 C. 7500 D. 12500 Answer: B […]
QUESTION 1 HP Intelligent Management Centers (IMC’s) Intelligent Configuration Center and Access Control List (ACL) Manager align with which FCAPS category? A. Performance B. Fault C. Accounting D. Configuration Answer: B QUESTION 2 A customer wants to implement a network access control solution to ensure that only devices which meet company policies are allowed to […]
QUESTION 76 You are designing a Cisco Unified Contact Center Express system with four requirements: 250 configured agents 150 agents maximum logged in at any given time 30 agents able to make outbound calls 20 agents able to answer emails How many premium seats should be purchased? A. 150 seats B. 180 seats C. 200 […]
QUESTION 81 Where can you start, stop, and restart Cisco unified Contact Center Express services? A. Control Center on Cisco Unified Contact Center Express Serviceability B. System page on Cisco Unified Contact Center Express Administrator C. Cisco Desktop Administrator D. Cisco Unified Communications Operating System Administrator Answer: A
QUESTION 91 Which tool is used to estimate the hardware server resources that are required for a Cisco Unified CCX deployment? A. IPC Resource Calculator B. CT1 Port Calculator C. Cisco Unified Communications Sizing Tool D. Cisco Unified CCX Applications Administration Answer: C
All Cisco 642-165 exam questions are from http://www.lead2pass.com/642-165.html QUESTION 96 What is the maximum number of concurrent emails an agent can have? A. 1 email B. 2 emails C. 5 email s D. 10 emails Answer: C