By admin | November 11, 2004
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?
By admin | November 3, 2004
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 [...]
Also posted in .NET, Windows |
By admin | November 1, 2004
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?
By admin | October 16, 2004
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 [...]
By admin | October 12, 2004
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?
By admin | October 12, 2004
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 [...]
Also posted in Java, Networking |
By admin | October 9, 2004
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
By admin | September 26, 2004
What is source qualifier?
Difference between DSS & OLTP?
Explain grouped cross tab?
By admin | September 26, 2004
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();
By admin | September 17, 2004
How do you read transaction logs?
How do you reset or reseed the IDENTITY column?
By admin | September 1, 2004
What criteria would you use to select Web transactions for load testing?
For what purpose are virtual users created?
By admin | September 1, 2004
Aaron Boodman took up a job with Microsoft (MSN division) and told the story of his interview in his Weblog. Below is an excerpt of questions potential candidates might find interesting.
Compare and contrast SQL Server with MySQL.
Compare and contrast stored procedures and dynamic SQL.
Also posted in General, Windows |
