1Z0-047 무료 덤프문제 온라인 액세스

Which statement is true regarding the SESSION_PRIVS dictionary view?

• A.It contains the object privileges granted to other users by the current user session.
• B.It contains the current system privileges available in the user session.
• C.It contains the system privileges granted to other users by the current user session.
• D.It contains the current object privileges available in the user session.

View the Exhibit and examine the structure of the ORDER_ITEMS table.
You need to display the ORDER_ID of the order that has the highest total value among all the
orders in the ORDER_ITEMS table.
Which query would produce the desired output?

• A.SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items)
  GROUP BY order_id;
• B.SELECT order_id
  FROM order_items
  GROUP BY order_id
  HAVING SUM(unit_price*quantity) =(SELECT MAX(SUM(unit_price*quantity))
  FROM order_items GROUP BY order_id);
• C.SELECT order_id
  FROM order_items
  WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items
  GROUP BY order_id);
• D.SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = MAX(unit_price*quantity)
  GROUP BY order_id;

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

• A.The nested query executes after the outer query returns the row.
• B.The nested query executes first and then the outer query executes.
• C.Each row returned by the outer query is evaluated for the results returned by the inner query.
• D.The outer query executes only once for the result returned by the inner query.

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.
You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:
SELECT p.product_name, i.item_cnt FROM (SELECT product_id, COUNT (*) item_cnt FROM order_items GROUP BY product_id) i RIGHT OUTER JOIN products p ON i.product_id = p.product_id; What would happen when the above statement is executed?

• A.The statement would not execute because inline views and outer joins cannot be used together.
• B.The statement would not execute because the GROUP BY clause cannot be used in the inline view.
• C.The statement would execute successfully to produce the required output.
• D.The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.

You need to create a table for a banking application with the following considerations:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and
subtracted with 3) date type data without using the conversion functions.
4) The maximum period of the credit provision in the application is 30 days.
5) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

• A.TIMESTAMP WITH LOCAL TIME ZONE
• B.INTERVAL YEAR TO MONTH
• C.TIMESTAMP WITH TIME ZONE
• D.INTERVAL DAY TO SECOND