- 论坛徽章:
- 0
|
<p align="left"><p align="left">最新1Z0-051考題分享</p></p><p align="left"><p align="left">1. Which statement is true regarding the INTERSECT operator?</p></p><p align="left"><p align="left">A. It ignores NULL values.</p></p><p align="left"><p align="left">B. Reversing the order of the intersected tables alters the result.</p></p><p align="left"><p align="left">C. The names of columns in all SELECT statements must be identical.</p></p><p align="left"><p align="left">D. The number of columns and data types must be identical for all SELECT statements in the query.</p></p><p align="left"><p align="left">Answer: D</p></p><p align="left"><p align="left">2. View the Exhibit; e xamine the structure of the PROMOTIONS table.</p></p><p align="left"><p align="left">Each promotion has a duration of at least seven days .</p></p><p align="left"><p align="left">Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date.</p></p><p align="left"><p align="left">Which query would achieve the required result?</p></p><p align="left"><p align="left">A. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7</p></p><p align="left"><p align="left">FROM promotions;</p></p><p align="left"><p align="left">B. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7</p></p><p align="left"><p align="left">FROM promotions;</p></p><p align="left"><p align="left">C. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7)</p></p><p align="left"><p align="left">FROM promotions;</p></p><p align="left"><p align="left">D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7)</p></p><p align="left"><p align="left">FROM promotions;</p></p><p align="left"><p align="left">Answer: D</p></p><p align="left"><p align="left">3. Evaluate the following query:</p></p><p align="left"><p align="left">SQL> SELECT promo_name q'{'s start date was }' promo_begin_date</p></p><p align="left"><p align="left">AS "romotion Launches" FROM promotions;</p></p><p align="left"><p align="left">What would be the outcome of the above query?</p></p><p align="left"><p align="left">A. It produces an error because flower braces have been used.</p></p><p align="left"><p align="left">B. It produces an error because the data types are not matching.</p></p><p align="left"><p align="left">C. It executes successfully and introduces an 's at the end of each promo_name in the output.</p></p><p align="left"><p align="left">D. It executes successfully and displays the literal " {'s start date was } " for each row in the output.</p></p><p align="left"><p align="left">Answer: C</p></p><p align="left"><p align="left">4. You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase .Which statement would accomplish this requirement?</p></p><p align="left"><p align="left">A. SELECT cust_last_name Name, cust_credit_limit + 1000</p></p><p align="left"><p align="left">"New Credit Limit"</p></p><p align="left"><p align="left">FROM customers;</p></p><p align="left"><p align="left">B. SELECT cust_last_name AS Name, cust_credit_limit + 1000</p></p><p align="left"><p align="left">AS New Credit Limit</p></p><p align="left"><p align="left">FROM customers;</p></p><p align="left"><p align="left">C. SELECT cust_last_name AS "Name", cust_credit_limit + 1000</p></p><p align="left"><p align="left">AS "New Credit Limit"</p></p><p align="left"><p align="left">FROM customers;</p></p><p align="left"><p align="left">D. SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000</p></p><p align="left"><p align="left">INITCAP("NEW CREDIT LIMIT"</p></p><p align="left"><p align="left">FROM customers;</p></p><p align="left"><p align="left">Answer: C</p></p><p align="left"><p align="left">5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)</p></p><p align="left"><p align="left">A. SELECT TO_CHAR(1890.55,'$0G000D00')</p></p><p align="left"><p align="left">FROM DUAL;</p></p><p align="left"><p align="left">B. SELECT TO_CHAR(1890.55,'$9,999V99')</p></p><p align="left"><p align="left">FROM DUAL;</p></p><p align="left"><p align="left">C. SELECT TO_CHAR(1890.55,'$99,999D99')</p></p><p align="left"><p align="left">FROM DUAL;</p></p><p align="left"><p align="left">D. SELECT TO_CHAR(1890.55,'$99G999D00')</p></p><p align="left"><p align="left">FROM DUAL;</p></p><p align="left"><p align="left">E. SELECT TO_CHAR(1890.55,'$99G999D99')</p></p><p align="left"><p align="left">FROM DUAL;</p></p><p align="left"><p align="left">Answer: ADE</p></p> |
|