• databases Online Quiz - 56
Back
0

databases Online Quiz - 56

Description: databases Online Quiz - 56
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following port is used only in unconnected look up not in connected look up?

technology databases

  1. Input

  2. Variable

  3. Return

  4. Output

Show answer
Correct Option: C

We can use the joiner in case of?

technology databases

  1. Joining two flat files

  2. To join two table from different data bases

  3. To join flat file and relational table

  4. All of the above

Show answer
Correct Option: D

In which of the transformation we can discard duplicate data?

technology databases

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above

Show answer
Correct Option: A

Which is not true regarding unconnected lookup?

technology databases

  1. It does not contain return port

  2. Executed for ever record passed

  3. Works only when lookup function is called

  4. All of above

Show answer
Correct Option: C

AI Explanation

To answer this question, we need to understand the concept of an unconnected lookup.

An unconnected lookup is a type of lookup transformation in Informatica PowerCenter that is not directly connected to a source or target. It is used to perform lookups on a small set of data or to perform complex lookups that cannot be achieved using connected lookups.

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

Option A) It does not contain a return port - This option is incorrect. An unconnected lookup does contain a return port. The return port is used to return the result of the lookup operation to the calling transformation or expression.

Option B) Executed for every record passed - This option is incorrect. An unconnected lookup is executed for each record passed to it. It performs a lookup operation for each input record individually.

Option C) Works only when the lookup function is called - This option is correct. An unconnected lookup is not automatically triggered like a connected lookup. It needs to be explicitly called using the LKP expression or LKP transformation in Informatica PowerCenter.

Option D) All of the above - This option is incorrect. Option C is the correct answer, so not all of the options are true.

The correct answer is C) Works only when the lookup function is called. This option is correct because an unconnected lookup is not automatically triggered and needs to be explicitly called using the LKP expression or LKP transformation.

Therefore, the correct answer is C)

What does a power center domain require,at a minimum?

technology databases

  1. Repository Service and Repository Database

  2. Repository Service and Administraive Console

  3. Repository Service and Client Application

  4. Repository Service and Integration Services.

Show answer
Correct Option: A

Why is it best to use shortcuts to a common directory for source and target definition objects?

technology databases

  1. Enforces single –name standard for Sources and Targets.

  2. Shortcuts work more efficiently with databases.

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

  4. Makes migration easier and more efficient.

Show answer
Correct Option: D

Null value in SQL represent?

technology databases

  1. An empty String

  2. Zero

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

  4. Numeric

Show answer
Correct Option: C

A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 select count(deptno) from employee?

technology databases

  1. 1

  2. 3

  3. 2

  4. 4

Show answer
Correct Option: B

A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 Select avg(salary) from employee?

technology databases

  1. 0

  2. 30000

  3. 22500

  4. 35000

Show answer
Correct Option: B

A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 Select avg(Isnull(salary,10000)) from employee?

technology databases

  1. 0

  2. 30000

  3. 25000

  4. 35000

Show answer
Correct Option: C

EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Use these data for the following Questions: Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2 Where E1.SAL > E2.SAL ) will retrieve
technology databases

  1. 3500,5000,2500

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750

Show answer
Correct Option: A

Which of the following is not correct about a View ?

technology databases

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

  2. Occupies data storage space

  3. To hide complexity of a query

  4. To hide complexity of a calculations

Show answer
Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of a View.

A View is a virtual table that is derived from one or more tables in a database. It does not occupy data storage space as it does not store any data itself. Instead, it is a saved query that can be used to retrieve data from the underlying tables.

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

Option A) To protect some of the columns of a table from other users - This option is correct because a View can be used to restrict access to certain columns of a table, allowing users to see only the columns that they have permission to access.

Option B) Occupies data storage space - This option is incorrect because a View does not occupy any data storage space. It is just a virtual table that is created based on the underlying tables.

Option C) To hide complexity of a query - This option is correct because a View can be used to simplify complex queries. Instead of writing a complex query each time, users can create a View that encapsulates the complexity and provides a simplified interface to retrieve the desired data.

Option D) To hide complexity of calculations - This option is correct because a View can be used to encapsulate complex calculations. Users can create a View that performs the necessary calculations and presents the results in a simplified manner.

The correct answer is B) Occupies data storage space. This option is incorrect because a View does not occupy any data storage space.

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department?

technology databases

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

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

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

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

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

Show answer
Correct Option: B

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy
technology databases

  1. Yes

  2. No

  3. NA

  4. na

Show answer
Correct Option: B

SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return

technology databases

  1. ALWAY

  2. S ALWA

  3. ALWAYS

  4. None of the above

Show answer
Correct Option: C

Is it possible to modify a Datatype of a column when column contains Data
technology databases

  1. Yes

  2. No

  3. NA

  4. na

Show answer
Correct Option: B

Which is not part of the Data Definiton Language

technology databases

  1. CREATE

  2. ALTER

  3. ALTER SESSION

  4. None of the above

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the Data Definition Language (DDL) and its various commands.

DDL is a subset of SQL (Structured Query Language) that is used to define and manage the structure of a database. It includes commands for creating, modifying, and deleting database objects such as tables, indexes, and views.

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

Option A) CREATE - This option is part of the Data Definition Language (DDL). The CREATE command is used to create new database objects like tables, views, indexes, and schemas.

Option B) ALTER - This option is part of the Data Definition Language (DDL). The ALTER command is used to modify the structure of existing database objects, such as adding or deleting columns in a table.

Option C) ALTER SESSION - This option is not part of the Data Definition Language (DDL). The ALTER SESSION command is used to modify the session-specific parameters or settings associated with a user session, such as changing the date format or language settings. It is part of the Data Manipulation Language (DML) rather than DDL.

Option D) None of the above - This option is incorrect because both Option A (CREATE) and Option B (ALTER) are part of the Data Definition Language (DDL). Option C (ALTER SESSION) is the correct answer as it is not part of DDL.

The correct answer is C) ALTER SESSION. This option is not part of the Data Definition Language (DDL) because it belongs to the Data Manipulation Language (DML).

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
technology databases

  1. Will

  2. Wont

  3. NA

  4. na

Show answer
Correct Option: B

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?

technology databases

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

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

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

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

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

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

Show answer
Correct Option: B

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e.department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?
technology databases

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

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

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

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

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions