By admin | March 14, 2006
What does ROLLBACK do? - ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.
What is SAVE POINT? - For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of [...]
By admin | March 13, 2006
What is Log Switch? - The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
What is On-line Redo Log? - The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to [...]
By admin | March 11, 2006
What is scrollable cursor?
The use of HAVING, WHERE and GROUPBY in one SQL?
What is SORTING and GROUPING?
What are the different types of OUTER JOINS?
Explain the UNION operation in SQL . What is meant by OUTER JOIN?
What is a non-correlated subquery?
What is a correlated subquery?
What do you know about subqueries?
What is the theory behind the JOIN [...]
By admin | March 10, 2006
What are the differences between database designing and database modeling?
If the large table contains thousands of records and the application is accessing 35% of the table, which method do you use: index searching or full table scan?
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
How to [...]
By admin | January 29, 2006
To test a Web Service you must create a windows application or web application to consume this service? It is True/False?
How many classes can a single.NET DLL contain?
What are good ADO.NET object(s) to replace the ADO Recordset object?
On order to get assembly info which namespace we should import?
How do you declare a static variable and [...]
By admin | January 17, 2006
What are the built-in functions used for sending Parameters to forms?
Can you have more than one content canvas view attached with a window?
Is the After report trigger fired if the report execution fails?
Does a Before form trigger fire when the parameter form is suppressed?
Is it possible to split the print reviewer into more than one [...]
By admin | September 22, 2005
What are the different types of joins?
Explain normalization with examples.
What cursor type do you use to retrieve multiple recordsets?
Diffrence between a “where” clause and a “having” clause
What is the difference between “procedure” and “function”?
How will you copy the structure of a table without copying the data?
By admin | August 2, 2005
How many memory layers are in the shared pool?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up?
Define the SGA and how you would [...]
What is MySQL?
What is Postgres?
What are the basic steps in setting up an Oracle system?
What is a stored procedure, and which databases support it?
What is RMAN?
Also posted in Unix/Linux |
Type of table?
Events of module pool?
Events of interactive report?
Also posted in General, Java, SAP ABAP |
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 [...]
By admin | March 15, 2005
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?
