Which three delete statements are valid?

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 of everyday low prices as values.
Which three delete statements are valid?

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 of everyday low prices as values.
Which three delete statements are valid?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:

Show Hint

Leave a Reply 13

Your email address will not be published. Required fields are marked *

tsomie

tsomie

hi guys anyone with a valid oracle izo-61 valid pdf dump to kindly help me on my email addres is: [email protected] doing my exam next mandown please help

Reply

Sayed

Sayed

Did you do the test?

Reply

Sayed

Sayed

B, C, D are correct. Tested.

Reply

Bulat

Bulat

Hi everybody,
if anybody has valid 1Z0-061 dump – if you have it -could you send it to
[email protected] by email?

With regards!

Reply

Amit

Amit

Hi Guys,

I’m doing preparation for Oracle Database 12c: sql fundamentals, so i have need some dump copies for it. if you guys have any idea about Oracle Databse 12c: sql fundamentals then please send me at [email protected] ..

Thanks,
Amit

Reply

sandeep prasad

sandeep prasad

I’m doing preparation for Oracle Database 12c: sql fundamentals, so i have need some dump copies for it. if you guys have any idea about Oracle Databse 12c: sql fundamentals then please send me at at [email protected]

thanks

Reply

Oualid

Oualid

I will send u something tonight.

Reply

Oualid

Oualid

For B query, what if there are two different promo_id with the same promo_name

exp:
Table promotions:
promo_id: promo_name:
1234 blowout sale
1789 blowout sale

This subquery, in the B query will return two rows:
SELECT promo_id
FROM promotions
WHERE promo_name = ‘blowout sale’

there will be an error because the operator used to compare promo_id column and the subquery results is ‘=’

So the answer B is false.

Anyone agree with me ?

Reply

shivani Aggarwal

shivani Aggarwal

I’m doing preparation for Oracle Database 12c: sql fundamentals, so i have need some dump copies for it..Please mail me @[email protected]

Reply