databases Online Quiz - 56
Description: databases Online Quiz - 56 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following port is used only in unconnected look up not in connected look up?
We can use the joiner in case of?
In which of the transformation we can discard duplicate data?
Which is not true regarding unconnected lookup?
Why is it best to use shortcuts to a common directory for source and target definition objects?
Null value in SQL represent?
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?
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?
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?
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
Which of the following is not correct about a View ?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy
SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return
Is it possible to modify a Datatype of a column when column contains Data
Which is not part of the Data Definiton Language
If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
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?