[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-047 Dumps with VCE and PDF Download 131-140

Latesttests 2018 Jan Oracle Official New Released 1z0-047
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-047.html

Oracle Database SQL Expert

Question No: 131

Which statement correctly grants a system privilege?

  1. GRANT EXECUTE ON prod

    TO PUBLIC;

  2. GRANT CREATE VIEW ON tablel TO

    used;

  3. GRANT CREATE TABLE TO used ,user2;

  4. GRANT CREATE SESSION TO ALL;

Answer: C

Question No: 132

Given below is a list of functions and their purpose in random order.

Function Purpose

  1. NVL a) Used for evaluating NOT NULL and NULL values

  2. NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE

  • Used to compare two expressions. If both are same, it returns NULL; otherwise, it returns only the first expression.

  • 4)NVL2 d) Used to convert NULL values to actual values Identify the correct combination of functions and their usage. A. 1-a,2-c,3-b,4-d

    B. 1-d,2-c,3-b,4-a

    C. 1-b,2-c,3-d,4-a

    D. 1-d,2-b,3-c,4-a

    Answer: B

    Question No: 133

    The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE;

    Then you performed the FLASHBACK operation by using the following command: FLASHBACK TABLE products TO BEFORE DROP;

    Which statement describes the outcome of the FLASHBACK command?

    1. It recovers only the table structure.

    2. It recovers the table structure, data, and the indexes.

    3. It recovers the table structure and data but not the related indexes.

    4. It is not possible to recover the table structure, data, or the related indexes.

    Answer: D

    Question No: 134

    Evaluate the SQL statements:

    CREATE TABLE new_order (orderno NUMBER(4),

    booking_date TIMESTAMP WITH LOCAL TIME ZONE);

    The database is located in San Francisco where the time zone is -8:00. The user is located in New York where the time zone is -5:00.

    A New York user inserts the following record:

    INSERT INTO new_order

    VALUES(1, TIMESTAMP ?007-05-10 6:00:00 -5:00?);

    Which statement is true?

    1. When the New York user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000#39;

    2. When the New York user selects the row, booking_date is displayed as 2007-05-10 6.00.00.000000 -5:00#39;.

    3. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000#39;

    4. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000 -8:00#39;

    Answer: C

    Question No: 135

    View the Exhibit and examine the description of the PRODUCT_INFORMATION table.

    Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

    Latesttests 2018 PDF and VCE

    1. SELECT COUNT(list_price)

      FROM product_information WHERE list_price IS NULL;

    2. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;

    3. SELECT COUNT(NVL(list_price, 0)) FROM product_information

      WHERE list_price IS NULL;

    4. SELECT COUNT(DISTINCT list_price) FROM product_information

    WHERE list_price IS NULL;

    Answer: C

    Question No: 136

    View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables.

    You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each order.

    Latesttests 2018 PDF and VCE

    Which CREATE VIEW statement would create the view successfully?

    1. CREATE OR REPLACE VIEW ord_vu (order_id,order_date) AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) quot;NO OF ITEMSquot;

      FROM orders o JOIN order_items i ON (o.order_id = i.order_id)

      GROUP BY o.order_id,o.order_date;

    2. CREATE OR REPLACE VIEW ord_vu

      AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) quot;NO OF ITEMSquot;

      FROM orders o JOIN order_items i ON (o.order_id = i.order_id)

      GROUP BY o.order_id,o.order_date;

    3. CREATE OR REPLACE VIEW ord_vu

      AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) FROM orders o JOIN order_items i ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date;

    4. CREATE OR REPLACE VIEW ord_vu

    AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id)ll’ NO OF ITEMS#39; FROM orders o JOIN order_items i

    ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date WITH CHECK OPTION;

    Answer: B

    Question No: 137

    Which two statements are true regarding operators used with subqueries? (Choose two.

    1. The NOT IN operator is equivalent to IS NULL

    2. The lt;ANY operator means less than the maximum.

    C. =ANY and =ALL operators have the same functionality.

    1. The IN operator cannot be used in single-row subqueries.

    2. The NOT operator can be used with IN, ANY and ALL operators.

    Answer: B,E

    Question No: 138

    Given below is the list of meta character syntaxes and their descriptions in random order:

    Meta character syntax Description

    1. ^a) Matches character not in the list

    2. [^…] b) Matches character when it occurs at the beginning of a line 3) | c) Treats the subsequent meta character as a literal 4) \ d) Matches one of the characters such as the OR operator

    Identify the option that correctly matches the meta character syntaxes with their descriptions.

    A. 1-b, 2-a, 3-d.4-c

    B. 1-a, 2-b, 3-d.4-c

    C. 1-d, 2-b, 3-a.4-c

    D. 1-b, 2-c, 3-d, 2-a

    Answer: A

    Question No: 139

    View the Exhibit and examine the structure of the ORDER_ITEMS table. Examine the following SQL statement:

    SELECT order_id, product_id, unit_price FROM order_jtems

    WHERE unit_price = (SELECT MAX(unit_price) FROM order_items

    GROUP BY order_id);

    You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID.

    What correction should be made in the above SQL statement to achieve this?

    Latesttests 2018 PDF and VCE

    1. Replace = with the IN operator.

    2. Replace = with the gt;ANY operator.

    3. Replace = with the gt;ALL operator.

    4. Remove the GROUP BY clause from the subquery and place it in the main query.

    Answer: A

    Question No: 140

    Evaluate the following expression using meta character for regular expression: #39;[^Ale|ax.r$]#39;

    Which two matches would be returned by this expression? (Choose two.)

    1. Alex

    2. Alax

    3. Alxer

    4. Alaxendar

    5. Alexender

    Answer: D,E

    100% Free Download!
    Download Free Demo:1z0-047 Demo PDF
    100% Pass Guaranteed!
    Download 2018 Latesttests 1z0-047 Full Exam PDF and VCE

    Latesttests ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    2018 Latesttests IT Certification PDF and VCE