Oracle marks4sure oracle Pl 1z0-071 Book by Angelina q95 vce pdf

Page: 16 / 24

Exam Name:	Oracle Database 12c SQL
Exam Code:	1z0-071 Dumps
Vendor:	Oracle	Certification:	Oracle PL
Questions:	324 Q&A's	Shared By:	angelina

Question 64

Examine this SQL statement:

SELECT cust_id, cust_last_name "Last Name

FROM customers

WHERE countryid=10

UNION

SELECT custid CUSTNO, cust_last_name

FROM customers

WHERE countryid=30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

Options:

ORDER BY“CUST NO"

ORDER BY 2, cust_id

ORDERBY2, 1

ORDER BY "Last Name"

ORDER BY CUSTNO

Discussion

Question 65

You create a table by using this command:

CREATE TABLE rate_list (rate NUMBER(6,2));

Which two are true about executing statements?

Options:

INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

INSERT INTO rate_list VALUES (0.999) produces an error.

INSERT INTO rate_list VALUES (-10) produces an error.

INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

Discussion

Question 66

Which three are true?

Options:

LAST_DAY returns the date of the last day of the current ,month onlyu.

CEIL requires an argument which is a numeric data type.

ADD_MONTHS adds a number of calendar months to a date.

ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

LAST_DAY return the date of the last day the previous month only.

CEIL returns the largest integer less than or equal to a specified number.

LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

Discussion

Robin

Cramkey is highly recommended.

Jonah (not set)

Definitely. If you're looking for a reliable and effective study resource, look no further than Cramkey Dumps. They're simply wonderful!

Reeva

Wow what a success I achieved today. Thank you so much Cramkey for amazing Dumps. All students must try it.

Amari (not set)

Wow, that's impressive. I'll definitely keep Cramkey in mind for my next exam.

Nell

Are these dumps reliable?

Ernie (not set)

Yes, very much so. Cramkey Dumps are created by experienced and certified professionals who have gone through the exams themselves. They understand the importance of providing accurate and relevant information to help you succeed.

Erik

Hey, I have passed my exam using Cramkey Dumps?

Freyja (not set)

Really, what are they? All come in your pool? Please give me more details, I am going to have access their subscription. Please brother, give me more details.

Question 67

Which two statements are true about INTERVAL data types

Options:

INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

INTERVAL DAY TO SECOND columns support fractions of seconds.

INTERVAL YEAR TO MONTH columns support yearly intervals.