Oracle.1Z0-051.175q(9)

B. SELECT prod_name q'['s ]'category is ' prod_category CATEGORIES FROM products;

C. SELECT prod_name q'\'s\' ' category is ' prod_category CATEGORIES FROM products;

D. SELECT prod_name q'<'s >' 'category is ' prod_category CATEGORIES FROM products;

Answer: CD

QUESTION 14

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount

in each income level. The report should NOT show any repeated credit amounts in each income level.

Which query would give the required result?

A. SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit"

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新小学教育Oracle.1Z0-051.175q(9)全文阅读和word下载服务。