KyaPoocha.com

Huge Collection of Interview Questions


Archive for July, 2006

How to read and write a file using javascript? 

I/O operations like reading or writing a file is not possible with client-side javascript. However , this can be done by coding a Java applet that reads files for... Read more »

What is JavaScript? 

JavaScript is a platform-independent,event-driven, interpreted client-side scripting and programming language developed by Netscape Communications Corp. and Sun... Read more »

What are different Implicit Objects in JSP? 

There are 9 Implicit Objects defined in JSP are : application, config, exception, out, page, pageContext, request, response and session. The main difference between... Read more »

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... Read more »

What does rollback do? 

ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.  Read more »

What is execution plan? 

The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.  Read more »

What is Function of Optimizer? 

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.  Read more »

What are the factors that affect OPTIMIZER in choosing an Optimization approach ? 

The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.  Read more »

Can you have more than one content canvas view attached with a window? 

Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run... Read more »

What is the use of Control File ? 

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation... Read more »

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 the database. Whenever a transaction is committed, the... Read more »

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.  Read more »

What is a pre-requisite for connection pooling? 

Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string... Read more »

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted? 

Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL... Read more »

Explain ACID rule of thumb for transactions. 

A transaction must be: 1.      Atomic - it is one unit of work and does not dependent on previous and following transactions. 2.      Consistent -... Read more »

Page 26 of 28« First...«2425262728»