ITPub博客

（96）Examine the structure of the INVOICE table.name         Null          TypeINV_NO     NOT NULL NUMBER(3)INV_DATE     ...

（100）View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.)A.SELECT promo_id, DECODE(NVL(promo_cost,0), promo_cost,promo_cost * 0.25, 100) "Discount"FROM prom...

（93）View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers.Customers whose credit limit has not been entered should have the message " Not Available" displ...

（94）Examine the structure of the PROGRAMS table:name                Null           TypePROG_ID        ...

（95）The PRODUCTS table has the following structure:name                          Null            ...

（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 expressions in the list must be of the same data type.D. It requires that at l...

（92）View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format.Which two queries give the correct result? (Choose two.)A. SELECT promo_name, TO_CHAR(promo_end_date,'Day')  || ', ' &...

（97）View the Exhibit and evaluate the structure and data in the CUST_STATUS table. You issue the following SQL statement:SELECT custno, NVL2(NULLIF(amt_spent, credit_limit), 0, 1000) "BONUS" FROM cust_status;Which statement is true regarding the execution of ...

（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 A.You issue the following SQL statement:SELECT AVG(CASE WHEN promo_c...

Oracle闪回技术是一组Oracle数据库功能，允许你查看数据库对象的过去的状态或回退数据库到之前的状态，而无需进行PITR。使用闪回技术可以：1. 执行返回历史数据的查询2. 执行返回元数据的查询，这些元数据可以显示对数据库改变的详细的历史。3. 恢复表或行到以前的时间点4. 自动地跟踪和归档事务数据...

（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') FROM DUAL;B. SELECT TO_CHAR(TO_DATE('11-oct-2007...

（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 - '01-JAN-2007' FROM DUAL;B. SELECT SYSDATE - TO_DATE('01/JANUARY/2007')...

（81）You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SELECT ROUND(SYSDATE - promo_begin_date, 0)FROM promotionsWHERE (SYSDATE - promo_begin_date)/365 > 2;...

（85）View the Exhibit 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.)答案：（D、E）解析：A（X）,隐式转换可以正常执行sc...

（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-81W...

（82）Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAMERenske LadwigJason MallinSamuel McCainAllan MCEwenIrene MikkilineniJulia NayerYou need...

（86）Examine the structure and data of the CUST_TRANS table:CUST_TRANSName                 Null          TypeCUSTNO &nbsp...

（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 nam...

（87）You want to display the date for the first Monday of the next month and issue the following command:SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), 'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;What is the outcome?A. It executes successfull...

（75）The following data exists in the PRODUCTS table:PROD_ID PROD_LIST_PRICE123456  152525.99You issue the following query:SELECT RPAD(( ROUND(prod_list_price)), 10, '*')FROM products WHERE prod_id = 1...