teamwork Online Quiz - 2 Online Test

Back

teamwork Online Quiz - 2

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

Start the Quiz

Sorted Input in aggregator transformation improves the session performance

softskills teamwork

True
False

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

softskills teamwork

True
False

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

what are the two modes of data movement in infomatica?

softskills teamwork

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

what are the lookup caches?

softskills teamwork

Static Cache
Dynamic Cache
Persistant Cache
Shared Cache
All the Above

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

softskills teamwork

session level
mapping level
worlflow level
none of the above

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

softskills teamwork

True
False

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)

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;

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

softskills teamwork

CASCADE
UNIQUE
NONUNIQUE
CHECK
PRIMARY KEY
NOT NULL

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;

Which is an iSQL*Plus command?

softskills teamwork

INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME

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

softskills teamwork

COMMIT
MERGE
UPDATE
DELETE
CREATE
DROP

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

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;

- Hide questions

teamwork Online Quiz - 2

AI Explanation

AI Explanation

Find more quizzes from top tags