C Programming and Technical Verbal Ability Miscellaneous

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

Read Solution (Total 2)

ans is a.
10 years agoHelpfull: Yes(0) No(3)

Answer is option a)
Only that follows the syntax of DELETE
5 years agoHelpfull: Yes(0) No(0)

C Other Question

Data recovery is done in which layer?
a) physical
b) datalink
c) network
d) transport
CHOOSE CORRECT OPTION 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