INTERVIEW QNS

A reader went through an interview at eBay and shared the questions asked

Let’s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don’t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

What is cursor and where do you use them?
more interview questions - all General and Database interview questions

Typical Oracle questions

Tell us about yourself, your background.
What are the three major characteristics that you bring to this company?
What version of Oracle were you running?
How many databases did the organization have and what sizes?
What motivates you to do a good job?
What two or three things are most important to you at work? (more…)


Interview questions for Oracle database administrator

Differentiate between TRUNCATE and DELETE

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Can you use a commit statement within a database trigger?
What is an UTL_FILE.What are different procedures and functions associated with it?

MS SQL Server interview questions

This one always gets asked. For a while the database interview questions were limited to Oracle and generic database design questions. This is a set of more than a hundred Microsoft SQL Server interview questions. Some questions are open-ended, and some do not have answers.

What is normalization? - Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization.

What is a Stored Procedure? - Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements. (more…)


Oracle interview questions

No answers, but these are useful questions for conducting Oracle interview. The readers are welcome to contribute their answers.

What is an oracle instance?
What is a view?
What is referential integrity? (more…)

more interview questions - all Database interview questions
C# developer interview questions
A representative of a high-tech company in United Kingdom sent this in today noting that the list was used for interviewing a C# .NET developer. Any corrections and suggestions would be forwarded to the author. I won’t disclose the name of the company, since as far as I know they might still be using this test for prospective employees. Correct answers are in green color.

1) The C# keyword ‘int’ maps to which .NET type?

System.Int16

System.Int32

System.Int64

System.Int128

2) Which of these string definitions will prevent escaping on backslashes in C#?

string s = #”n Test string”;

string s = “’n Test string”;

string s = @”n Test string”;

string s = “n Test string”;

(more…)


SAS interview questions

What SAS statements would you code to read an external raw data file to a DATA step?
How do you read in the variables that you need?
Are you familiar with special input delimiters? How are they used? (more…)

Java Web development interview questions

Can we use the constructor, instead of init(), to initialize servlet? - Yes , of course you can use the constructor instead of init(). There’s nothing to stop you. But you shouldn’t. The original reason for init() was that ancient versions of Java couldn’t dynamically invoke constructors with arguments, so there was no way to give the constructur a ServletConfig. That no longer applies, but servlet containers still will only call your no-arg constructor. So you won’t have access to a ServletConfig or ServletContext.

How can a servlet refresh automatically if some new data has entered the database? - You can use a client-side Refresh or Server Push. (more…)

JDBC and JSP interview questions
What is the query used to display all tables names in SQL Server (Query analyzer)?

select * from information_schema.tables
How many types of JDBC Drivers are present and what are they?- There are 4 types of JDBC Drivers
JDBC-ODBC Bridge Driver

Native API Partly Java Driver
Network protocol Driver
JDBC Net pure Java Driver

Data warehouse interview questions
What is source qualifier?
Difference between DSS & OLTP?
Explain grouped cross tab?

Java database interview questions

How do you call a Stored Procedure from JDBC? - The first step is to create a CallableStatement object. As with Statement and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.
CallableStatement cs =
con.prepareCall("{call SHOW_SUPPLIERS}");
ResultSet rs = cs.executeQuery();
(more…)

more interview questions - all Java and Database interview questions

SQL Server interview questions
How do you read transaction logs?
How do you reset or reseed the IDENTITY column?