You need to generate a report in the following format CATEGORIES 5MP Digital

You need to generate a report in the following format

This preview shows page 9 - 13 out of 59 pages.

You need to generate a report in the following format: CATEGORIES --------------------------------------------- 5MP Digital Photo Camera's category is Photo
Background image
Exam Name: Oracle Database: SQL Fundamentals Exam Type: Oracle Exam Code: 1Z0-051 Total Questions 114 Page 10 of 59 Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required output? (Choose two.) Question: 22 The PART_CODE column in the SPARES table contains the following list of values: PART_CODE ----------------- A%_WQ123 A%BWQ123 AB_WQ123 Evaluate the following query: SQL> SELECT part_code FROM spares WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\'; Which statement is true regarding the outcome of the above query? Question: 23 When does a transaction complete? (Choose all that apply.)
Background image
Exam Name: Oracle Database: SQL Fundamentals Exam Type: Oracle Exam Code: 1Z0-051 Total Questions 114 Page 11 of 59 E. when a TRUNCATE statement is executed after the pending transaction Answer: B, D, E Question: 24 Which two statements are true regarding single row functions? (Choose two.) A. They accept only a single argument. B. They can be nested only to two levels. C. Arguments can only be column values or constants. D. They always return a single result row for every row of a queried table. E. They can return a data type value different from the one that is referenced. Answer: D, E Question: 25 View the Exhibit to examine the description for the SALES and PRODUCTS tables. You want to create a SALE_PROD view by executing the following SQL statement: CREATE VIEW sale_prod AS SELECT p.prod_id, cust_id, SUM(quantity_sold) "Quantity", SUM(prod_list_price) "Price" FROM products p, sales s WHERE p.prod_id=s.prod_id GROUP BY p.prod_id, cust_id; Which statement is true regarding the execution of the above statement?
Background image
Exam Name: Oracle Database: SQL Fundamentals Exam Type: Oracle Exam Code: 1Z0-051 Total Questions 114 Page 12 of 59
Background image
Image of page 13

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture