Free Oracle 1Z0-071 Exam Questions

Become Oracle Certified with updated 1Z0-071 exam questions and correct answers

Page: 1 / 109

Total 544 Questions | Updated On: Jan 08, 2025

Add To Cart

Question 1

View the Exhibit and examine the structure of the BOOKS table.

The BOOKS table contains details of 100 books.

Examine the commands executed and their outcome:

Which statement is true?

A : th ROLLBACK commands restore the 101 rows that were deleted.

B : th ROLLBACK commands restore the 100 rows that were deleted.

C : first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.

D : first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.

Answer: C

Question 2

Which two statements are true about a full outer join?

A : includes rows that are returned by an inner join

B : returns only unmatched rows from both tables being joined.

C : includes rows that are returned by a Cartesian product.

D : returns matched and unmatched rows from both tables being joined

E : Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.

Answer: A,D

Question 3

In your session NLS_ DATE_ FORMAT is set to DD--MON_RR.

Which two queries display the year as four digits?

A : LECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

B : LECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

C : LECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

D : LECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

E : LECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

F : LECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

Answer: A

Question 4

View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the

PROMOTIONS table has either blowout sale or everyday low price as values.

Which three DELETE statements are valid? (Choose three.)

A : LETEFROM salesWHERE promo_id = (SELECT promo_idFROM promo_name = ‘blowout sale’)AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’)FROM promotionsWHERE promo_name = ‘everyday low price’);

B : LETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’)

C : LETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)OR promo_name = ‘everyday low price’);

D : LETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN = ‘blowout sale’,‘everyday low price’));

Answer: B,C,D

Question 5

The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR

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

A : ERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')

B : ERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';

C : ERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');

D : ERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21 2018','MON DD YYYY'))

E : ERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');

Answer: B,C

Page: 1 / 109

Total 544 Questions | Updated On: Jan 08, 2025

Add To Cart