Top X Oracle Interview Enquiry As Well As Response - Database As Well As Sql
These are approximately interview enquiry as well as reply asked during my recent interview. Oracle interview questions are really of import during whatever programming project interview. Interviewer ever desire to depository fiscal establishment tally how comfortable nosotros are amongst whatever database either nosotros become for Java developer seat or C, C++ programmer seat .So hither I conduct keep discussed approximately basic enquiry related amongst oracle database. Apart from these questions which is really specific to Oracle database you lot may notice approximately full general questions related to database fundamentals as well as SQL e.g. Difference betwixt correlated as well as 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 as well as less used features similar cursor, trigger as well as views. These questions also gives an thought well-nigh formats of questions asked during Oracle Interview.
Oracle Interview Question as well as Answer
Question 1: Oracle version 9.2.0.4.0 what does each divulge refers to?
Answer : oracle version divulge 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 notice electrical current appointment as well as fourth dimension inward oracle?
Answer: This is 1 of the oft asked Oracle Interview questions. I conduct keep seen this enquiry every similar a shot as well as then. By the agency SYSDATE function is used inward oracle to notice electrical current appointment as well as 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 notice electrical current appointment as well as 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 plough over 1 example
Answer : Similar to previous Oracle Interview question, this is also 1 of the pop enquiry inward diverse Oracle Interviews. to_char() business office is used to convert appointment to graphic symbol 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 mass re-create or BCP inward oracle?
Answer: BCP or mass re-create tool is 1 type of dominance job tool for unload information from database came into beingness afterwards oracle 8 .it is used to import or export information from tables as well as views but it volition non re-create construction of information same. Main wages is fast machinery for copying information as well as nosotros tin accept backup of of import information easily.
Question 6: What are the extensions used yesteryear oracle reports
Answer : Oracle reports are used to brand concern enable to supply information of all grade inside or exterior inward secure way. REP file as well as RDF file extensions are used yesteryear oracle report.
Question 7: What is Save Points inward Oracle database?
Answer : SAVE POINTS are used to split upward a transaction into smaller parts. It enables rolling dorsum part of a transaction. Maximum of v relieve points are allowed. Whenever nosotros catch mistake nosotros tin rollback from the signal where nosotros ready our SAVEPOINT.This is useful for multistage transaction as well as conditional transaction where commit as well as rollback depend on sure enough condition. This is approximately other commonly asked Oracle Interview Question as well as since relieve points are also available inward 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 inward 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 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 as well as 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 top dog tabular array located on a remote node which is periodically refreshed to reverberate changes made to the top dog table.
That’s all on this listing of Oracle Interview questions as well as answers. This tin endure a practiced recap earlier appearing to whatever programming project interview, where questions from Oracle database is expected. You may desire to create approximately SQL Interview enquiry equally good along amongst these Oracle questions, equally questions related to SQL query e.g. How to notice minute highest salary inward SQL or How to notice duplicate records inward table is quite pop on diverse Oracle Interviews.
Further Learning
Difference betwixt persuasion as well as materialized persuasion inward SQL
Belum ada Komentar untuk "Top X Oracle Interview Enquiry As Well As Response - Database As Well As Sql"
Posting Komentar