These are approximately interview interrogation in addition to respond asked during my recent interview. Oracle interview questions are rattling of import during whatever programming chore interview. Interviewer ever desire to cheque how comfortable nosotros are amongst whatever database either nosotros larn for Java developer seat or C, C++ programmer seat .So hither I get got discussed approximately basic interrogation related amongst oracle database. Apart from these questions which is rattling specific to Oracle database you lot may detect approximately full general questions related to database fundamentals in addition to SQL e.g. Difference betwixt correlated in addition to noncorrelated subquery inwards database or truncate vs delete inwards SQL etc. Some of the most of import topics inwards Oracle Interview questions are SQL, date, inbuilt function, stored physical care for in addition to less used features similar cursor, trigger in addition to views. These questions also gives an thought close formats of questions asked during Oracle Interview.
Oracle Interview Question in addition to Answer
Question 1: Oracle version 9.2.0.4.0 what does each seat out refers to?
Answer : oracle version seat out refers
- 9-Major database unloosen number
- 2-Database Maintenance unloosen number
- 0-Application server unloosen number
- 4-Component Specific unloosen number
- 0-Platform specific unloosen number
Question 2: How create you lot detect electrical current appointment in addition to fourth dimension inwards oracle?
Answer: This is 1 of the ofttimes asked Oracle Interview questions. I get got seen this interrogation every directly in addition to then. By the means SYSDATE function is used inwards oracle to detect electrical current appointment in addition to fourth dimension of operating organization on which the database is running render type of role is DATE
Syntax: SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "Current_Date" FROM DUAL.
Question 3: Write the syntax to detect electrical current appointment in addition to fourth dimension inwards format “YYYY-MM-DD”.
Answer: SELECT TO_CHAR (SYSDATE, 'YYYY-MM-DD HH24:MI:SS') "Current_Date" FROM DUAL
Question 4: How volition you lot convert a appointment to char inwards Oracle reach 1 example
Answer : Similar to previous Oracle Interview question, this is also 1 of the pop interrogation inwards diverse Oracle Interviews. to_char() role is used to convert appointment to grapheme nosotros tin mail away specify format also inwards which nosotros desire the output.
SELECT to_char( to_date('11-01-2012', 'DD-MM-YYYY') , 'YYYY-MM-DD') FROM dual;
or
SELECT to_char( to_date('11-01-2012, 'DD-MM-YYYY') , 'DD-MM-YYYY') FROM dual;
Question 5: What is volume re-create or BCP inwards oracle?
Answer: BCP or volume re-create tool is 1 type of ascendence draw tool for unload information from database came into being afterward oracle 8 .it is used to import or export information from tables in addition to views but it volition non re-create construction of information same. Main wages is fast machinery for copying information in addition to nosotros tin mail away get got backup of of import information easily.
Question 6: What are the extensions used past times oracle reports
Answer : Oracle reports are used to brand trouble concern enable to render information of all degree inside or exterior inwards secure way. REP file in addition to RDF file extensions are used past times oracle report.
Question 7: What is Save Points inwards Oracle database?
Answer : SAVE POINTS are used to split a transaction into smaller parts. It enables rolling dorsum component subdivision of a transaction. Maximum of 5 salvage points are allowed. Whenever nosotros come across fault nosotros tin mail away rollback from the betoken where nosotros laid our SAVEPOINT.This is useful for multistage transaction in addition to conditional transaction where commit in addition to rollback depend on sure as shooting condition. This is approximately other commonly asked Oracle Interview Question in addition to since salvage points are also available inwards other database e.g. SQL Server, approximately fourth dimension Interviewer follow upward amongst differences amongst other database equally well. Question 8: How volition you lot convert string to a appointment inwards oracle database?
Answer : This Oracle Interview questions is approximately fourth dimension asked equally follow upward of previous Oracle Interview questions related to converting appointment to char inwards Oracle. By the way to_ date role is used to convert string to a appointment function.
Syntax : to_date(string, format)
Example: to_date('2012/06/12', 'yyyy/mm/dd') It volition render June 12, 2012
Question 9: What is hash cluster inwards Oracle?
Answer : This is 1 of my favorite Oracle Interview question. Hash cluster is 1 of the techniques to shop the tabular array inwards a hash cluster to meliorate the functioning of information retrieval .we apply hash role on the tabular array row’s cluster key value in addition to shop inwards the hash cluster. All rows amongst the same hash key value are stores together on disk.key value is same similar key of index cluster ,for information retrieval Oracle applies the hash role to the row's cluster key value.
Question 10: What is Snap shot inwards Oracle database?
Answer : Snapshots are read-only copies of a principal tabular array located on a remote node which is periodically refreshed to reverberate changes made to the principal table.
That’s all on this listing of Oracle Interview questions in addition to answers. This tin mail away hold upward a adept recap earlier appearing to whatever programming chore interview, where questions from Oracle database is expected. You may desire to gear upward approximately SQL Interview interrogation equally good along amongst these Oracle questions, equally questions related to SQL query e.g. How to detect mo highest salary inwards SQL or How to detect duplicate records inwards table is quite pop on diverse Oracle Interviews.
Further Learning
Difference betwixt stance in addition to materialized stance inwards SQL