Sign Up Login


cpun sb


{ City } bangalore
< Country > india
* Profession * job holder
User No # 119626
Total Questions Posted # 5
Total Answers Posted # 5

Total Answers Posted for My Questions # 6
Total Views for My Questions # 18119

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 5
Questions / { cpun sb }
Questions Answers Category Views Company eMail

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 SQL PLSQL 2496

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

2 SQL PLSQL 8007

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 SQL PLSQL 2713

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 SQL PLSQL 2290

7. Where would you look for errors from the database design?

Fintellix,

1 SQL PLSQL 2613



Answers / { cpun sb }

Question { Fintellix, 2496 }

1. Which is an aggregate function?
a. Union b. like c. max d. Rank


Answer

C. Max

Is This Answer Correct ?    2 Yes 1 No

Question { Fintellix, 8007 }

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B


Answer

Ans: showing error (ORA-00904: "A"."A": invalid identifier)

Is This Answer Correct ?    3 Yes 4 No


Question { Fintellix, 2713 }

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all
Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);


Answer

Ans: sum_1 max_1 count_1
2014 2011 3

Is This Answer Correct ?    1 Yes 0 No

Question { Fintellix, 2290 }

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B
On A.dept_id=B.dept_id
And A.emp_id=B.emp-id;


Answer

Ans: b. Null

Is This Answer Correct ?    1 Yes 0 No

Question { Fintellix, 2613 }

7. Where would you look for errors from the database design?


Answer

Ans: C. in the alert log

Is This Answer Correct ?    1 Yes 0 No