Oracle Interview Questions
- 2of 2 votes
AnswersYou have one table with a single column having three values a,b and c.
- Black Stallion July 26, 2012 in India
Current snapshot of the table is
Table :- tblTest
Values :-
tblColumn
a
a
a
b
b
b
b
c
c
We need and output in SQL Server in the format:-
Acount BCount CCount
3 4 2
Do not use temporarytable/variables/multiple queries in a single query.
Values are restricted to be a, b and c only but the count may vary and output will change accordingly.| Report Duplicate | Flag | PURGE
Oracle Applications Developer Database - 0of 0 votes
AnswersSelect the option that denotes, "runtime is proportional to five times the input size".
- sushilk.1991 July 19, 2012 in India
O(n5)
5O(n)
5*O(n)
O(5n)| Report Duplicate | Flag | PURGE
Oracle - 1of 1 vote
AnswersQuestion Number 1
- sushilk.1991 July 19, 2012 in India
Consider a table "Student" consisting of columns (Student ID, Student Address, Course).
Every student is allowed to enroll in multiple courses and every course is allowed to enroll more than one student. Also every time a student changes address, all his relevant records must be changed to reflect the new address.
What would be the Normal form required to avoid this redundancy?
2nd NF
4th NF
3rd NF
1st NF| Report Duplicate | Flag | PURGE
Oracle Database - 0of 0 votes
Answer1.Explain Memory dumps in java
- sujita July 06, 2012 in India for GGN| Report Duplicate | Flag | PURGE
Oracle Site Reliability Engineer - 0of 0 votes
AnswersDesign/implement a Hashset class of your own.
- sujita July 06, 2012 in India for GGN| Report Duplicate | Flag | PURGE
Oracle Site Reliability Engineer Algorithm - 0of 0 votes
Answers1.sort array {0,1,1,0,1,0,1,0,0,1,1,1,0} of binary numbers in O(n) time complexity using property of binary numbers.(no counting here)
- sujita July 06, 2012 in India for GGN| Report Duplicate | Flag | PURGE
Oracle Labs247 Quality Assurance Engineer Site Reliability Engineer Arrays - 0of 0 votes
Answers1.Design one/two player tic-tac-toe,using Java.
- sujita July 06, 2012 in India for GGN| Report Duplicate | Flag | PURGE
Oracle Site Reliability Engineer Algorithm - 0of 0 votes
Answers1.Design a vending machine in java.takes coins of 2,3,7 ,using JAVA
- sujita July 06, 2012 in India for GGN| Report Duplicate | Flag | PURGE
Oracle Site Reliability Engineer Algorithm - 0of 0 votes
Answers
- sujita July 04, 2012 in India for noida1.Design a vending machine in java.takes coins of 2,3,7,JAVA 2.Design one/two player tic-tac-toe,Java. 3.sort array {0,1,1,0,1,0,1,0,0,1,1,1,0} of binary numbers in O(n) time complexity using property of binary numbers.(no counting here) 4.Design/implement a Hashset class of your own. 5.Memory dumps in java ....................................................................................
| Report Duplicate | Flag | PURGE
Oracle Site Reliability Engineer Java - 0of 0 votes
Answerswrite a program to take a no. as input and generate the output in the form of LED display.
- bjain May 22, 2012 in United States
eg. if input in 102 op
__ __
| | | __|
| |_ | |__
|| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer - 0of 0 votes
AnswersDesign a structure for a student record which has following 3 fields-
- rising April 14, 2012 in India
ID - integer value
Name - String
either a grade - which is float value OR rank - which is integer value.
Also write a function to print the details of a student record such that if the student is given grade it must be printed as float value but if he is given rank then it must be printed as integer value.| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer C - 0of 0 votes
AnswersWrite a function in C to efficiently copy 1 file to another.
- rising April 14, 2012 in India| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer C - 0of 0 votes
AnswersA node of a binary tree has two pointers left and right and two data fields- left count and right count. left count specifies the number of nodes in left of the node and right specifies the number of nodes in right of the node. Write an algorithm to populate the data fields of all the nodes of the tree.
- rising April 14, 2012 in India| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Data Structures - 1of 1 vote
AnswersHow to find min-weight (coin) in a given set of '10' distinct weights (coins) in minimum number of weighing's if provided with a balance. (no labels shown on coin resembling the weight). Generalize for 'n' distinct weights.
- praveenb.mails March 17, 2012 in India| Report Duplicate | Flag | PURGE
Oracle Java Developer Brain Teasers - 0of 0 votes
AnswersCan you give the syntax to print the date time in C#
- divya March 14, 2012 in United States for Java Developers| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer C# - 0of 0 votes
AnswersGeneral question: If you are provided with 8 balls with one among them heavier than remaining . You have a weighing balance. in how many measures can u identify the heavier ball.
- divya March 14, 2012 in United States for Java Developers| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Brain Teasers - 0of 0 votes
Answersyou have a 5 liter and a 3 liter jars. You can use any amount of water. Shouldnt use any other jars or containers. How can you get exact 4 liters of water?
- divya March 14, 2012 in United States for Java Developers| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Brain Teasers - 0of 0 votes
AnswersFrom the following options, select a statement that is NOT true about immutable objects.
- balaaaji140 January 06, 2012 in India
You can use immutable objects in multi-threaded programs
You can use a pointer to create a reference copy of an immutable object, instead of creating a copy of the object
Immutable objects cannot be modified after they are created
An object has to be completely mutable or immutable but partial immutability is not very useful in programs| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Object Oriented Design - 0of 0 votes
AnswersFrom the following options, select the OOP mechanism, that allows treatment of the derived class members just like the members of their parent class.
- jarvisalbert January 04, 2012 in India
Abstraction
Polymorphism
Decoupling
Encapsulation| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Object Oriented Design - 0of 0 votes
AnswersYou have two relation variables: RelV1 and RelV2. They are NOT necessarily distinct. You
- jarvisalbert January 04, 2012 in India
have a set K as a key for RelV1. Consider that FK is a subset of the heading of RelV2 that
involves exactly the same attributes as K.
From the following options, select the option that correctly depicts a scenario where FK can be
considered as a foreign key.
-Every tuple in RelV1 has a K value that is equal to the FK value in some tuple in RelV2
-Every tuple in RelV1 has a FK value that is equal to the K value in some tuple in RelV2
-Every tuple in RelV2 has a K value that is equal to the FK value in some tuple in RelV1
-Every tuple in RelV2 has a FK value that is equal to the K value in some tuple in RelV1| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Database - 0of 0 votes
AnswersSelect the option that correctly describes the database replication concept where two or more
- jarvisalbert January 04, 2012 in India
replicas synchronize each other through a transaction identifier.
-Quorum
-Multimasterslave
-Master-Slave
-Multimaster| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Database - 0of 0 votes
AnswersSuppose you have the following code:
void InsertNode(tNode** node, int i){ if(*node == NULL){ *node = new tNode; (*node)->pLeft = NULL; (*node)->data = i; (*node)->pRight = NULL; SetRootNode(node); return; } else { if(i < (*node)->data) InsertNode(&((*node)->pLeft), i); if(i > (*node)->data) InsertNode(&((*node)->pRight), i); return; } } void Func(tNode **node){ if(*node!=NULL){ Func(&(*node)->pLeft); tNode *temp; temp = (*node)->pLeft; (*node)->pLeft= (*node)->pRight; (*node)->pRight = temp; Func(&(*node)->pRight); } } void traverse(tNode** nd){ if(*nd!=NULL){ traverse(&((*nd)->pLeft)); traverse(&((*nd)->pRight)); std::cout<<(*nd)->data<<std::endl; } }
Let the input given be
98,15,100,10,78,120,5,12,96,110
What would be the output of the following code snippet?int main(void) { tree *bT = new tree; int i = 10; int data; while(i--){ std::cout<<"Enter the node"<<std::endl; std::cin>>data; bT->InsertNode(bT->GetRootNode(), data); } bT->Func(bT->GetRootNode()); bT->InsertNode(bT->GetRootNode(), 99); bT->Func(bT->GetRootNode()); bT->traverse(bT->GetRootNode()); }
Options
- jarvisalbert January 04, 2012 in United States
-5,10,12,15,78,96,98,99,100,1
10,120
-5,12,10,99,96,78,15,110,120,
100,98
-5,10,12,15,78,96,99,98,100,1
10,120
-98,100,120,110,15,78,96,99,1
0,12,5| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Algorithm - 0of 0 votes
AnswersI was asked to design a data structure for a phone address book with 3 fields
- Raj August 21, 2011
name, phone number , address
one must be able to search this phone book on any of the 3 fields .| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Data Structures - 0of 0 votes
AnswersSelect the option that represents the definition of network database model.
- ankit July 14, 2011
Attempts to bring closer interactivity between database administrators and application programmers
Represents the entire information content of the database in only one way
Organizes the data in the form of a tree of records, with each record having one parent record and many children records
Allows each record to have multiple parent and child records, thereby forming a lattice structure| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 1of 1 vote
AnswersWhich one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?
- ankit July 14, 2011
Updating the value of DEPT in a row of EMPLOYEE with a value that is not the primary key of any of the rows in DEPARTMENT
Inserting a new row into DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE
Deleting a row of DEPARTMENT
Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
AnswersAn organization stores its employee records in a table, “Emp”. This table has various attributes such as First Name, Last Name, Designation and Salary. The organization stores details of the employee's children in another table, “EmpChildren”. The EmpChildren table has attributes like First Name, Last Name, and Birth Date. The Emp table is a parent table and EmpChildren table is a child table. An employee may have many children, but each child will have only one parent.
- ankit July 14, 2011
From the following options, select the type of database model depicted by the above scenario.
Relational model
Network model
Hierarchical model
Object database mode| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
Answerdiscuss the client-server architecture?
- ankitchauhan2065 December 18, 2010| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer Networking / Web / Internet - 0of 0 votes
Answerswhat is cluster in dbms?
- Anonymous September 18, 2010| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer - 0of 0 votes
Answerswrite your own ArrayList in Java ?
- guest123 August 26, 2010| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Java - 0of 0 votes
AnswersHow to divide a number by 3 without using *, /, +, %, - operators... ??
- Anonymous August 08, 2010| Report Duplicate | Flag | PURGE
Oracle Software Engineer / Developer