• teamwork Online Quiz - 2
Back
0

teamwork Online Quiz - 2

Description: teamwork Online Quiz - 2
Number of Questions: 15
Created by:
Tags: teamwork
Start the Quiz
Attempted 0/15 Correct 0 Score 0
‹
›

Sorted Input in aggregator transformation improves the session performance

softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. Session Parameter,mapping Parameter,System variable

  2. System variable,Session Parameter,mapping Parameter

  3. System variable,mapping Parameter,Session Parameter

  4. None of above

Show answer
Correct Option: A

what are the two modes of data movement in infomatica?
softskills teamwork

  1. Normal,Large

  2. Simple,Large

  3. Normal,Bulk

  4. none of above

Show answer
Correct Option: C

what are the lookup caches?
softskills teamwork

  1. Static Cache

  2. Dynamic Cache

  3. Persistant Cache

  4. Shared Cache

  5. All the Above

Show answer
Correct Option: E

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

  1. session level

  2. mapping level

  3. worlflow level

  4. none of the above

Show answer
Correct Option: A

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

softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

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

  1. SUM(start_date)

  2. AVG(start_date)

  3. COUNT(start_date)

  4. AVG(start_date, end_date)

  5. MIN(start_date)

  6. MAXIMUM(start_date)

Show answer
Correct Option: C,E

AI Explanation

To answer this question, let's go through each option to determine which aggregate functions are valid on the START_DATE column:

Option A) SUM(start_date) - The SUM function is used to calculate the sum of numerical values. However, the START_DATE column is of type DATE, not a numerical value. Therefore, this option is incorrect.

Option B) AVG(start_date) - The AVG function is used to calculate the average of numerical values. Since the START_DATE column is of type DATE, this option is incorrect.

Option C) COUNT(start_date) - The COUNT function is used to count the number of rows or non-null values in a column. This function is valid for the START_DATE column since it counts the number of occurrences of the column values. Therefore, this option is correct.

Option D) AVG(start_date, end_date) - The AVG function calculates the average of numerical values. However, in this option, there are two columns provided (START_DATE and END_DATE), which is not valid for the AVG function. Therefore, this option is incorrect.

Option E) MIN(start_date) - The MIN function is used to find the minimum value in a column. Since the START_DATE column is of type DATE, this option is valid.

Option F) MAXIMUM(start_date) - The MAXIMUM function is not a valid aggregate function in SQL. Therefore, this option is incorrect.

The correct answers are C) COUNT(start_date) and E) MIN(start_date) because both functions are valid for the START_DATE column.

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

softskills teamwork

  1. SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

  2. SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

  3. SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

  4. SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

  5. SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Show answer
Correct Option: C

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

softskills teamwork

  1. CASCADE

  2. UNIQUE

  3. NONUNIQUE

  4. CHECK

  5. PRIMARY KEY

  6. NOT NULL

Show answer
Correct Option: B,D,E,F

AI Explanation

To answer this question, you need to understand the concept of Oracle constraints. Oracle provides various types of constraints to enforce rules on the data stored in a table.

Let's go through each option to understand why it is correct or incorrect:

Option A) CASCADE - This option is incorrect because CASCADE is not a valid Oracle constraint type. CASCADE is used with foreign key constraints to define the action to be taken when a referenced row is deleted or updated.

Option B) UNIQUE - This option is correct. UNIQUE is a valid Oracle constraint type that ensures that all values in a column or set of columns are unique.

Option C) NONUNIQUE - This option is incorrect because NONUNIQUE is not a valid Oracle constraint type. The opposite of UNIQUE constraint is actually the default behavior, where duplicate values are allowed.

Option D) CHECK - This option is correct. CHECK is a valid Oracle constraint type that allows you to specify a condition that must be satisfied for the data in a column.

Option E) PRIMARY KEY - This option is correct. PRIMARY KEY is a valid Oracle constraint type that uniquely identifies each row in a table.

Option F) NOT NULL - This option is correct. NOT NULL is a valid Oracle constraint type that ensures that a column cannot contain any NULL values.

The correct answer is B, D, E, F. These options are correct because they represent valid Oracle constraint types.

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

softskills teamwork

  1. DROP emp_dept_vu;

  2. DELETE emp_dept_vu;

  3. REMOVE emp_dept_vu;

  4. DROP VIEW emp_dept_vu;

  5. DELETE VIEW emp_dept_vu;

  6. REMOVE VIEW emp_dept_vu;

Show answer
Correct Option: D

Which is an iSQL*Plus command?

softskills teamwork

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME

Show answer
Correct Option: D

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

softskills teamwork

  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP

Show answer
Correct Option: B,C,D

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

  1. ALTER TABLE students ADD PRIMARY KEY student_id;

  2. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

  3. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

  4. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY

  5. ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY

Show answer
Correct Option: D

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

softskills teamwork

  1. DELETE employees;

  2. DESCRIBE employees;

  3. ROLLBACK TO SAVEPOINT C;

  4. GRANT SELECT ON employees TO SCOTT;

  5. ALTER TABLE employeesSET UNUSED COLUMN sal;

  6. SELECT MAX(sal) FROM employees WHERE department_id = 20;

Show answer
Correct Option: D,E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions