1Z0-082 Exam Question 81
Which two are true about Oracle recovery and data protection solutions? (Choose two.)
1Z0-082 Exam Question 82
Which two tasks can you perform using DBCA for databases? (Choose two.)
1Z0-082 Exam Question 83
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?
1Z0-082 Exam Question 84
You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)
1Z0-082 Exam Question 85
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
The variables used in your query are never undefined in your session.
Which query can be used?