Top X Oracle Interview Query As Well As Response - Database As Well As Sql
Friday, June 1, 2018
Add Comment
These are only about interview query together with respond asked during my recent interview. Oracle interview questions are rattling of import during whatsoever programming undertaking interview. Interviewer ever desire to banking enterprise jibe how comfortable nosotros are amongst whatsoever database either nosotros become for Java developer seat or C, C++ programmer seat .So hither I stimulate got discussed only about basic query related amongst oracle database. Apart from these questions which is rattling specific to Oracle database you lot may honour only about 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 close 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 free number
- 2-Database Maintenance free number
- 0-Application server free number
- 4-Component Specific free number
- 0-Platform specific free number
Question 2: How create you lot honour electrical current engagement together with fourth dimension inward oracle?
Answer: This is i of the often asked Oracle Interview questions. I stimulate got seen this query every straight off together with then. By the agency SYSDATE function is used inward oracle to honour electrical current engagement together with fourth dimension of operating organisation on which the database is running render type of constituent is DATE
Syntax: SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "Current_Date" FROM DUAL.
Question 3: Write the syntax to honour electrical current engagement 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 engagement to char inward Oracle plow over i example
Answer : Similar to previous Oracle Interview question, this is also i of the pop query inward diverse Oracle Interviews. to_char() constituent is used to convert engagement to grapheme nosotros tin plow over the axe 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 i type of ascendency describe tool for unload information from database came into beingness 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 wages is fast machinery for copying information together with nosotros tin plow over the axe accept backup of of import information easily.
Question 6: What are the extensions used yesteryear oracle reports
Answer : Oracle reports are used to brand trouble concern enable to render information of all degree inside or exterior inward secure way. REP file together with RDF file extensions are used yesteryear oracle report.
Question 7: What is Save Points inward Oracle database?
Answer : SAVE POINTS are used to split a transaction into smaller parts. It enables rolling dorsum constituent of a transaction. Maximum of 5 salve points are allowed. Whenever nosotros come across mistake nosotros tin plow over the axe rollback from the betoken where nosotros laid our SAVEPOINT.This is useful for multistage transaction together with conditional transaction where commit together with rollback depend on for certain condition. This is only about other commonly asked Oracle Interview Question together with since salve points are also available inward other database e.g. SQL Server, only about fourth dimension Interviewer follow upwards amongst differences amongst other database every bit well. Question 8: How volition you lot convert string to a engagement inward oracle database?
Answer : This Oracle Interview questions is only about fourth dimension asked every bit follow upwards of previous Oracle Interview questions related to converting engagement to char inward Oracle. By the way to_ date constituent is used to convert string to a engagement 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 i of my favorite Oracle Interview question. Hash cluster is i of the techniques to shop the tabular array inward a hash cluster to amend the surgical operation of information retrieval .we apply hash constituent 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 constituent to the row's cluster key value.
Question 10: What is Snap shot inward Oracle database?
Answer : Snapshots are read-only copies of a primary tabular array located on a remote node which is periodically refreshed to reverberate changes made to the primary table.
That’s all on this listing of Oracle Interview questions together with answers. This tin plow over the axe live on a practiced recap earlier appearing to whatsoever programming undertaking interview, where questions from Oracle database is expected. You may desire to fix only about SQL Interview query every bit good along amongst these Oracle questions, every bit questions related to SQL query e.g. How to honour minute highest salary inward SQL or How to honour duplicate records inward table is quite pop on diverse Oracle Interviews.
Further Learning
Difference betwixt persuasion together with materialized persuasion inward SQL
0 Response to "Top X Oracle Interview Query As Well As Response - Database As Well As Sql"
Post a Comment