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- 1z0-061





Question ID 2289

Examine the structure and data of the CUST_TRANS table:
 
Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully?

Option A

A.    SELECT transdate + '10' FROM cust_trans;
 

Option B

B.    SELECT * FROM cust_trans WHERE transdate = '01-01-07';
 

Option C

C.    SELECT transamt FROM cust_trans WHERE custno > "11";
 

Option D

D.    SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

 

Option E

E.    SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

Correct Answer A,C,D
Explanation


Question ID 2290

View the Exhibit and examine the structure of the customers table.
 
 
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the customers table.
Evaluate the following insert statement:
 
The insert statement fails when executed. What could be the reason?

Option A

A.    The values clause cannot be used in an INSERT with a subquery.
 

Option B

B.    Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
 

Option C

C.    The where clause cannot be used in a subquery embedded in an INSERT statement.
 

Option D

D.    The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
 

Correct Answer A
Explanation

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