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 6509

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 8689

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

 5 38136

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 11847

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

Wipro,

5 9773

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 4202

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

CybAge,

1 4982

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 2417

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

 1 3820

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

 2 3579

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

Satyam,

1552

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 8686

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 15756

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

 1 14671

What different of iner joint & outer joint with example

 4 8574

Un-Answered Questions { Databases }

What are synonyms?

518

How is indexing done in search engines?

521

What are unicode character string data types in ms sql server?

591

Where are SQL server users names and passwords are stored in sql server?

706

What is the dbcc command and why is it used?

560




What are indexes in oracle?

624

What is snowflake sql?

568

What is a linked server in sql server?

567

Is microsoft access available in office 365?

488

What is Restricted Mode of Instance Startup in Oracle?

667

How to see table's field formats or description of table .

444

How to connect of datebase with sql express.?

618

How many rows can postgres handle?

442

What is sp_helptext?

580

What is the non-clustered index in sql?

582

For More Un-Answered { Databases } Questions Click Here