.
  Vyom World.com . Let's Touch the Sky Together!  
.

Home
VyomWorld.com Home
Interview Questions
VyomLinks.com Home
JobsAssist.com Home
Vyom Network
Contact Us
Jobs & Careers
Resume Submitter
Placement Papers
IT Companies Directory
Computer Jobs
Interview Questions
Online Exams
Vyom Career eMag.
Fun
Send FREE SMS!
SMS Jokes
Source Codes Library
Source Codes Home
ASP Source Codes
C Source Codes
C++ Source Codes
COBOL Source Codes
Java Source Codes
Pascal Source Codes
Submit Source Codes
GATE
GATE an Overview
GATE Preparation
Study Materal
GRE
GRE an Overview
GRE Questions
GRE Preparation
GRE Universities
TOEFL Preparation
TOEFL Resources
GMAT Preparation
GMAT Resources
MBA Preparation
MBA Resources
Networking Concepts
Networking Concepts
Testing Preparation
Testing Resources
Webmasters
Free Traffic Builder
Webmaster Articles
Web Hosting
Tutorials
Hardware Tutorial
1500 Free eBooks New!
Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews





Interview Success Kit - Get Success in Job Interviews Interview Success Kit - 30,000 Interview Que. & Ans.


Home » Placement Papers » Oracle Placement Papers » Oracle Placement Paper 2nd AUGUST

New Click here to Download 2017 Latest placement papers of this company New


Oracle Placement Paper 2nd AUGUST


Advertisements
Advertisements

ORACLE PAPER ON 2nd AUGUST

Hi friends,...... Oracle has visited our campus. There were three rounds 2 Technical and 1 HR may be 3 Technical
And gone into the firstTechnical Round

There they asked me about my academics and courses that I have done.
They saw the Website competition in which i have won second prize
They said me to make the whole design of the Websites and how you selected the main points of the website
They may ask about the concept and code also

After that they asked about Next project
My project was Eshopping website
They told me to write the whole concept and the E-R diagram of the Database of the Website.
Then I explained about the Whole database.
They asked about The normalization, and cardinality, primary key, foreignkey.
They asked question about how i was managing users consistancy who logs into the website.
asked how data if flowing to different tables and why those tables needed.

Then next day I shortlisted for the next round....

HR round...(For HR u need good communication and Self confidence)
They were seeing my resume very carefully..
They asked about the academics..
Why so less marks in Graduation.
I gave them proper reason that i had.
What about your Family?
Why do you joined this college?
About the experience in the college?
As I have done a part time job also so they asked about that also what kind of work was that.
Asked about my favourite subjects.Then What grade do you give yourself in those subjects?
I said C, C++ ,DBMS and i grade myself as 7 out of 10.
They asked me about my school, and my city and state.
About me rank in competition that i have faced before getting admission to the college?
What options did i hav if i didn't got admission here?
i told about other exam in which i got good ranks.

Then She asked for the question from my side..

2nd Technical
They asked me about favourite subj or like to write query?
I said Query..
They gave me two queries.

1) A table ABC that has 3 columns
-ive are payments
description, amount, date
a -10000 30-08-07
b 12000 31-08-07
c 5000 31-08-07
a 15000 01-09-07
a 1200 01-09-07
b -2100 02-09-07
c -14000 03-09-07

I was asked to write a query to find receipt and payments for each day disply according to date
Date Receipt Payment

2) Data was given as
Empno salary deptno paydate
They asked about the primary key of this table.
Then they asked to write query
Find the empno, deptno of that employee who are getting second highest salary from last 3 months.
Next question was there can be more than 1 such employees.
Then they asked about academics and let me go
When I saw result I was placed.....

ASHISH TRIPATHI

 

New Click here to Download 2017 Latest placement papers of this company New




 


.

Recently Updated: New Placement Papers added.
Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Programming & Source Codes | GRE Preparation | Jobs, Discussions | Software Listing | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | International Business Information | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | FAQs | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Excellent Mobiles | Software Testing | Interview Questions | Freshers Jobs | Server Insiders | File Extension Directory

Copyright ©2003-2017 Vyom Technosoft Pvt. Ltd., All Rights Reserved. Read our Privacy Policy