Oracle certshero free Access 1z0-071 New Release by Shay q254 vce pdf

Page: 12 / 24

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

Question 48

Examine this description of the PRODUCTS table:

You successfully execute this command:

CREATE TALE new_prices(prod_id NUBER(2),price NUMBER(8,2));

Which two statements execute without errors?

Options:

MERGE INTO new_prices n

USING(SELECT*FROM products)p

WHEN MATECHED THEN

UPDATE SET n.price=p.cost*.01

WHEN NOT MATCHED THEN

INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)

WHERE(p.cost<200);

MERGE INTO new_prices n

USING(SELECT*FROM product WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

DELETE WHERE(p.cost<200)

WHEN NOT MATCHED THEN

INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

MERGE INTO new_prices n

USING (SELECT * FROM products WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

UPDATE SET n.price=p.cost*.01

DELETE WHERE (p.cost<200);

MERGE INTO new_prices n

USING products p

WHEN NOT NATCHED THEN

INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)

WHERE (p.cost <200);

Discussion

Question 49

Which three statements are true about views in an Oracle database?

Options:

The WITH CHECK clause prevents certain rows from being displayed when querying the view.

The WITH CHECK clause prevents certain rows from being updated or inserted.

Tables in the defining query of a view must always exist in order to create the view.

Date Manipulation Language (DML) can always be used on views.

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

Views can be updated without the need to re-grant privileges on the view.

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

Discussion

Question 50

Which statement will return the last sequence number generated by the EMP_ SEQ sequence?

Options:

SELECT NEXTVAL FROM emp_ seq;

SELECT CURRVAL FROM emp_ seq;

SELECT emp_ seq. CURRVAL FROM DUAL;

SELECT emp_ seq . NEXTVAL FROM DUAL;

Discussion

Question 51

Examine these statements which execute successfully:

ALTER SESSION SET NLS_DATE_FORMAT = ‘DD-MON-YYYY HH24 MI: SS’

ALTER SESSION SET TIME_ ZONE = ‘-5:00’;

SELECT DBTIMEZONE, SYSDATE FROM DUAL

Examine the result:

Questions 51

If LOCALTIMESTAMP was selected at the same time what would it return?

Options:

11-JUL-2019 6,00,00,00000000 AM – 05:00

11-JUL-2019 11,00,00,00000000 AM

11-JUL-2019 6,00,00,000000 AM

11-JUL-2019 11,00,00,000000AM -05:00

Discussion

Osian

Dumps are fantastic! I recently passed my certification exam using these dumps and I must say, they are 100% valid.

Azaan (not set)

They are incredibly accurate and valid. I felt confident going into my exam because the dumps covered all the important topics and the questions were very similar to what I saw on the actual exam. The team of experts behind Cramkey Dumps make sure the information is relevant and up-to-date.

Cody

I used Cramkey Dumps to prepare and a lot of the questions on the exam were exactly what I found in their study materials.

Eric (not set)

Really? That's great to hear! I used Cramkey Dumps too and I had the same experience. The questions were almost identical.

Marley

Hey, I heard the good news. I passed the certification exam!

Jaxson (not set)

Yes, I passed too! And I have to say, I couldn't have done it without Cramkey Dumps.

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.