Analyze the description of the ORDERS table in the sample below: 

Which from the following WHER Eclause conditions demonstrate the correct usage of conversion functions? (Select two.)

Which from the following arithmetic operations can be performed on a column by using a SQL function which is built into Oracle database? (Select three.)

In the Sample below, analyze the structure of the EMPLOYEES and JOB_HISTORY tables. The following query must select the employee IDs of all those who have held, at any time of their employment, the job SA_MAN. 

►SELECT EMPLOYEE_ID FROM EMPLOYEES WHERE JOB_ID = 'SA_MAN' 

►SELECT EMPLOYEE_ID FROM JOB_HISTORY WHERE JOB_ID = 'SA_MAN'; 

Choose the correct SET operators which would return the query’s desired result. (Select two.)

In order to create a SALES table with the following specifications for column and data types: 

SALESID: Number STOREID: Number ITEMID: 

Number QTY: Number, should be set to 1 when no value is specified 

SLSDATE: Date, should be set to current date when no value is specified 

PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified 

Which statement would you select to create it? (Choose the best option.)

In the Sample below, analyze the details of the PRODUCT_INFORMATION table. 

Analyze the following SQL statement: 

> SELECT TO_CHAR (list_price, '$9,999') From product_information; 

Which from the following statements are true in regards of the output? (Select two.)

Analyze the structure of the following ORDERS table: 

You issue the following command in order to find the total value of all the orders for each year: 

> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders GROUP BY TO_CHAR(order_date, 'yyyy'); 

Which statement is true in regards of the result? (Select the best option.)

Analyze the structure of the ORDER_ITEMS table in the Exhibit below. 

From the orders in the ORDER_ITEMS table, you have to select the ORDER_ID of the one with the highest total value among all. 

Which from the following queries would give the expected result?

Which of the following statements are true regardining the performance of Data Manipulation Language (DML) operations on a view in an Oracle Database? (Select three.)