Hi All,
Recently I attended a interview for a developer position in
an educational university. They asked me the a question, I
answered somehow but I was not not satisfied myself. Can
anybody reply for it? The question is:
A business user comes to you directly with an urgent
request:: there is a problem with some students not being
able to re-enrol. It appears that ?something has gone wrong
with the end-dating of some previous courses they had
enrolled in, and this is preventing them from completing
their on-line re-enrolments?. Fortunately the user has done
some analysis on the situation, and has developed some code
to change the end dates. They tell you that they have
tested this code in the ?dev? environment, and it works
fine. They are asking you to please get this implemented in
production as soon as possible.
What steps would you take in response to their request ?
Thanks
I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
What is the architectural difference between Oracle and SQL
Server 2000?
If I have 100 databases, how many instances get created
when you use Oracle and how many get created when you use
SQL Server?
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
99
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY
TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
64
My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
How I can load an image into image item on Forms.
I want to know about built-ins and procedure.
and also code for it.
55
Describe what redo logs are.
44
how to use buttons,check boxes in paper layout,paper design
and paper parameter form in oracle report developer 10g
33
hi friends i completed b.com 2004.i have 3y accounting exp.
in manufacturing company.now i have completed oracle
finance.pls suggest me how will get job in oracle.can i get
job in oracle.
24
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
36
Can you convert a bit-mapped report to ASCII
(character-mode) Report ? How ?
suppose u have been seven tables based on that u have to
create a report u don't have access to db. then how do u
find the relation between tables
67
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
62
Can a formula column referred to columns in higher group ?
along with your userid / name. ThanQ
Site Map