I'VIE QNS ORACLE,SQL

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…)

more interview questions - all General and Database interview questions

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? (more…)

more interview questions - all Database interview questions

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…)

more interview questions - all Windows and .NET and Database interview questions

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…)

more interview questions - all .NET and Database interview questions

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…)

more interview questions - all General and Database interview questions

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…)

more interview questions - all Java and Networking and Database interview questions

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
(more…)

more interview questions - all Java and Database interview questions

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

more interview questions - all Database interview questions

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?