AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4741

Evaluate the following SQL statements:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table. Which statement is true about the DELETE statement?
 

Option A

A.    It removes all the rows as well as the structure of the table
 

Option B

B.    It removes all the rows in the table and deleted rows cannot be rolled back
 

Option C

C.    It removes all the rows in the table and deleted rows can be rolled back
 

Option D

D.    It would not remove the rows if the table has a primary key
 

Correct Answer C
Explanation


Question ID 4742

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit 1:
 
 
Exhibit 2:
 
Exhibit 3:
 
Examine the structures of the PRODUCTS, SALES AND CUSTOMERS table.
You need to generate a report that gives details of the customer's last name, name of the product and the quantity sold for all customers in 'Tokyo'.
Which two queries give the required result? (Choose two.)
 

Option A

A.    SELECT c.cust_last_name,p.prod_name,s.quantity_sold
FROM sales s JOIN products p
USING (prod_id)
JOIN customers c
USING (cust_id)
WHERE c.cust_city='Tokyo';
 

Option B

B SELECT c.cust_last_name,p.prod_name,s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';
 

Option C

B.    SELECT c.cust_last_name,p.prod_name,s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';

 

Option D

C.    SELECT c.cust_last_name,p.prod_name,s.quantity_sold
FROM products p JOIN sales s
USING (prod_id)
ON(p.prod_id=s.prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

Correct Answer A,C
Explanation

Send email to admin@getfreedumps for new dumps request!!!