1Z1-051 무료 덤프문제 온라인 액세스

View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required output? (Choose two.)

• A.SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products;
• 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;

Evaluate the following SQL statement:
SQL> SELECT cust_id. cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit FROM customers WHERE cust_city='Singapore'):
Which statement is true regarding the above query if one of the values generated by the sub query is NULL?

• A.It executes but returns no rows.
• B.It generates output for NULL as well as the other values produced by the sub query.
• C.It ignores the NULL value and generates output for the other values produced by the sub query.
• D.It produces an error.

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

You want to create a SALE_PROD view by executing the following SQL statements:

Which statement is true regarding the execution of the above statement?

• A.The view will be created but no DML operations will be allowed on the view
• B.The view will not be created because the GROUP BY clause is not allowed for creating a view
• C.The view will not be created because the join statements are not allowed for creating a view
• D.The view will be created and you can perform DLM operations on the view

See the Exhibit and examine the structure of the CUSTOMERS table:

Using the CUSTOMERS table, you need to generate a report that shown the average credit limit for customers in WASHINGTON and NEW YORK.
Which SQL statement would produce the required result?

• A.SELECT cust_city, AVG(cust_credit_limit)
  FROM customers
  WHERE cust_city IN ('WASHINGTON','NEW YORK')
  GROUP BY cust_city;
• B.SELECT cust_city, AVG(cust_credit_limit)
  FROM customers
  WHERE cust_city IN ('WASHINGTON','NEW YORK')
  GROUP BY cust_city,cust_credit_limit;
• C.SELECT cust_city, AVG(cust_credit_limit)
  FROM customers
  WHERE cust_city IN ('WASHINGTON','NEW YORK')
  GROUP BY cust_credit_limit, cust_city;
• D.SELECT cust_city, AVG(NVL(cust_credit_limit,0))
  FROM customers
  WHERE cust_city IN ('WASHINGTON','NEW YORK');

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

You issue the following SQL statement:

Which statement is true regarding the execution of the above query?

• A.It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.
• B.It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
• C.It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
• D.It produces an error because the AMT_SPENT column contains a null value.