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


Databases Interview Questions
Questions Answers Views Company eMail

why should required for Indexed by table in pl/sql

 3 6540

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 8727

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

 5 38203

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 11892

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

Wipro,

5 9837

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 4224

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

CybAge,

1 4997

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 2430

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

 1 3828

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

 2 3598

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

Satyam,

1559

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 8707

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 15827

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

 1 14689

What different of iner joint & outer joint with example

 4 8611

Un-Answered Questions { Databases }

Is it possible to include an insert statement on the same table to which the trigger is assigned?

561

What is side by side migration in sql server?

538

What is compound operators?

551

How to write pl sql program in mysql command prompt?

519

What are the oracle built-in data types?

563




Explain the use of constraints option in exp command.

564

Is pl sql a programming language?

550

What is a Database system?

518

How do I run mysql on a mac?

478

Is mongodb single threaded?

1

Does insert statement lock the table?

509

How do you autonumber in access?

421

How does stored procedure reduce network traffic?

546

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

621

What are the triggers associated with image items?

619

For More Un-Answered { Databases } Questions Click Here