Story of Appreciation in Big Company

One young academically excellent person went to apply for a managerial position in a big company.

He passed the first interview, the director did the last interview, made the last decision.

The director discovered from the CV that the youth's academic achievements were excellent all the way, from the secondary school until the postgraduate research,
Never had a year when he did not score.

The director asked,

Read More

Hard and New Tricky Quiz Questions for Intrviewer

Interviewer: He ordered a cup of coffee for the candidate.

Coffee arrived kept before the candidate, then he asked what is before you?

Candidate: Instantly replied "Tea"

He got selected.

You know how and why did he say "TEA" when he knows very well that coffee was kept before.

Read More

Wipro Training Materials : RDBMS Check your Self

Wipro Training Materials

1)2nd Normal form
2)views
3)Initcap
4)Day,dd,mon,yyyy,hr:mmAM
5)Notnull?
6)composite key
7)select count(distinct dept_id)
8)select column1,column2 from group by......(the choice which doesn't have semicolon and table name)
9)view
10)having
11)null value
12)multicolumn
13)alter view
14)count(date) and min(date)
15)outerjoin
16)grant,revoke
17)values 3 or 5
18)set define...
19)intersect
20)from,where,group by, having, order by
21)100*90
22)referential integrity
23)city(lower_...).....where city='france'

Read More

Wipro Training Materials: RDBMS Interview Questions

Wipro Training Materials

  Q1> Using which of the following the strucutre of a database can be manipulated

  1>Data Definition Language (DDL)

  2>Data Control Language (DCL)

  3>Data Manipulation Language (DML)

  4>Transaction Control Language (TCL)

------------------------------------------------------------------------------------------------------------

Q2> The host language contains which of the following SQL strucutre

   1>SQL-92

   2>Processor command

   3>Embedded SQL

   4>Host-language declaration2

------------------------------------------------------------------------------------------------------------

 Q3> Which of the following GROUP BY Query results in an error when executed

    1>select deptno , job, sum(HRA) from emp group by job, deptno ;

    2>select sum(HRA) , deptno , job from emp group by job ,deptno ;

    3>select deptno , job, sum(HRA ) from emp group by job;

    4>select deptno , sum(HRA) , job from group by job , deptno

    ---------------------------------------------------------------------------------------------------------

Read More

RDBMS Test Your Self, Interview Questions

1. ___________ Provide table security by restricting access to a predetermined set of rows or columns of a table.

Ans: VIEWS

2.Create or replace view emp-view as (select empno, ename, job, deptno from emp where job='manager') with read only

 Ans: None of the above

3.Given that a button can generate an action event which listener would you expect to have to implement, in a class, which would handle this event?

Ans: Action listener

Read More