Databases Interview Questions
Questions Answers Views Company eMail

why should required for Indexed by table in pl/sql

3 4646

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 5519

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

5 32329




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 7855

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

Wipro,

5 7177

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 2718

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

CybAge,

1 3806

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 1566

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

1 2686

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

2 2397

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

Satyam,

933

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 6983

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 11245

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

1 13089

What different of iner joint & outer joint with example

4 6709







Un-Answered Questions { Databases }

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

847


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1388


How many number of columns can a RECORD GROUP have ?

939


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

954


What is snapshot is too old? Give and example for better understand.

445






What are the Roles and responsibilities of database administrator?

1481


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

619


as a technical developer in oracle applications which type errors feced in your experience sofar

1050


what is checksum in sql server.........???

432


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

2899


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1028


What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

332


how do u setup a replication site?

801


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.

2627


how many no of arguments can be passed in procedures and functions

3559