- ocp考试
- ocp 11g考题大全：1Z0-051-099题
ocp 11g考题大全：1Z0-051-099题，完整题库请点击这里联系老师咨询了解99. View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you need to find out the average cost for all promos in the ranges$0-2000 and $2000-5000 in category AYou issue th...
- ocp 11g考题大全：1Z0-051-098题
ocp 11g考题大全：1Z0-051-098题，完整题库请点击这里联系老师咨询了解98. Which statement is true regarding the COALESCE function?A. It can have a maximum of five expressions in a list.B. It returns the highest NOT NULL value in the list for all rows.C. It requires that all expressi...
- ocp 11g考题大全：1Z0-051-097题
ocp 11g考题大全：1Z0-051-097题，完整题库请点击这里联系老师咨询了解97. View the Exhibit and evaluate the structure and data in the CUST_STATUS table.You issue the following SQL statement:SQL> SELECT custno, NVL2(NULLIF(amt_spent, credit_limit), 0, 1000)"BONUS"FROM cust_status;...
- ocp 11g考题大全：1Z0-051-096题
ocp 11g考题大全：1Z0-051-096题，完整题库请点击这里联系老师咨询了解96. Examine the structure of the INVOICE table.name Null TypeINV_NO NOT NULL NUMBER(3)INV_DATE DATEINV_AMT NUMBER(10,2)Which two SQL statements would execute successfully? (Choose two.)A. SELECT inv_no,NVL2(inv_da...
- ocp 11g考题大全：1Z0-051-095题
ocp 11g考题大全：1Z0-051-095题，完整题库请点击这里联系老师咨询了解95. The PRODUCTS table has the following structure:name Null TypePROD_ID NOT NULL NUMBER(4)PROD_NAME VARCHAR2(25)PROD_EXPIRY_DATE DATEEvaluate the following two SQL statements:SQL>SELECT prod_id, NVL2(prod_expi...
- ocp 11g考题大全：1Z0-051-094题
ocp 11g考题大全：1Z0-051-094题，完整题库请点击这里联系老师咨询了解94. Examine the structure of the PROGRAMS table:name Null TypePROG_ID NOT NULL NUMBER(3)PROG_COST NUMBER(8,2)START_DATE NOT NULL DATEEND_DATE DATEWhich two SQL statements would execute successfully? (Choose two.)A...
- ocp 11g考题大全：1Z0-051-093题
ocp 11g考题大全：1Z0-051-093题，完整题库请点击这里联系老师咨询了解93. View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, y ou need to generate a report that shows an increase in the credit limitby 15% for all customers. Customers whose c...
- ocp 11g考题大全：1Z0-051-092题
ocp 11g考题大全：1Z0-051-092题，完整题库请点击这里联系老师咨询了解92. View the E xhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns ofthe PROMOTIONS table, and the required output format.Which two queries give the correct result? (Choose two.)A. SELECT prom...
- ocp 11g考题大全：1Z0-051-091题
ocp 11g考题大全：1Z0-051-091题，完整题库请点击这里联系老师咨询了解91. View the Exhibit and examine the structure of the PROMOTIONS table.Which two SQL statements would execute successfully? (Choose two.)A. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE TO_CHAR(promo_end_...
- ocp 11g考题大全：1Z0-051-090题
ocp 11g考题大全：1Z0-051-090题，完整题库请点击这里联系老师咨询了解90. Examine the structure and data in the PRICE_LIST table:name Null TypePROD_ID NOT NULL NUMBER(3)PROD_PRICE VARCHAR2(10)PROD_ID PROD_PRICE100 $234.55101 $6,509.75102 $1,234You plan to give a discount of 25% on t...
- ocp 11g考题大全：1Z0-051-089题
ocp 11g考题大全：1Z0-051-089题，完整题库请点击这里联系老师咨询了解89. You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.Which SQL statement would give the required result?A. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year')FR...
- ocp 11g考题大全：1Z0-051-088题
ocp 11g考题大全：1Z0-051-088题，完整题库请点击这里联系老师咨询了解88. You need to calculate the number of days from 1st January 2007 till date.Dates are stored in the default format of dd-mon-rr.Which SQL statements would give the required output? (Choose two .)A. SELECT SYSDATE...
- ocp 11g考题大全：1Z0-051-087题
ocp 11g考题大全：1Z0-051-087题，完整题库请点击这里联系老师咨询了解87. You want to display the date for the first Mon day of the next month and issue the followingcommand:SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),‘dd "is the first Monday for" fmmonth rrrr')FROM DUA...
- ocp 11g考题大全：1Z0-051-086题
ocp 11g考题大全：1Z0-051-086题，完整题库请点击这里联系老师咨询了解86. Examine the structure and data of the CUST_TRANS table:CUST_TRANSName Null TypeCUSTNO NOT NULL CHAR(2)TRANSDATE DATETRANSAMT NUMBER(6,2)CUSTNO TRANSDATE TRANSAMT11 01-JAN-07 100022 01-FEB-07 200033 01-MAR-07 3...
- ocp 11g考题大全：1Z0-051-085题
ocp 11g考题大全：1Z0-051-085题，完整题库请点击这里联系老师咨询了解85. View the E xhibit and examine the structure and data in the INVOICE table.Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.)A. inv_amt ='0255982' ...
- ocp 11g考题大全：1Z0-051-084题
ocp 11g考题大全：1Z0-051-084题，完整题库请点击这里联系老师咨询了解84. View the Exhibit and examine the structure of the EMPLOYEES table.Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:ENAME HIREDATESMITH 17-DEC-80ALLEN 20-FEB-81WARD 22-FEB-81You want to...
- ocp 11g考题大全：1Z0-051-083题
ocp 11g考题大全：1Z0-051-083题，完整题库请点击这里联系老师咨询了解83. Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAMELex De HaanRenske LadwigJose Manuel UrmanJason MallinYou want to extract only those customer names that have three names and display the...
- ocp 11g考题大全：1Z0-051-082题
ocp 11g考题大全：1Z0-051-082题，完整题库请点击这里联系老师咨询了解82. Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAMERenske LadwigJason MallinSamuel McCainAllan MCEwenIrene MikkilineniJulia NayerYou need to display customers' second names where the seco...
- ocp 11g考题大全：1Z0-051-081题
ocp 11g考题大全：1Z0-051-081题，完整题库请点击这里联系老师咨询了解81. You are currently located in Singapore and have connected to a remote database in Chicago.You issue the following command:SQL> SELECT ROUND(SYSDATE-promo_begin_date,0)FROM promotionsWHERE (SYSDATE-promo_beg...
- ocp 11g认证考试题：1Z0-051-080题
ocp 11g认证考试题：1Z0-051-080题，完整题库请点击这里联系老师咨询了解80. Which two statements are true regarding working with dates? (Choose two.)A. The default internal storage of dates is in the numeric format.B. The default internal storage of dates is in the character format....
- ocp 11g认证考试题：1Z0-051-079题
ocp 11g认证考试题：1Z0-051-079题，完整题库请点击这里联系老师咨询了解79. View the Exhibit and examine the structure of the CUSTOMERS table.In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'.You issue the following query:SQL> SELECT LO...
- ocp 11g认证考试题：1Z0-051-078题
ocp 11g认证考试题：1Z0-051-078题，完整题库请点击这里联系老师咨询了解78. Evaluate the following query:SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL;What would be the outcome?A. 16B. 100C. 160D. 200E. 150Answer: C答案解析：ROUND(156.00,-1)=160，四舍五入，精确到十位TRUNC(160，...
- ocp 11g认证考试题：1Z0-051-077题
ocp 11g认证考试题：1Z0-051-077题，完整题库请点击这里联系老师咨询了解77. In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for theCUST_FIRST_NAME 'ABIGAIL'.Evaluate the following query:SQL> SELECT INITCAP(cust_first_name ' 'UPPER(SUBSTR(cust_city,-LENGTH(...
- ocp 11g认证考试题：1Z0-051-076题
ocp 11g认证考试题：1Z0-051-076题，完整题库请点击这里联系老师咨询了解76. You need to display the first names of all customers from the CUSTOMERS table that contain thecharacter 'e' and have the character 'a' in the second last position.Which query would give the required output?A...
- ocp 11g认证考试题：1Z0-051-075题
ocp 11g认证考试题：1Z0-051-075题，完整题库请点击这里联系老师咨询了解75. The following data exists in the PRODUCTS table:PROD_ID PROD_LIST_PRICE123456 152525.99You issue the following query:SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')FROM productsWHERE prod_id = 123456;...
- ocp 11g认证考试题：1Z0-051-074题
ocp 11g认证考试题：1Z0-051-074题，完整题库请点击这里联系老师咨询了解74. Which statements are true regarding single row functions? (Choose all that apply.)A. MOD : returns the quotient of a divisionB. TRUNC : can be used with NUMBER and DATE valuesC. CONCAT : can be used to combi...
- ocp 11g认证考试题：1Z0-051-073题
ocp 11g认证考试题：1Z0-051-073题，完整题库请点击这里联系老师咨询了解73. Which tasks can be performed using SQL functions that are built into Oracle database ? (Choose three .)A. finding the remainder of a divisionB. adding a number to a date for a resultant date valueC. comparin...
- ocp 11g认证考试题：1Z0-051-072题
ocp 11g认证考试题：1Z0-051-072题，完整题库请点击这里联系老师咨询了解72. Which tasks can be performed using SQL functions built into Oracle Database ? (Choose three.)A. displaying a date in a nondefault formatB. finding the number of characters in an expressionC. substituting a c...
- ocp 11g认证考试题：1Z0-051-071题
ocp 11g认证考试题：1Z0-051-071题，完整题库请点击这里联系老师咨询了解71. Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database ? (Choose three .)A. addition SUMB. subtractionC. raising to a powerD. finding the quotient...
- ocp 11g认证考试题：1Z0-051-070题
ocp 11g认证考试题：1Z0-051-070题，完整题库请点击这里联系老师咨询了解70. View the E xhibit and examine the structure of the PRODUCTS table.You want to display only those product names with their list prices where the list price is at least doublethe minimum price. The report shou...
