-
What kind of a query is this? How does it work?
Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help. select ename,(select dname from dept where deptno=e.deptno) from emp e;
-
Reverse a string in Oracle without using reverse
How do I reverse a dtring in Oracle without using PL/SQl and without using the reverse function??
-
-
3 way join
Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...
-
3 Way join with different column names.
Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...
-
Can we replace where clause by having clause. ?
interviewer ask.. can we replace where clause by group by clause let say select * from table_name where some_condition so how we replace where clause by group by clause
-
Oracle exception block
In the exception part,what will happen if u don’t give (when others) where will it show error compile time or run time
-
cube painted problem
A solid cube is painted black on two of its opposite faces and is cut into 343 pieces. how many small pieces have no paint??
-
Aptitude - How many 3s are used in numbering these buildings?
The citizens of planet nigiet are 8 fingered and have thus developed their decimal system in base 8. A certain street in nigiet contains 1000 (in base 8 buildings numbered 1 to 1000. How many 3s are used in numbering these buildings? The citizens of planet nigiet are 8 fingered and have thus developed their decimal system in base 8. Acertain street in nigiet contains 1000 (in base 8 buildings numbered...
-
Get 10 and 11th records in the output using SQL in 5 ways ?
I have to tables A and B. My records in this table are in such a way that Table A Table B 10 15 11 16 12 10 13 11 Question :- I want only the 10 and 11 records as my output. Can anyone help me out ( 5 ways to get this output )
-
Aptitude Question - Find the place
In Mulund, the shoe store is closed every Monday, the boutique is closed every Tuesday, the grocery store is closed every Thursday and the bank is open only on Monday, Wednesday and Friday. Everything is closed on Sunday. One day A, B, C and D went shopping together, each with a different place to go. They made the following statements: A D and I wanted to go earlier in the week but there wasn’t...
-
How can I get recent 10 records out of 100 records
HI all table contain some 1000 records, today I inserted 100 records into table, so I want first 10 records data from 100 records how can I retrieve
-
write a program to find no. of cats
a no. of cats got together and decided to kill between them 99919 mice. every cat kills equal no. of mice. write a program to find no. of cats
-
Quantity Aptitude Question
A mixture of 50 litres of milk and water contain 10% of water. How much water must be added to make water 20% in the given mixture?
-
Cube Questions
A cube has a side of 4cm.b The cube is painted red on all six side. This cube is then cut into 125 smaller cubes. How many of these smaller cubes will have only one side of their sides painted.
-
Cutting Cake analysis
How can a cake be cut into 3 pieces in 2 steps with a knife?
-
Need VBA Coding
Within excel, what is the VBA coding to determine if the active cell has a comment assigned to it?
-
Missing letter
please give the missing letter of the following 5 6 _ 87 412 2185
-
Case and decode
can anyone help with a simple example of converting one from other like CASE to DECODE or DECODE to CASE.
-
Inner join and Outer join
what is the difference between inner join and outer join?
-
what is meant by ByVal and ByRef?
In passing variables to procedures and fuctions, what is meant by "ByVal" and "ByRef"? Is there ever an exception to the standard definition for these? This is a question you will most likely get in any Visual Basic interview.
-
what is the qualifying mark?
A and B are shooters and having their exam. A and B fall short of 10 and 2 shots respectively to the qualifying mark. If each of them fired atleast one shot and even by adding their total score together, they fall short of the qualifying mark, what is the qualifying mark?
-
how many cubes have colors on two sides.
cube has colors blue, red ,yellow each on two opposite sides. cube is divided into "32 small cubes and 4 large cubes". question: how many cubes (on 36 cubes) have blue at least one side. how many cubes have colors on two sides.
-
Form 8 Digit Numbers
Form 8 digit numbers by using 1,2,3,4,5 with repetition allowed and must be divisible by 4?
-
Exhibition Entry Ticket
Entry ticket to an exhibition ranges from 1p to 7p. You need to provide exact change at the counter. You have 7p coin. In how many parts will you divide 7p so that you will provide the exact change required and carry as less coins as possible?a) 8 b) 7 c) 5 d) 3
-
Motor Cycle Stunt
A motor cycle stunts man belonging to a fair, rides over the with vertical walls of a circular well at an average speed of 54 kph for 5 minutes. If the radius of the well is 5 meters then the distance travelled is :a) 2.5 kmsb) 3.5 kmsc) 4.5 kmsd) 5.5 kmse) None of the above
-
Find Address of Array Element
In a two-dimensional array, X (9, 7), with each element occupying 4 bytes of memory, with the address of the first element X (1, 1) is 3000, find the address of X (8, 5).
-
Questions Selection
There are 3 Sections with 5 questions each. If three questions are selected from each section, then in how many ways this selection can be done?
-
Prime Numbers
What is the probability of getting 2 prime nos. from 1 to 20?
-
lcm
LCM of x and y is 36 and HCF of x and y is 4. If x = 4 then which of the following is definitely not true?
-
-
-
-
-
-