Archive for the ‘interview’ Category

Bruce Momjian Interview in InformationWeek

InformationWeek has a good interview with Bruce: Open Source PostgreSQL Developer Bruce Momjian Spills The DB Beans.

In the interview, Bruce talks about how he spends one day a week at the EnterpriseDB site but most of his time working on Postgres.

There aren’t a lot of quotes in the interview. I wonder if a longer interview is coming.

There are a few anti-comparisons between “bearded sage” Momjian and JBoss’ Marc Fleury and, of course, the obligatory comparison to MySQL.

PostgreSQL sought to match major relational database systems and afterward addressed performance. “We didn’t focus on performance until the end.

Click to continue reading “Bruce Momjian Interview in InformationWeek”

Read the rest of this entry »

10 Basic Interview Questions for Oracle

For Basic SQL:

  1. How do you convert a date to a string? To_char. A bonus would be that they always include a format mask.
  2. What is an aggregate function? Grouping, sums or counts, etc.
  3. What is an interval? Specifies a period of time.
  4. What is a nested subquery? A subquery in a where clause.
  5. What is the dual table? A single row table provided by oracle for selecting values and expressions.

For Basic PL/SQL:

  1. Describe the block structure of PLSQL. Declaration, Begin, exception, end.
  2. What is an anonymous block?

Click to continue reading “10 Basic Interview Questions for Oracle”

Read the rest of this entry »

GM CIO Discusses Oracle’s Acquisition Strategy

InformationWeek has a good interview with the CIO of GM. Why would I post that on this blog? They interviewed him about Oracle. Yep, General Motors’ CIO Speaks Out On Oracle’s Acquisition Strategy.

I have to ask myself why this is news. Why does what the CIO of a car company have any bearing on Oracle? The interview itself, the questions and answers, make the point.

I’ll let you read the article to get the details but the gist of the interview:

Q: What do do you think of Oracle’s spending spree?
A: Like it.

Click to continue reading “GM CIO Discusses Oracle’s Acquisition Strategy”

Read the rest of this entry »

Interview with Oracle’s President, Charle Phillips

InformationWeek has a good interview with Charles Phillips where he discusses Oracle’s competition. Charles Phillips has been in the background at Oracle for a long time but in the last few years has really been the driving force. I think he is largely responsible for the current acquisition strategy that Oracle is following.

Some good Q&A from the interview (some of these are not the entire quote, read the article fore the entire quote):

InformationWeek: Oracle can’t possibly replace the majority of SAP ERP deployments since companies have gone through so much time and expense putting them in place.

Click to continue reading “Interview with Oracle’s President, Charle Phillips”

Read the rest of this entry »

How to interview an Oracle Developer

It looks like the job market for Oracle is opening up. I’m seeing many of my friends find new jobs and I’m doing a lot of interviewing at work. I hope this is a trend that continues. In this entry, I share my method for interviewing Oracle resources and provide some sample interview questions and answers for developers.

Interviewing anyone can be difficult. Interviewing technical resources is very difficult. To me, probably the hardest thing is pinpointing exactly what you want this person to do. What, exactly, will this person be doing in their day-to-day job?

Click to continue reading “How to interview an Oracle Developer”

Read the rest of this entry »