adspace


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example

 2 16148

how will i became good database developer?

 1 3223

• What is oracle Architecture?

 3 6652

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

 3 4580

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1 2211

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

 2 5198

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

 2 6193

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

 1 4481

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

 2 5064

How can u find column name from a table which have max value in a row.( not max value)

 5 8040

Temporary table vs Table variable in sql server?

Wipro,

2478

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

Amazon, HCL,

3 8988

how to hide the scroll bar in forms 6i

 2 13687

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

Mind Tree, Polaris, Sonata,

10 16906

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

 1 3580

Un-Answered Questions { Databases }

How to write a left outer join with the where clause in oracle?

1164

Can one drop a column from a table?

1101

What is sql or structured query language?

1239

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1140

what are all the common sql function? : Sql dba

1146

Is primary key clustered index?

1029

Any work done in oracle workflow builder. Did you customize or build a new workflow?

60

How do I create a trace in sql server?

1129

How to convert character strings into numeric values?

1203

what is the difference between openrowset and openquery?

1213

What is a coalesce function?

1295

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1225

What are the properties of the transaction?

1088

what is the age limit for groups1 examination

2358

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2110

For More Un-Answered { Databases } Questions Click Here