C Programming and Technical Numerical Ability Algebra

There is an employer table with key fields as employer number data in every n'th row are
needed for a simple following queries will get required results.
(a) select A employee number from employee A , where exists from employee B where A employee
no. >= B employee having (count() mod n)=0
(b) select employee number from employe A, employe B where A employe number>=B employ
number group by employee number having(count() mod n=0 )
(c) both (a) & (b)
(d) none of the above
CHOOSE THE CORRECT OPTION

Read Solution (Total 2)

i think Ans is b)
10 years agoHelpfull: Yes(0) No(0)

ans) b
logically b is correct and having claue is always associated with group by
10 years agoHelpfull: Yes(0) No(0)

C Other Question

Type duplicates of a row in a table customer with non uniform key field customer number you
can see
a) delete from costomer where customer number exists( select distinct customer number from
customer having count )
b) delete customer a where customer number in b rowid
c) delete customer a where custermor number in( select customer number from customer a,
customer b
d) none of the above
CHOOSE THE CORRECT OPTION On a machine where pointers are 4 bytes long, what happens when the following code is
executed.
main()
{
int x=0,*p=0;
x++; p++;
printf ("%d and %d\n",x,p);
}
a) 1 and 1 is printed
b) 1 and 4 is printed
c) 4 and 4 is printed
d) causes an exception
CHOOSE THE CORRECT OPTION