Databases Interview Questions
Questions Answers Views Company eMail

why should required for Indexed by table in pl/sql

3 4698

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

IBM,

8 5570

What is the difference between Outer join and Full outer join?

5 32495




how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

ADP, Satyam, Tech Mahindra,

7 7914

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Wipro,

5 7216

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 2765

what is vlook up in ms excel and how does it used???

CybAge,

1 3850

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 1590

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 2722

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 2426

what is package and it uses and how can u call a package

Satyam,

948

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

TCS,

3 7015

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

UST,

11 11343

how to insert data into partitioned table partition done by Range partition

1 13172

What different of iner joint & outer joint with example

4 6755







Un-Answered Questions { Databases }

Write about Transaction Management in Oracle 9i?

998


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

922


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1085


Delete duplicate rows without using rowid.

248


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

659






A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

2662


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

2493


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

904


Does any body please help me what question's have asked for SSRS in the interview?

960


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

868


can we delete autodiff back up that we have set through sql server agent.

1140


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

926


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1025


PostgreSql Disadvantages

676


What are the character types that are available in postgresql?

422