|
| |
| |
| |
|
|
|
| Technical Interview Questions |
| 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 in India. |
| Language: English |
| RSS Feeds for this Blog |
|
Statistics |
| Unique Visitors: 1264 |
| Total Unique Visitors: 4384130 |
| Visitors Out: 1756 |
| Total Visitors Out: 1756 |
|
|
|
| |
|
|
| |
|
| Cobol Interview Questions |
| 2008-04-01 10:25:37 |
1. When would you use in-line perform?
When the body of the perform will not be used in other paragraphs. If the body of the perform is a generic type of code (used from various other places in the program), it would be better to put the code in a separate para and use PERFORM para [...]...
|
| |
|
| SAP-Basis Interview Questions |
| 2008-03-08 05:25:16 |
1. Why do you use DDIC user not SAP* for Support Packs and SPam?
Do _NOT_ use neither DDIC nor SAP* for applying support packages. Copy DDIC to a separate user and use that user to apply them.
2. Can you kill a Job?
Yes - SM37 - select - kill
3. If you have a long running Job, [...]...
|
| |
|
| SAP-FI Interview Questions |
| 2008-03-08 05:22:46 |
1. What is the difference between company and company code?
A company is the organizational unit used in the legal consolidation module to roll up financial statements of several company codes. The Company Code is the smallest organizational ! unit for which a complete self-contained set of accounts can be drawn up for purposes of external [...]...
|
| |
|
| SAP-SD Interview Questions |
| 2008-03-08 05:18:30 |
1. What is the purpose of text determination, account determination, partner determination, output determination, storage location determination
Text determination: For transferring information from material or customer to order/delivery or invoice (and anything in between) Account determination: For transferring financial and costing information to proper financial docs Partner determination: For determine who is is legally responsible for [...]...
|
| |
|
| SAP-HR Interview Questions |
| 2008-03-08 05:15:31 |
1. Explain the uses of the simple maintenance interface?
Simple Maintenance is used when Staff assignments and reporting structure are to be changed. There are three main areas in Simple Maintenance. Each area contains particular maintenance functions, depending on whether you want to edit organizational structure, staff assignments or task profiles. For Organizational Management users, Simple [...]...
|
| |
|
| SAP-PP Interview Questions |
| 2008-03-08 05:12:54 |
1. Can MRP be carried out for one particular level of a bom ( Level code : 0001/0002 etc).
Yes it can be done by running for specific materials (Single Material Single Level)
2 How Requirements( PIR,Sles Order, Customer Requirement) are reduced after they are produced?
Requirements are reduced automatically after Delivery is made to the Particular Order [...]...
|
| |
|
| SAP-R/3 Interview Questions1 |
| 2008-03-08 05:08:59 |
1. What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.
2. What is the advantage of structures? [...]...
|
| |
|
| SAP-R/3 Interview Questions |
| 2008-03-08 05:06:32 |
1. Can you create a table with fields not referring to data elements?
YES.
Example:- ITAB LIKE SPFLI.here we are referencing to a data object(SPFLI) not data element.
2. What are the different types of data dictionary objects?
tables, structures, views, domains, data elements, lock objects, Match code objects.
3. What should be the approach for writing a [...]...
|
| |
|
| 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 [...]...
|
| |
|
| 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 [...]...
|
| |
|
| 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 [...]...
|
| |
|
| 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 [...]...
|
| |
|
| 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 [...]...
|
| |
|
| Phone Interview Tips - Part 3 |
| 2007-11-17 10:25:36 |
Sound positive, self-confident and focusedThe recruiter has called you indicates that your resume or a member of your network has given him or her a favorable impression of you. You need to confirm this impression. Put a smile on your face and into your voice.
You need to demonstrate your enthusiasm and interest through your voice [...]...
|
| |
|
| Phone Interview Tips - Part 2 |
| 2007-11-17 10:24:02 |
During phone interviewHere are the some points for successful phone interviewing. Follow these simple rules and you should achieve success in this important phase of job-hunting.
Here are some do’s for phone Interviews:
Smile always helps you in every situation. Smiling will project a positive image to the listener and will change the tone of your voice.
Do [...]...
|
| |
|
| Phone Interview Tips |
| 2007-11-17 10:23:11 |
Now a days, employers use telephone interviews as a way of identifying and recruiting candidates for employment. Phone interviews are often used to screen candidates in order to narrow the pool of applicants who will be invited for in-person interviews.
While you are actively job searching, it is important to be prepared for a phone interview [...]...
|
| |
|
| Group Interview Tips |
| 2007-11-17 10:22:18 |
Group Interviews are used to see how you react in a group. An observer is there for watching to see whether you take a role of leadership or less communicative group members. If you are leading a group then the observer will be interested in seeing how good you are at delegating tasks and how [...]...
|
| |
|
| SAP Interview Questions Part2 |
| 2007-11-16 07:18:24 |
1. Where can I get the mySAP Business Suite on Linux?
You can order the mySAP Business Suite on Linux just like mySAP software on any other platform. If you are a SAP customer already, there will be no additional charges. From Release 4.6 onwards, the mySAP Business Suite on Linux is part of the standard [...]...
|
| |
|
| 30 best Oracle Interview Questions |
| 2007-10-14 16:22:00 |
1. How would you determine the time zone under which a database was operating?
2. Explain the use of setting GLOBAL_NAMES equal to TRUE.
3. What command would you use to encrypt a PL/SQL application?
4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
5. Explain the use of table functions.
6. Name three advisory statistics you can collect.
7. [...]...
|
| |
|
| Oracle Interview Questions Part 7 |
| 2007-10-14 16:19:35 |
What is an UTL_FILE.What are different procedures and functions associated with it?
UTL_FILE is a package that adds the ability to read and write to operating system files Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, [...]...
|
| |
|
| Oracle Interview Questions Part 6 |
| 2007-10-14 16:15:00 |
What is use of a cursor variable? How it is defined.
A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type(like a pointer in C). Declaring a cursor variable: TYPE [...]...
|
| |
|
| Interview Questions on DBA |
| 2007-10-07 12:48:49 |
There is a string ‘120000 12 0 .125′ ,how you will find the position of the decimal place
INSTR(’120000 12 0 .125′,1,’.') output 13
There is a ‘%’ sign in one field of a column. What will be the query to find it.
‘’ Should be used before ‘%’.
When you use WHERE clause and when you use HAVING [...]...
|
| |
|
| Tough Oracle Interview Questions |
| 2007-10-07 12: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) [...]...
|
| |
|
| Oracle Interview Questions Part 2 |
| 2007-10-07 12: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 [...]...
|
| |
|
| Real time Oracle Interview Questions |
| 2007-10-04 21: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 [...]...
|
| |
|
| Oracle DBA Interview Questions Part 1 |
| 2007-10-04 21: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 [...]...
|
| |
|
| Database interview questions |
| 2007-09-30 21:41:19 |
When should you increase copy latches? What parameters control copy latches
When you get excessive contention for the copy latches as shown by the “redo copy” latch hit ratio. You can increase copy latches via the initialization parameter LOG_SIMULTANEOUS_COPIES to twice the number of CPUs on your system.
Where can you get a list of all initialization [...]...
|
| |
|
| Oracle DBA interview questions |
| 2007-09-30 21:37:43 |
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Multiple extents in and of themselves aren?t bad. However if you also have chained rows this can hurt performance.
How do you set up tablespaces during an Oracle installation?
You should always attempt to use the Oracle Flexible Architecture standard or [...]...
|
| |
|
| Oracle Interview Questions & Answers - 2 |
| 2007-09-26 15:37:34 |
A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check
You need to check that the user has specified the full name of the object (select empid from scott.emp; instead of select empid from emp;) or has a synonym that balls to the [...]...
|
| |
|
| Oracle Interview Questions & Answers - 1 |
| 2007-09-26 15:33:40 |
What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?
SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error [...]...
|
| |
|
| Oracle Interview Questions & Answers |
| 2007-09-21 13:55:59 |
What command would you use to create a backup control file?
Alter database backup control file to trace.
Give the stages of instance startup to a usable state where normal users may access it.
STARTUP NOMOUNT - Instance startup
STARTUP MOUNT - The database is mounted
STARTUP OPEN - The database is opened
What column differentiates the V$ views to the [...]...
|
| |
|
| Oracle Interview Questions-V |
| 2007-09-17 21:43:09 |
7. Compare and contrast TRUNCATE and DELETE for a table.
Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. [...]...
|
| |
|
| Oracle Interview Questions-IV |
| 2007-09-17 21:41:37 |
1. Explain the difference between a hot backup and a cold backup and the benefits associated with each.
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it [...]...
|
| |
|
| Oracle Interview Questions-III |
| 2007-09-17 21:40:05 |
12.To view installed Oracle version information
SQL> select banner from v$version;
13. Display the number value in Words
SQL> select sal, (to_char(to_date(sal,’j'), ‘jsp’))
from emp;
the output like,
SAL (TO_CHAR(TO_DATE(SAL,’J'),’JSP’))
——— —————————————————–
800 eight hundred
1600 one thousand six hundred
1250 one thousand two hundred fifty
If you want to add some text like,
Rs. Three Thousand only.
SQL> select sal “Salary “,
(’ Rs. ‘|| (to_char(to_date(sal,’j'), ‘Jsp’))|| ‘ [...]...
|
| |
|
| Oracle Interview Questions-II |
| 2007-09-13 09:21:56 |
Display the records between two range
select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum< &Start);
Enter value for upto: 10
Enter value for Start: 7
ROWNUM EMPNO ENAME
——— ——— ———-
1 7782 CLARK
2 [...]...
|
| |
|
| Oracle Interview Questions-1 |
| 2007-09-07 17:21:41 |
1.To see current user name
Sql> show user;
2.Change SQL prompt name
SQL> set sqlprompt “Manimara > “
Manimara >
Manimara >
3.Switch to DOS prompt
SQL> host
4.How do I eliminate the duplicate rows ?
SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);
or
SQL> delete from table_name ta where rowid >(select min(rowid) from table_name tb where ta.dv=tb.dv [...]...
|
| |
|
| Oracle Interview Questions |
| 2007-09-07 17:19:24 |
1. What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.
2. What are the components of logical database structure of Oracle database?
There are tablespaces and database’s schema objects.
3. What is [...]...
|
| |
|
|
|
|
| |
 |
