web analytics

PassLeader 1Z0-061 Exam Dumps Collection with VCE and PDF (Question 37 – Question 40)

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 37
View the Exhibit and examine the structure of the promotions table. You need to generate a report of all promos from the promotions table based on the following conditions:
1. The promo name should not begin with ‘T’ or ‘N’.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which where clause would give the required result?
passleader-1Z0-061-dumps-371

Answer:
WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND
promo_cost > 20000 AND promo_end_date > ‘1-JAN-01’

QUESTION 38
Examine the structure of the employees table.
passleader-1Z0-061-dumps-381
You want to display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would get the correct output?
passleader-1Z0-061-dumps-382

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: BD
Explanation:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sql_subselectexamples.htm

QUESTION 39
Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required result?
passleader-1Z0-061-dumps-391

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: C
Explanation:
Duplicate Rows
Unless you indicate otherwise, SQL displays the results of a query without eliminating the duplicate rows. To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword. You can specify multiple columns after the DISTINCT qualifier. The DISTINCT qualifier affects all the selected columns, and the result is every distinct combination of the columns.

QUESTION 40
You issue the following command to drop the products table:
SQL> DROP TABLE products;
Which three statements are true about the implication of this command?

A.    All data along with the table structure is deleted.
B.    A pending transaction in the session is committed.
C.    All indexes on the table remain but they are invalidated.
D.    All views and synonyms remain but they are invalidated.
E.    All data in the table is deleted but the table structure remains.

Answer: ABD


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