Databases Interview Questions
Questions Answers Views Company eMail

why should required for Indexed by table in pl/sql

3 4779

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 5655

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

5 32811




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

Satyam, ADP, Tech Mahindra,

7 8056

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

Wipro,

5 7288

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 2846

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

CybAge,

1 3909

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 1625

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

1 2779

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

2 2470

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

Satyam,

977

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 7064

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 11495

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

1 13323

What different of iner joint & outer joint with example

4 6818







Un-Answered Questions { Databases }

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....

937


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3097


last function used in MS Access to convert sql what function will use in sql

940


What is the command that can be used to allocate memory in postgreSQL?

412


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

990






Query processing is slow(eg select query)how will u solve that

4766


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

1845


How to start SQL Server in minimal configuration mode?

5317


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1275


Why do you want to join software field as you have done your BE in Electronics?

1105


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2081


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2265


how to solve cardinality in dbms...many to many ralationships

707


did u p prepared complex report

970


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

871