1z1-061 試験問題を無料オンラインアクセス

View the Exhibit and examine the structure of the PROMOSTIONS table:
Exhibit:

Which two SQL statements are valid? (Choose two.)

• A.SELECT promo_id, DECODE (NULLIF(promo_cost, 10000),NULL, promo_cost*.25,
  'N/A') "Catcost"FROM promotions;
• B.SELECT promo_id, DECODE (promo_cost, 10000,DECODE(promo_category, 'G1', promo_cost *.25, NULL),NULL) "Catcost"FROM promotions;
• C.SELECT promo_id, DECODE (NVL(promo_cost, 0), promo_cost,promo_cost * 0.25,
  100) "Discount"FROM promotions;
• D.SELECT promo_id, DECODE (promo_cost, >10000, 'High',<10000, 'Low')
  "Range"FROM promotions;

What does the FORCE option for creating a view do?

• A.creates a view regardless of whether or not the base tables exist
• B.creates a view in another schema even if you don't have privileges
• C.creates a view with constraints
• D.creates a view even if the underlying parent table has constraints

Examine the data in the CUSTOMERS table:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:
SQL>SELECT c1.custname, c1.city
FROM Customers c1 __________________ Customers c2
ON (c1.city=c2.city AND c1.custname<>c2.custname);
Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)

• A.NATURAL JOIN
• B.JOIN
• C.RIGHT OUTER JOIN
• D.LEFT OUTER JOIN
• E.FULL OUTER JOIN

View the Exhibit and examine the structure of the CUSTOMERS and GRADES tables:

You need to display names and grades of customers who have the highest credit limit.
Which two SQL statements would accomplish the task? (Choose two.)

• A.SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)FROM customers)AND cust_credit_limit BETWEEN startval AND endval;
• B.SELECT custname, gradeFROM customers, gradesWHERE (SELECT
  MAX(cust_credit_limit)FROM customers) BETWEEN startval and endvalAND
  cust_credit_limit BETWEEN startval AND endval;
• C.SELECT custname, gradeFROM customers , gradesWHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)FROM customers)AND MAX(cust_credit_limit) BETWEEN startval AND endval;
• D.SELECT custname, gradeFROM customers, gradesWHERE (SELECT
  MAX(cust_credit_limit)FROM customers) BETWEEN startval and endval;

Which two statements are true about WHERE and HAVING clauses? (Choose two)

• A.A WHERE clause can be used to restrict rows only.
• B.A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
• C.A HAVING clause can be used to restrict groups only.
• D.A WHERE clause can be used to restrict both rows and groups.
• E.A HAVING clause can be used to restrict both rows and groups.
• F.A HAVING clause CANNOT be used in sub queries.