Owner: Tech Interview Questions URL:http://www.technicalinterview.info/ Join Date: Sat, 04 Aug 2007 13:34:59 -0500 Rating:0 Site Description: A Interviews related website which offers technical students with latest information on learning the tweaks in programming languages, information on all the best corporate companies of all over the world. Site statistics:Click here
Tough Oracle Interview Questions 2007-10-07 05:41:49 What is a CO-RELATED SUBQUERY
A CO-RELATED SUBQUERY is one that has a correlation name as table or view designator in the FROM clause of the outer query and the same correlation name as a qualifier of a search condition in the WHERE clause of the subquery.
2. eg
3. SELECT field1 from table1 X
4. WHERE field2>(select avg(field2) from table1 Y
5. where
field1=X.field1);
(The subquery in a correlated subquery is revaluated for every row of the table or view named in the outer query.)
What are various joins used while writing SUBQUERIES
Self join-Its a join foreign key of a table references the same table.
Outer Join–Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.
Equi-join–Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.
What are various constraints used in Read more:Oracle
, Tough
Oracle Interview Questions Part 2 2007-10-07 05:35:52 When should you consider denormalization
Whenever performance analysis indicates it would be beneficial to do so without compromising data integrity.
How can you determine if an Oracle
instance is up from the operating system level?
There are several base Oracle processes that will be running on multi-user operating systems, these will be smon, pmon, dbwr and lgwr. Any answer that has them using their operating system process showing feature to check for these is acceptable. For example, on UNIX a ps -ef|grep dbwr will show what instances are up.
Users from the PC clients are getting messages indicating?
ORA-06114: (Cnct err, can’t get err txt. See Servr Msgs & Codes Manual)
Users from the PC clients are getting the following error stack?
ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
HP-UX Error: 2: No such file or directory
How can you determine if the SQLNET process is running for SQLNET V1? How about V2
For SQLNET V1 che
Real time Oracle Interview Questions 2007-10-04 14:10:30 You have installed Oracle
and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem.
Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.
When configuring SQLNET on the server what files must be set up
INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
When configuring SQLNET on the client what files need to be set up
SQLNET.ORA, TNSNAMES.ORA
What must be installed with ODBC on the client in order for it to work with Oracle
SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
You have just started a new instance with a large SGA on a busy existing server. Performance is terrible, what should you check for
The first thing to check with a large SGA is that i
Oracle DBA Interview Questions Part 1 2007-10-04 14:04:51 If a table space shows excessive fragmentation what are some methods to defragment the table space? (7.1,7.2 and 7.3 only)
In Oracle
7.0 to 7.2 The use of the ‘alter session set events ‘immediate trace name coalesce level ts# command is the easiest way to defragment contiguous free space fragmentation. The ts# parameter corresponds to the ts# value found in the ts$ SYS table. In version 7.3 the alter table space coalesce is best. If the free space isn’t contiguous then export, drop and import of the table space contents may be the only way to reclaim non-contiguous free space.
How can you tell if a table space has excessive fragmentation
If a select against the dba_free_space table shows that the count of a tablespaces extents is greater than the count of its data files, then it is fragmented.
You see the following on a status report:
redo log space requests 23, redo log space wait time 0 Is this something to worry about? What if redo log space wait time is high? How
Interview Questions on SAP 2007-11-01 10:05:00 1. What does the inclusion of D&B for SAP R/3 in mySAP Edition mean for customers?
Basically all mySAP Edition contract holders will automatically receive the D&B for SAP software as part of their regular Edition upgrade shipments. They will be able to install both A/R and A/P versions of the software as many times as they desire under the conditions of their SAP contract, without the need to obtain separate licences for the D&B Add-on. Do I have to have mySAP.com to be able to use D&B for SAP R/3? No, the software is available from SAP without the need to purchase or install mySAP.com.
2. What are the benefits for SAP and D&B?
SAP differentiates itself from competitors by delivering software and content, which is increasingly becoming a customer focus. The unique combination of standardized software and standardized data that can be processed in R/3 is very attractive to customers.
3. What is significant about online access in R/3 to D&B information?
The signif
SAP Interview Questions 2007-11-01 09:59:52 1. Can you create a table with fields not referring to data elements?
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element. What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.
2. What should be the approach for writing a BDC program?
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED “CONVERSION”.
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED “SAP DATA TRANSFER”.
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed.if success data will transfer).
3. What are the problems in processing batch input sessions and How is batch input process different from processing online?
PROBLEMS:
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). How
Interview Questions On SAP ABAP 2007-11-26 03:59:29 1) What is runtime analysis? Have you used this?
It’s checks program execution time in microseconds. When you go to se30.if you give desired program name in performance file. It will take you to below screen. You can get how much past is your program.
2) What is meant by performance analysis? Have done
3) How to transfer the objects? Have you transferred any objects?
4) How did you test the developed objects?
I was testing a developed object. There are two types of testing - Negative testing - Positive testing In negative testing we will give negative data in input and we check any errors occurs. In positive testing we will give positive data in input for checking errors.
5) What is the difference between SAP Memory and ABAP Memory?
6) In order to upload Purchase order details, how you handle multiple values for a single field?
Eg: Item field may contain no. of values for a record
7) What is the procedure you followed to upload the data?
How did you handle errors in Call Transa
SAP-ABAP Interview Questions-1 2007-11-26 03:56:58 1. How data is stored in cluster table?
Each field of cluster table behaves as tables which contains the no. of entries.
2. What are client dependant objects in abap/sap?
SAP Script layout, text element, and some DDIC objects.
3. On which even we can validate the input fields in module programs?
In PAI (Write field statement on field you want to validate, if you want to validate group of fields put in chain and End chain statement.)
4. In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?
AT SELECTION-SCREEN ON VALUE-REQUEST FOR MATERIAL. CALL FUNCTION ‘F4IF_INT_TABLE_VALUE_REQUEST’ to get material and material group for the plant.
5. How do you get output from IDOC?
Data in IDOc is stored in segments, the output from Idoc is obtained by reading the data stored in its respective segments.
6. When top of the page event is triggered?
After executing first write statemen
SAP Interview Questions Part5 2007-11-26 03:52:49 22. What are variables?
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacement Path.
23. What is AWB?. What is its purpose?
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information warehousing.
24. What is the significance of ODS in BIW?
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes
SAP Interview Questions Part4 2007-11-26 03:50:22 12. Explain open SQL vs native SQL?
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
13. What are datasets?
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
14. What are internal tables check table, value table, and transparent table?
Internal table: It is a standard data type object, which exists only during the runtime of the program. Che
SAP Interview Questions Part3 2007-11-26 03:49:18 1. What is ERP?
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
2. Different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financial, Siebel, PeopleSoft. Among all the ERPs most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
3. What is SAP?
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.
4. Explain the concept of
Recommend Site To A Friend
