PassLeader now are offering 100% pass ensure 1Z0-061 dumps! All 1Z0-061 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-061 VCE dumps and PDF dumps: http://www.passleader.com/1z0-061.html (322 Q&As)
BTW: Download PassLeader 1Z0-061 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA
QUESTION 13
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?
A. SELECT transdate + ’10’ FROM cust_trans;
B. SELECT * FROM cust_trans WHERE transdate = ’01-01-07′;
C. SELECT transamt FROM cust_trans WHERE custno > “11”;
D. SELECT * FROM cust_trans WHERE transdate=’01-JANUARY-07′;
E. SELECT custno + ‘A’ FROM cust_trans WHERE transamt > 2000;
Answer: ACD
QUESTION 14
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?
A. The values clause cannot be used in an INSERT with a subquery.
B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C. The where clause cannot be used in a subquery embedded in an INSERT statement.
D. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
Answer: A
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.
QUESTION 15
YOU need to display the date ll-oct-2007 in words as `Eleventh of October, Two Thousand Seven’. Which SQL statement would give the required result?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
QUESTION 16
Examine the data in the ORD_ITEMS table:
Evaluate the following query:
Which statement is true regarding the outcome of the above query?
A. It gives an error because the having clause should be specified after the group by clause.
B. It gives an error because all the aggregate functions used in the having clause must be specified in the select list.
C. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
D. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.
Answer: C
PassLeader now are offering 100% pass ensure 1Z0-061 dumps! All 1Z0-061 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-061 VCE dumps and PDF dumps: http://www.passleader.com/1z0-061.html (322 Q&As)
BTW: Download PassLeader 1Z0-061 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA