I would start by asking your ISP how they handle network access/load balancing.

Most probably what you are seeing as a NIC is a virtual-NIC masking an underlying load balancing structure.

Is...

Question is: what is preventing the connection?

nfs_john (5/22/2010)

---

Yes agreed. Problem is that it is all one one machine for dev, test, qa. Then it goes to prop on a different machine. They aren't even virtual machines....

Script will depend on what you have to promote, if promotion includes adding two columns to a...

1- You have to code one insert statement for each row you want to add to the target table.

2- You cannot insert '11.25/hr' into a currency data type - currency...

goodguy (5/22/2010)

---

In the real world, physical cash-sale receipts show details of products purchased, thus solving the need to refer to an underlying invoice. In RDBMS, this is not easy to...

Roll forward and roll back are terms related to recovery - as in backup/recovery.

Reading your posting I think your interviewer was refering to "promoting" changes and "rolling out" changes. This...

In a properly organized three tier environment I expect to see as many as four different versions of an object.

1- In development. Checked-out object that is in development process under...

Thank you for pointing at the right document but,...

That's not true. There is a Microsoft published way......

Interview question, huh?

A good answer would be: SQL...

sameer.kasi200x (5/19/2010)

---

One of my seniors had tried it out earlier (checking for ORA-1630 and no ORA-1652). There is no clue about this error in Alert Log on my Unix machine,...

Oksana March (5/20/2010)

---

Hi,

I am Jr. DBA at my company and recently I come across a lot of code writing by somebody else utilizing MERGE command. I read a big description...

Start by executing underlying query and see what it does 🙂

This is a...

So... what's the problem? -- Any error?

Do you have those tables/views available?

Do you have the right privs on them?