Question 41
A session's NLS_DATE_FORMAT is set to DD Mon YYYY .
Which two queries return the value 1 Jan 2019?
Which two queries return the value 1 Jan 2019?
Question 42
Which two statements are true about CURRENT_TIMEITAMP?
Question 43
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?
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?
Question 44
View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.) Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output?
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output?
Question 45
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEEStable in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)