High quality and Value for the 1Z0-051 Exam.
Killtest Practice Exams for Oracle Database: SQL Fundamentals I 1Z0-051 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your Other Oracle Certification exam and get your Other Oracle Certification Certification.
We guarantee your success in the first attempt. If you do not pass the 1Z0-051 (Oracle Database: SQL Fundamentals I) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
73. Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit = 1000 OR cust_credit_limit = 2000 OR
cust_credit_limit = 3000;
Which statement is true regarding the above two queries?
A.Performance would improve in query 2.
B.Performance would degrade in query 2.
C.There would be no change in performance.
D.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
Answer: C
74. View the Exhibit and examine the structure of the PROMOTIONS table
Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on ‘TV’ and ‘internet’ that ended in the time interval 15th March ’00 to 15th October ’00.
Which two queries would give the required result? (Choose two.)
A.SELECT promo_name, promo_cost
FROM promotions
WHERE promo_category IN (‘TV’, ‘internet’) ANDpromo_end_date BETWEEN ’15-MAR-00′ AND ’15-OCT-00′;
B.SELECT promo_name, promo_cost
FROM promotions
WHERE promo_category = ‘TV’ OR promo_category =’internet’ ANDpromo_end_date >=’15-MAR-00′ OR promo_end_date <=’15-OCT-00′;
C.SELECT promo_name, promo_cost
FROM promotions WHERE (promo_category BETWEEN ‘TV’ AND ‘internet’) AND(promo_end_date IN (’15-MAR-00′,’15-OCT-00′));
D.SELECT promo_name, promo_cost
Answer: AD
1Z0-051：please download 1Z0-051 in PDF format Demo
Related Posts
Friday, December 5th, 2008, 3:14 am | 
1Z0-051 | 
RSS feed
Comments and pings are currently closed.
