Top Ten Oracle Interview Inquiry In Addition To Answer - Database In Addition To Sql
These are or thus interview interrogation together with reply asked during my recent interview. Oracle interview questions are real of import during whatever programming project interview. Interviewer e'er desire to cheque how comfortable nosotros are amongst whatever database either nosotros become for Java developer seat or C, C++ programmer seat .So hither I direct maintain discussed or thus basic interrogation related amongst oracle database. Apart from these questions which is real specific to Oracle database you lot may abide by or thus full general questions related to database fundamentals together with SQL e.g. Difference betwixt correlated together with noncorrelated subquery inward database or truncate vs delete inward SQL etc. Some of the most of import topics inward Oracle Interview questions are SQL, date, inbuilt function, stored physical care for together with less used features similar cursor, trigger together with views. These questions also gives an thought most formats of questions asked during Oracle Interview.
Oracle Interview Question together with 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 liberate number
- 2-Database Maintenance liberate number
- 0-Application server liberate number
- 4-Component Specific liberate number
- 0-Platform specific liberate number
Question 2: How create you lot abide by electrical flow appointment together with fourth dimension inward oracle?
Answer: This is 1 of the often asked Oracle Interview questions. I direct maintain seen this interrogation every right away together with then. By the agency SYSDATE function is used inward oracle to abide by electrical flow appointment together with fourth dimension of operating organisation on which the database is running render type of business office is DATE
Syntax: SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "Current_Date" FROM DUAL.
Question 3: Write the syntax to abide by electrical flow appointment together with fourth dimension inward 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 inward Oracle hand 1 example
Answer : Similar to previous Oracle Interview question, this is also 1 of the pop interrogation inward diverse Oracle Interviews. to_char() business office is used to convert appointment to grapheme nosotros tin specify format also inward 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 inward oracle?
Answer: BCP or volume re-create tool is 1 type of ascendence trace tool for unload information from database came into being afterwards oracle 8 .it is used to import or export information from tables together with views but it volition non re-create construction of information same. Main payoff is fast machinery for copying information together with nosotros tin accept backup of of import information easily.
Question 6: What are the extensions used past times oracle reports
Answer : Oracle reports are used to brand trace of piece of employment organisation enable to supply information of all grade inside or exterior inward secure way. REP file together with RDF file extensions are used past times oracle report.
Question 7: What is Save Points inward Oracle database?
Answer : SAVE POINTS are used to split upwardly a transaction into smaller parts. It enables rolling dorsum part of a transaction. Maximum of 5 relieve points are allowed. Whenever nosotros run into fault nosotros tin rollback from the indicate where nosotros laid our SAVEPOINT.This is useful for multistage transaction together with conditional transaction where commit together with rollback depend on for sure condition. This is or thus other commonly asked Oracle Interview Question together with since relieve points are also available inward other database e.g. SQL Server, or thus fourth dimension Interviewer follow upwardly amongst differences amongst other database every bit well. Question 8: How volition you lot convert string to a appointment inward oracle database?
Answer : This Oracle Interview questions is or thus fourth dimension asked every bit follow upwardly of previous Oracle Interview questions related to converting appointment to char inward Oracle. By the way to_ date business office 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 inward Oracle?
Answer : This is 1 of my favorite Oracle Interview question. Hash cluster is 1 of the techniques to shop the tabular array inward a hash cluster to better the functioning of information retrieval .we apply hash business office on the tabular array row’s cluster key value together with shop inward 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 business office to the row's cluster key value.
Question 10: What is Snap shot inward 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 together with answers. This tin locomote a adept recap earlier appearing to whatever programming project interview, where questions from Oracle database is expected. You may desire to prepare or thus SQL Interview interrogation every bit good along amongst these Oracle questions, every bit questions related to SQL query e.g. How to abide by minute highest salary inward SQL or How to abide by duplicate records inward table is quite pop on diverse Oracle Interviews.
Further Learning
Difference betwixt sentiment together with materialized sentiment inward SQL
0 Response to "Top Ten Oracle Interview Inquiry In Addition To Answer - Database In Addition To Sql"
Post a Comment