Online Access Free Oracle.1z0-071.v2021-11-28.q233 Practice Test (Page 15)

1z0-071 Exam Question 66

Which two statements will convert the string Hello world to ello wozid?

A.SELECT LOWER (SUBSTR('Hello World, 2, 1)) FROM DUAL;

B.SELECT SUBSTR('Hello world', 2) FROM DUAL;

C.SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;

D.SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;

E.SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;

1z0-071 Exam Question 67

View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following 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 statements are true regarding the output of these SQL statements? (Choose all that apply.)

A.Statement 1 would not return give the same output.

B.Both the statements would give the same output.

C.Statement 2 would return multiple rows of output.

D.Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.

E.Statement 1 would return only one row of output.

1z0-071 Exam Question 68

Which two statements are true about Entity Relationships?

A.A table name can be specified just once when selecting data from a table having a selfreferencing relationship

B.A one-to-many relatonship in one direction is a one-to-one relationship in the other direction

C.A one-to-one relationship is always a self-referencing relationship

D.A Relationship can be mandatory for both entities

E.A many-to-many relationship can be implemented only by using foreign keys

1z0-071 Exam Question 69

Which two queries only return CUBE?

A.SELECT shape FROM bricks JOIN boxes ON weight < max_weight;

B.SELECT shape FROM bricks JOIN boxes ON weight > min_weight;

C.SELECT shape FROM bricks JOIN boxes ON NOT (weight > max_weight);

D.SELECT shape FROM bricks JOIN boxes ON weight BETWEEN min_weight AND max_weight;

E.SELECT shape FROM bricks JOIN boxes ON weight >= min_weight AND weight < max_weight;

1z0-071 Exam Question 70

View the Exhibit and examine the details of the ORDER_ITEMS table.

A.Statement 1 would return only one row of output.