Blog Detail

oracle interview questions and answers

oracle interview questions and answers

http://oracle-interview.blogspot.com

Best oracle interview questions and answers

subscribe Recent Posts

  • Part - 1 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:38

    Question: 1.(A)Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?A. SELECT DISTINCT position, managerFROM employee;B. SELECT position, manager DISTINCTFROM empl...

  • Part - 2 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:37

    Question: 11. (A) The CUSTOMERS table has these columns: CUSTOMER_ID | NUMBER(4) | NOT NULL CUSTOMER_NAME | VARCHAR2(100) | NOT NULL STREET_ADDRESS | VARCHAR2(150) | CITY_ADDRESS | VARCHAR2(50) | STATE_ADDRESS | VARCHAR2(50) | PROVINCE_ADDRESS | ...

  • Part - 3 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:36

    Question: 21.(B) Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) Which statement lists the ID, name, and salary of the employee, and the ID and name o...

  • Part - 4 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:35

    Question: 31. (B) You query the database with this SQL statement: SELECT bonus FROM salary WHERE bonus BETWEEN 1 AND 250 OR (bonus IN(190, 500, 600) AND bonus BETWEEN 250 AND 500); Which value could the statement return? A. 100 B. 260 C. 400 D. ...

  • Part - 5 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:34

    Question: 41. (C) Management has asked you to calculate the value 12*salary* comossion_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns f...

  • Part - 6 Oracle Interview

    Posted on Saturday November 15th, 2008 at 02:33

    Question: 51. (C) Examine the structures of the PATIENT, PHYSICIAN, and ADMISSION tables. PATIENT Table Which SQL statement will produce a list of all patients who have more than one physician? A. SELECT p.patient_id FROM patient p WHERE ...

Comments & Reviews

This blog is currently rated a 5.00 out of a possible 5 based on 3 comments.

jobsitebd

5 stars Wahid Zaman

Hi,

This is a very good blog & very informative about Education.

You can find valuable resources for Education, jobs, career, sample resume, Interview Tips, HR Resources and study resources from my sites & blog.

http://www.jobsitebd.com

http://jobsitebd.wordpress.com

http://jobsitebdcareer.blogspot.com


Hope you will also visit my sites.

Thanks

Zaman

Posted: September 27th, 2009 | More Reviews From jobsitebd | Report This Comment

5 stars Wasim

Thank you all for your valuable inputs.

Posted: September 12th, 2009 | Report This Comment

5 stars SIPPY

Best Resources

Real interview questions

www.oraclepassport.com

Posted: January 28th, 2009 | Report This Comment

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.

Name: or Login
E-mail:
Rating:
Verify: Spam Protection: sum of 3 + 3
Comment:
  Remember Information
 
  •  

  • Rate This Blog

  • Related Blogs

  • view moreRecent Viewers

    • jobsitebd