View the Exhibit and examine the description of the ORDERS table. (Choose two.) Which two WHERE clause conditions demonstrate the correct usage of conversion functions?
View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.)
You must display product names from the PRODUCTS table that belong to the
'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:
SQL > SELECT prod_name, prod_category, prod_min_price FROM products
Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price
4000) AND prod_unit_of_measure <> ' ';
Which statement is true?
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table 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.)
Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.
Which set operator generates the required output?
Examine the structure of the BOOKS_TRANSACTIONStable.
You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:
Which condition must be used in the WHEREclause to perform the required update?
