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 4814

See the exhibit and examine the structure of the CUSTOMERS and GRADES tables:
Exhibit:
 
You need to display names and grades of customers who have the highest credit limit.
 
Which two SQL statements would accomplish the task? (Choose two.)

Option A

A.    SELECT custname, grade
FROM customers, grades
WHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)
FROM customers)
AND MAX(cust_credit_limit) BETWEEN startval AND endval;
 

Option B

B.    SELECT custname, grade
FROM customers, grades
WHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)
FROM customers)
AND cust_credit_limit BETWEEN startval AND endval;
 

Option C

C.    SELECT custname, grade
FROM customers, grades
0WHERE (SELECT MAX(cust_credit_limit)
FROM customers) BETWEEN startval and endval
AND cust_credit_limit BETWEEN startval AND endval;
 

Option D

D.    SELECT custname, grade
FROM customers, grades
WHERE (SELECT MAX(cust_credit_limit)
FROM customers) BETWEEN startval and endval;
 

Correct Answer B,C
Explanation


Question ID 4815

Evaluate the following SQL statements:
Exhibit:
 
You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization.
 
Exhibit:
 
Which two statements are true regarding the above view? (Choose two.)

Option A

A.    It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table
 

Option B

B.    It allows you to delete details of the existing sales staff from the EMPLOYEES table
 

Option C

C.    It allows you to insert rows into the EMPLOYEES table
 

Option D

D.    It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements
 

Correct Answer B,D
Explanation

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