-
DATATYPES
1-WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?2-WHAT IS THE USE OF UROWID?3-WHAT ARE THE SUBTYPES?GIVE ANY 2 EXAMPLE?4- WHAT IS THE GENERAL STANDARD FOR DECLARATION?
-
Exact Time
A clock was set right at 5 am then it loses 16 minutes every day, on the 4th day when it shows 10 am, What is the exact time?
-
What is the Amount Paid?
A, B, C, D went to a hotel and planned to share the bill equally. But afterwards they changed their plan and to pay proportional to consumption A paid 240, B & C paid equally, D paid only half the amount that he should have paid based on the first plan. What is the amount paid by B?
-
Value of A
A costs 1/10 more than 1/4 the price of B. A+B=300,000, what is the value of A?
-
Local Time of Landing
An aircraft takes off from A (89o N Lat, 10o E Long) at 2.00 AM local time to B (32o N Lat, 70o W Long). If the flying time is 10 hours what is the local time of landing at B?(a) 5.40 AM (b) 4.00 AM (c) 6.40 AM (d) 7.00AM (e) 8.00AM
-
Remove Primary Key
What happens if we remove primary key from SQL table?
-
C Program
What is the output of the following code - What is the output of the following code int i=7;printf("%d", i++ * i++);
-
Select from table without using column name
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer
-
-
Oracle Career Advice
Hi I am prerna.I am in 2nd year of MCA.Right now I am taking training in Oracle DBA.Besides I am learning Java too.I am confused about freshers jobs.Will companies considers freshers.What steps should I take to increase my chances of jobs.Please help?
-
directions
A moves 3kmseast from starting point.he then travels 5kms from north.from that point he moves 8kms to the east.how far is A from his starting point?
-
Find second lowest salary from emp table
display the second lowest salary from emp table without using min & all
-
-
how many 9 digit no.s are divisible by 7
a.1256b.1986c.1524d.1874
-
-
-
-
There are 45 members in a group. 9 members have shoes but no hats. 18 members have shoes. How many members are there who have only hats? a)12 b) 19 c) 27 d) 18
d)18.no. of members who have both hats and shoes=18 - 9 = 9no. of members who have hats = 45 - 18 = 27no. of members who have hats only hats = 27 - 9 = 18.
-
Delete distinct name from table
How could i delete the distinct name from the table. the rest record would be available as it is in the table?
-
-
How do you subtract two columns in oracle database
How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime column senttime column?
-
Deleting duplicate records in a table without using rowid
1. How to delete a duplicate records in a table without using rowid? 2. What is the use of Connect by clause? 3. What is the use of Connect by clause? 4. How to display "Experience of employee"?E.g. 3 years 4 months 19 days? 5. What is select statement to spe?
-
-
-
-
TCS Interview Question
(1- 1/6) (1-1/7).... (1- (1/ (n+4))) (1-(1/ (n+5))) = ?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
-
What is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
-
Two pencils costs 8 cents, then 5 pencils cost how much ?
2 pencils = 8 cents => 1 pencil = 4 cents. Therefore 5 pencils cost = 5 * 4 = 20 cents