Question 1

Sorted Input in aggregator transformation improves the session performance

softskills teamwork

True
False

Answer

Correct Option: A

Question 2

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

softskills teamwork

True
False

Answer

Correct Option: A

Question 3

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

softskills teamwork

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

Answer

Correct Option: A

Question 4

what are the two modes of data movement in infomatica?

softskills teamwork

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

Answer

Correct Option: C

Question 5

what are the lookup caches?

softskills teamwork

Static Cache
Dynamic Cache
Persistant Cache
Shared Cache
All the Above

Answer

Correct Option: E

Question 6

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

softskills teamwork

session level
mapping level
worlflow level
none of the above

Answer

Correct Option: A

Question 7

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

softskills teamwork

True
False

Answer

Correct Option: A

Question 8

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.)

softskills teamwork

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

Answer

Correct Option: C,E

Question 9

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

softskills teamwork

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;

Answer

Correct Option: C

Question 10

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

softskills teamwork

CASCADE
UNIQUE
NONUNIQUE
CHECK
PRIMARY KEY
NOT NULL

Answer

Correct Option: B,D,E,F

Question 11

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

softskills teamwork

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;

Answer

Correct Option: D

Question 12

Which is an iSQL*Plus command?

softskills teamwork

INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME

Answer

Correct Option: D

Question 13

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

softskills teamwork

COMMIT
MERGE
UPDATE
DELETE
CREATE
DROP

Answer

Correct Option: B,C,D

Question 14

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?

softskills teamwork

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

Answer

Correct Option: D

Question 15

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

softskills teamwork

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;

Answer

Correct Option: D,E

Description: teamwork Online Quiz - 2
Number of Questions: 15
Created by: Aliensbrain Bot
Tags: teamwork

teamwork Online Quiz - 2

AI Explanation

Find more quizzes from top tags