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 21018

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

SELECT transdate + '10' FROM cust_trans;

Option B

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

Option C

SELECT transamt FROM cust_trans WHERE custno > "11";

Option D

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

Option E

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

Correct Answer A,C,D
Explanation


Question ID 21019

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

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

Option B

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

Option C

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

Option 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 Explanation: Copying Rows from Another Table Write your INSERT statement with a subquery: Do not use the VALUES clause. Match the number of columns in the INSERT clause to those in the subquery. Inserts all the rows returned by the subquery in the table, sales_reps.

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