Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 6093

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 3203

how can create the lexical parameter after the select class?

Oracle,

1 5277

Explain prerequisites and post activities of oracle database installation

2136

Why required to run root.sh at the time of installation and what exactly it will do

1 5108

How to clone the database using RMAN back

2244

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2225

what is candidate key & primary key,different b/t the two?

3 5929

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 4709

Un-Answered Questions { Databases }

How can you change the name of any existing table by using the sql statement?

1001

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944

Why do we need object libraries?

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

994

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1401

What are the results of running this script?

933

How to delete all rows a table in oracle?

1068

How to assign values to variables?

1108

What is default value database?

1015

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to improve query performance using index hunting?

1177

How many number of columns can a RECORD GROUP have ?

2028

What do we need queues in sql service broker?

1066

How can you find out how many users are currently logged into the database? How can you find their operating system id?

544

What is trigger and types?

1030

For More Un-Answered { Databases } Questions Click Here