NR0-013 Teradata SQL v2r5
Note 1: NR0-013 Exhibit and all related diagrams are not shown in demo questions.
Note 2: NR0-013 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Note 2: NR0-013 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 7.
CREATE MACRO dept_budget (deptno INT, budgamt DEC(10,2))AS (MERGE INTO department USING (SELECT :deptno, dept_name, :budgamt FROM dept_name_assignment WHERE department_number = :deptno) AS Dept(deptnum, deptname, budget) ON Dept.deptnum = department.department_number WHEN MATCHED THEN UPDATE SET budget_amount = Dept.budget, department_name = Dept.deptname WHEN NOT MATCHED THEN INSERT VALUES (Dept.dptnum, Dept.deptname, Dept.budget, NULL);); Which four of the following statements are true regarding the execution the following macro? (Choose four.)
A. The primary index of the target table must be unique.
B. The AS clause within the macro specifies the name of the source table.
C. The USING subquery may return at most a single row.
D. The ON clause must contain the primary index of the target table.
E. If zero rows are returned by the subquery, neither the update nor the insert occurs.
Display Answer
- Based on the latest NR0-013 exam objectives!
- Designed like actual NR0-013 exam questions!
- 100% Verified Realistic NR0-013 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation NR0-013 Questions Included!
- Constantly Updated Guide to Reflect the Current NR0-013 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
Demark
Took my last CCNP test last Friday. EliteCertify tests really made the difference, I passed every one on the first ...
NY, USA
I wanted to take a few minutes to thank EliteCertify for passing 3 exams towards my MCSE. ...
Australia
Great thanks to EliteCertify for such excellent products! It really helped me a lot for passing 3Com 3M0-212. The practice ...
Keyword
