Owner: Technical Interview Questions URL:http://www.technicalinterview.info/ Join Date: Sun, 07 Oct 2007 06:15:22 -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 in the world. Site statistics:Click here
Database interview questions 2007-09-30 14: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 parameters for your instance? How about an indication if they are default settings or have been changed
You can look in the init.ora file for an indication of manually set parameters. For all parameters, their value and whether or not the current value is the default value, look in the v$parameter view.
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning
The hit ratio is a measure of how many times the database was able to read a value from the buffers verses how many times it had to re-read a data value from the di Read more:Database
, interview
, questions
Oracle DBA interview questions 2007-09-30 14: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 another partitioning scheme to ensure proper separation of SYSTEM, ROLLBACK, REDO LOG, DATA, TEMPORARY and INDEX segments.
You see multiple fragments in the SYSTEM tablespace, what should you check first?
Ensure that users don?t have the SYSTEM tablespace as their TEMPORARY or DEFAULT tablespace assignment by checking the DBA_USERS view.
What are some indications that you need to increase the SHARED_POOL_SIZE parameter?
Poor data dictionary or library cache hit ratios, getting error ORA-04031. Another indication is steadily decreasing performance with all other tuning parameters the same.
What is the general guideline for sizing db_block_size and db_multi_bloc Read more:interview
, questions
Oracle Interview Questions Part 1 2007-09-30 14:31:57 What special Oracle
feature allows you to specify how the cost based system treats a SQL statement
The COST based system allows the use of HINTs to control the optimizer path selection. If they can give some example hints such as FIRST ROWS, ALL ROWS, USING INDEX, STAR, even better.
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done
Oracle tables always have one guaranteed unique column, the rowid column. If you use a min/max function against your rowid and then select against the proposed primary key you can squeeze out the rowids of the duplicate rows pretty quick. For example:
select rowid from emp e
where e.rowid > (select min(x.rowid)
from emp x
where x.emp_no = e.emp_no);
In the situation where multiple columns make up the proposed key, they must all be used in the where clause.
What is a Cartesian product
A Cartesian product is the result of an unrestricted join of two or more tables. The r
Oracle Interview Questions & Answers - 1 2007-09-26 08: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 that occurred in the code. These are especially useful for the WHEN OTHERS exception.
How can you find within a PL/SQL block, if a cursor is open?
Use the %ISOPEN cursor status variable.
How can you generate debugging output from PL/SQL?
Use the DBMS_OUTPUT package. Another possible method is to just use the SHOW ERROR command, but this only shows errors. The DBMS_OUTPUT package can be used to show intermediate results from loops and the status of variables as the procedure is executed. The new package UTL_FILE can also be used.
What are the types of triggers?
There are 12 types of triggers in PL/SQL that consist of combinations of the BEFORE, AFTER, ROW, TABLE, I Read more:Oracle
30 best Oracle Interview Questions 2007-10-14 09: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. Where in the Oracle
directory tree structure are audit traces placed?
8. Explain materialized views and how they are used.
9. When a user process fails, what background process cleans up after it?
10. What background process refreshes materialized views?
11. How would you determine what sessions are connected and what resources they are waiting for?
12. Describe what redo logs are.
13. How would you force a log switch?
14. Give two methods you could use to determine what DDL changes have been made.
15. What does coalescing a tablespace do?
16. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
17. Na
Oracle Interview Questions Part 7 2007-10-14 09: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, ISOPEN.
Can you use a commit statement within a database trigger.
No
What is the maximum buffer size that can be specified using the DBMS_OUTPUT. ENABLE function?
1,000,000
Share This
Read more:Oracle
Oracle Interview Questions Part 6 2007-10-14 09: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 type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will eventually be returned by the cursor variable.
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
How you open and close a cursor variable.Why it is required?
OPEN cursor variable FOR SELECT…Statement CLOSE cursor variable In order to associate a cursor variable with a p Read more:Oracle
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 […]
Share This
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 […]
Share This
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 […]
Share This
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 […]
Share This
Read more:Group
25 Toughest Interview Questions you will be ever asked 2007-11-13 14:33:40 1. Tell me about yourself.
Since this is often the opening question in an interview, be extracareful that you don’t run off at the mouth. Keep your answer to a minute or two at […]
Share This
9 SAP Interview Questions asked during my Interview 2007-11-13 14:20:47 1) What is internal recruitment ?
Internal recruitment is search for internal applicants. when you integrate with personal development, you can use profile match up which help to search for resources internally.
Also In recruitment it is represented by ‘P’ as Person and ‘AP” as external person.
2) What are problems generally faced while posting result to FICO […]
Share This
General Programming and IQ based Questions 2007-11-13 14:15:33 These questions are used on written exam by Indian contractor Wipro for job applicants in India.
John weighs twice as much as Marcia. Marcia’s weight is 60% of Bob’s weight. Dave weighs 50% of Lee’s weighs 190% of John’s wight. Which of these 5 persons wighs the least? A) Bob B) Dave C) John D) Lee […]
Share This
Read more:General
, Programming
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, [...] Read more:Basis
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 [...]
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 [...]
Cobol Interview Questions 2008-04-01 10:22:16 1. How do you sort in a COBOL program? Give sort file definition, sort statement syntax and meaning.
Syntax:
SORT file-1 ON ASCENDING/DESCENDING KEY key….
USING file-2
GIVING file-3.
USING can be substituted by INPUT PROCEDURE IS para-1 THRU para-2
GIVING can be substituted by OUTPUT PROCEDURE IS para-1 THRU para-2.
file-1 is the sort workfile and must be described using SD [...]
Cobol Interview Questions 2008-04-01 10:17:41 1. Name the divisions in a COBOL program?
a.IDENTIFICATION DIVISION
b.ENVIRONMENT DIVISION
c.DATA DIVISION
d.PROCEDURE DIVISION.
2. What are the different data types available in COBOL?
Alpha-numeric (X),
alphabetic (A)
numeric (9).
3. What does the INITIALIZE verb do?
Alphabetic, Alphanumeric fields & alphanumeric edited items are set to SPACES.
Numeric, Numeric edited items set to ZERO.
FILLER , OCCURS DEPENDING ON items left untouched.
4. What is [...]
30 Best Java Interview Questions 2008-07-29 11:42:54 Q1. How could Java classes direct program messages to the system console, but error messages, say to a file?
A. The class System has a variable out that represents the standard output, and the variable err that represents the standard error device. By default, they both point at the system console. This how the standard output [...]
Sample Networking Informational Interview Questions 2008-08-06 12:02:49 1. I have so many interests. How does one with a liberal arts education and diverse interests plan a career? What positions are good entry-level opportunities?
2. How will a liberal arts degree be an advantage in the world of work?
3. What are the benefits of a liberal arts degree in the short-term and long-term regarding [...] Read more:Sample
Recommend Site To A Friend
