Oracle 1Z0-071 Quiz 70 Topic 16 Questions 346-350

Question: 1

View the Exhibit and examine the description of the ORDERS table. (Choose two.)

q1_1Z0-071

Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

AWHERE Order_date_IN ( TO_DATE('OCT 21 2003', 'MON DD YYYY'), TO_CHAR('NOV 21 2003', 'MON DD YYYY') )

BWHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

CWHERE TO_CHAR(Order_date, 'MON DD YYYY') = 'JAN 20 2003'

DWHERE Order_date > ( TO_DATE('JUL 10 2006', 'MON DD YYYY')

Show Answer

Question: 2

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. (Choose all that apply.)

q2_1Z0-071

Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.

SELECT EMPLOYEE_ID

FROM EMPLOYEES

WHERE JOB_ID = 'SA_MAN'

-------------------------------------

SELECT EMPLOYEE_ID

FROM JOB_HISTORY

WHERE JOB_ID = 'SA_MAN';

Choose two correct SET operators which would cause the query to return the desired result.

AUNION

BMINUS

CINTERSECT

DUNION ALL

Show Answer

Question: 3

You must create a SALES table with these column specifications and data types: (Choose the best answer.)

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 create the table?

ACREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = 'CASH');

BCREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT 'SYSDATE',PAYMENT VARCHAR2(30) DEFAULT CASH);

CCREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID NUMBER (4),qty NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = 'CASH');

DCreate Table sales(salesid NUMBER (4),Storeid NUMBER (4),Itemid NUMBER (4),QTY NUMBER DEFAULT 1,Slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT 'CASH');

Show Answer

Question: 4

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

q4_1Z0-071

Evaluate this SQL statement:

SELECT TO_CHAR (list_price, '$9,999')

From product_information;

Which two statements are true regarding the output?

AA row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

BA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.

CA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.

DA row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.

Show Answer

Question: 5

Examine the structure of the ORDERS table: (Choose the best answer.)

q5_1Z0-071

You want to find the total value of all the orders for each year and issue this command:

SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders

GROUP BY TO_CHAR(order_date, 'yyyy');

Which statement is true regarding the result?

AIt executes successfully but does not give the correct output.

BIt executes successfully but gives the correct output.

CIt returns an error because the TO_CHAR function is not valid.

DIt return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

Show Answer

Oracle 1Z0-071 Quiz:70 Topic:16 Questions:346-350