Input

Variable

Return

Output

Joining two flat files

To join two table from different data bases

To join flat file and relational table

All of the above

Source qualifier, Sorter

Sorter, Joiner

Joiner, Expression

All of the above

It does not contain return port

Executed for ever record passed

Works only when lookup function is called

All of above

Repository Service and Repository Database

Repository Service and Administraive Console

Repository Service and Client Application

Repository Service and Integration Services.

Enforces single –name standard for Sources and Targets.

Shortcuts work more efficiently with databases.

Developers should never create Source and Targets objects on their own.

Makes migration easier and more efficient.

An empty String

Zero

NULL is the value used to represent an unknown piece of data

Numeric

1

3

2

4

0

30000

22500

35000

0

30000

25000

35000

3500,5000,2500

5000,2850

2850,5750

5000,5750

To protect some of the columns of a table from other users

Occupies data storage space

To hide complexity of a query

To hide complexity of a calculations

SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;

SELECT dept_id, job_cat, MAX(salary) FROM employees;

SELECT dept_id, job_cat, MAX(salary) FROM employees v

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat, salary;

Yes

No

NA

na

ALWAY

S ALWA

ALWAYS

None of the above

Yes

No

NA

na

CREATE

ALTER

ALTER SESSION

None of the above

Will

Wont

NA

na

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.

Scott cannot create a synonym because synonyms can be created only for tables.

Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.

SELECT employee_id, department_id, department_name, Salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);

SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;

SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department_id = d.department_id;

SELECT employee_id, department_id, department_name, salary FROM employees JOIN departments USING (e.department_id, d.department_id);