Data-Access

Q&A Categories

Applications
Business-Objects
Clarify-CRM
- AJAX
- CSS
- CSS3
- Html
- java-Script
- VB-Script
Concepts
- Data-Modeling
- Data-Structures
- OLAP
- OOPS
- UML
Data-Warehouse
- Abinitio
- Analysis-services
- Business-Intelligence
- Cognos
- Concepts-and-Architecture
- Data-Warehouse-General
- DataStage
- Designer
- ETL
- Informatica
- MicroStrategy
- Reportnet
Database
- Btrieve
- Database-Admin
- Firebird
- Informix
- Microsoft-Access
- MYSQL
- PostgreSQL
- SAP-DB
- SQL
- SQL-server-2000-interview-questions
- Stored-Procedures
- Sybase
- Unify
General
- Career-Goals
- Creativity
- Flexibility
- Human-Resources
- Interests
- Job-Peformance
- Leadership
- Motivation
- Personal-Interview
- Self-Assessment
- Skills
Help-Desk
J2EE
- Core-Java
- EJB
- Hibernate
- Java
- Java-Patterns
- JDBC
- JMS
- JSP
- Ruby
- Servlets
- Struts
- Websphere
Languages
Mainframe
- CICS
- COBOL
- DB2
- IDMS
- JCL
- VSAM
Management
- Business-Analyst
- Citrix
- Desktops
- Lotus-Notes
- MBA
- Network
- Project-Manager
- Servers
- Team-Lead
Microsoft
- Ado-NET
- Architecture
- ASP
- ASP-NET
- Basics
- C-Sharp
- DataGrid
- DotNet
- Mixed
- VB-NET
- Visual-Basic
Microsoft-NET
Networking
- Bluetooth
- Client-Server-Computing
- Computer-Networks
- Networks-and-Security
Operating-System
- Shell-Scripting
- Solaris-Admin
- UNIX
- Unix-Commands
- Unix-Programming
- Windows-Unix
Oracle
- Backup-and-Recovery
- D2K
- Data-Access
- Database-Administration
- Database-security
- Distributed-Processing
- Memory-Management
- Oracle-Forms-3-0
- Oracle-Forms-4-0
- Oracle-General
- PL-SQL
- Programmatic-Constructs
- RMAN
- Scenarios
- SQL-Plus
- System-Architecture
Oracle-Apps
- Application-Object-Library
- Component-Interface
- Flexfields
- Forms-Customization
- HRMS
- PeopleCode
- PeopleTools
- PS-Admin
- PS-Mixed
- Scope-and-Application
- Segment-Security
- SQR
- Technical
- test
Peoplesoft
Programming
- Alogirthms
- C
- C-Plus-Plus
- ColdFusion
- Delphi
- Perl
- PHP
- Python
- VBA
- VoiceXML
- XML
SAP-R-3
- ABAP
- BDC
- Internal-Tables
- Modules
- Reports
- SAP-Admin
- sd
Siebel
- Siebel-General
Testing
- Bug-Tracking
- Common
- Common-Questions
- DataBase-Testing
- Discussion
- Load-Testing
- Product-Testing
- QA-Testing
- Quality-Control
- Quality-Management-
- Security-Testing
- Software-Testing
- Test-Automation
- Test-Cases
- Testing-General
- Testing-Scenarios
- Web-Testing
- Whitebox-Testing
- Wireless-Testiing
Testing-Tools
- LoadRunner
- QTP
- Rational-Robot
- SilkTest
- Test-Director
- Winrunner
Web
Accounting-Reports
Accounts-Payable
Accounts-Receivables
Audit
Cashier
Cost-Accounting
Fixed-Assets
General-Ledger
Payroll
Supervisory

When does a Transaction end ?

When does a Transaction end ? When it is committed or Rollbacked.'

No Answers In: Data-Access By: ashok [

] Sep 3, 2010

What are the different approaches used by Optimizer in choosing an execution plan

What are the different approaches used by Optimizer in choosing an execution plan ? Rule-based and Cost-based.'

No Answers In: Data-Access By: ravi [

] Sep 2, 2010

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? The Optimizer chooses Cost_based approach and optimizes with...

No Answers In: Data-Access By: ashok [

] Sep 2, 2010

What is the function of Optimizer ?

What is the function of Optimizer ? The goal of the optimizer is to choose the most efficient way to execute a SQL statement.'

No Answers In: Data-Access By: priyanka [

] Aug 28, 2010

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? This value causes the optimizer to the cost-based...

No Answers In: Data-Access By: Anu [

] Aug 27, 2010

What is RULE-based approach to optimization ?

What is RULE-based approach to optimization ? Choosing an executing planbased on the access paths available and the ranks of these access paths.'

No Answers In: Data-Access By: vikas [

] Aug 22, 2010

What is SAVE POINT ?

What is SAVE POINT ? For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared ...

No Answers In: Data-Access By: nitin [

] Aug 22, 2010

What is Read-Only Transaction ?

What is Read-Only Transaction ? A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.'

No Answers In: Data-Access By: sam [

] Aug 21, 2010

What is Execution Plan ?

What is Execution Plan ? The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.'

No Answers In: Data-Access By: shoeb [

] Aug 18, 2010

What is COST-based approach to optimization ?

What is COST-based approach to optimization ? Considering available access paths and determining the most efficient execution plan based on statistics...

No Answers In: Data-Access By: raju1587 [1

] Aug 17, 2010