teamwork Online Quiz - 2

Question 1 True/False

Sorted Input in aggregator transformation improves the session performance

True
False

Question 2 True/False

When we enable the dynamic lookup cache then the designer adds port "NewLookupRow"

True
False

Question 3 Multiple Choice (Single Answer)

what are the $,$$,$$$ symbols in informatica?

Session Parameter,mapping Parameter,System variable
System variable,Session Parameter,mapping Parameter
System variable,mapping Parameter,Session Parameter
None of above

Question 4 Multiple Choice (Single Answer)

what are the two modes of data movement in infomatica?

Normal,Large
Simple,Large
Normal,Bulk
none of above

Question 5 Multiple Choice (Multiple Answers)

what are the lookup caches?

Static Cache
Dynamic Cache
Persistant Cache
Shared Cache
All the Above

Question 6 Multiple Choice (Single Answer)

when the source is file where can we set the file properties.

session level
mapping level
worlflow level
none of the above

Question 7 True/False

we can call the stored procedure in ports like :SP.Identifier(arguments)

True
False

Question 8 Multiple Choice (Multiple Answers)

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? (Choose two.)

SUM(start_date)
AVG(start_date)
COUNT(start_date)
AVG(start_date, end_date)
MIN(start_date)
MAXIMUM(start_date)

Question 9 Multiple Choice (Single Answer)

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;
SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Question 10 Multiple Choice (Multiple Answers)

Which four are valid Oracle constraint types? (Choose four.)

CASCADE
UNIQUE
NONUNIQUE
CHECK
PRIMARY KEY
NOT NULL

Question 11 Multiple Choice (Single Answer)

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

DROP emp_dept_vu;
DELETE emp_dept_vu;
REMOVE emp_dept_vu;
DROP VIEW emp_dept_vu;
DELETE VIEW emp_dept_vu;
REMOVE VIEW emp_dept_vu;

Question 12 Multiple Choice (Single Answer)

Which is an iSQL*Plus command?

INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME

Question 13 Multiple Choice (Multiple Answers)

Which are DML statements? (Choose all that apply.)

COMMIT
MERGE
UPDATE
DELETE
CREATE
DROP

Question 14 Multiple Choice (Single Answer)

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

ALTER TABLE students ADD PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY
ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY

Question 15 Multiple Choice (Multiple Answers)

Which two statements complete a transaction? (Choose two.)

DELETE employees;
DESCRIBE employees;
ROLLBACK TO SAVEPOINT C;
GRANT SELECT ON employees TO SCOTT;
ALTER TABLE employeesSET UNUSED COLUMN sal;
SELECT MAX(sal) FROM employees WHERE department_id = 20;

teamwork Online Quiz - 2

Questions