0

databases Online Quiz - 56

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

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

  1. Input

  2. Variable

  3. Return

  4. Output


Correct Option: C

We can use the joiner in case of?

  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


Correct Option: D

In which of the transformation we can discard duplicate data?

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above


Correct Option: A

Which is not true regarding unconnected lookup?

  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


Correct Option: C

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

  1. Repository Service and Repository Database

  2. Repository Service and Administraive Console

  3. Repository Service and Client Application

  4. Repository Service and Integration Services.


Correct Option: A

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

  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.


Correct Option: D

Null value in SQL represent?

  1. An empty String

  2. Zero

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

  4. Numeric


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?

  1. 1

  2. 3

  3. 2

  4. 4


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?

  1. 0

  2. 30000

  3. 25000

  4. 35000


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

  1. 3500,5000,2500

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750


Correct Option: A
  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


Correct Option: B

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?

  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;


Correct Option: B

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

  1. Yes

  2. No

  3. NA

  4. na


Correct Option: B
  1. ALWAY

  2. S ALWA

  3. ALWAYS

  4. None of the above


Correct Option: C

Which is not part of the Data Definiton Language

  1. CREATE

  2. ALTER

  3. ALTER SESSION

  4. None of the above


Correct Option: C

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

  1. Will

  2. Wont

  3. NA

  4. na


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?

  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.


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?

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


Correct Option: C
- Hide questions