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 6205

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 3288

how can create the lexical parameter after the select class?

Oracle,

1 5356

Explain prerequisites and post activities of oracle database installation

2185

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

1 5188

How to clone the database using RMAN back

2321

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?

2303

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

3 6116

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 4814

Un-Answered Questions { Databases }

Explain what is the use of custom fields in report?

961

How to get a list of all background sessions in the database?

1047

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2157

How to display the current date in sql?

1131

What is advantage data architect?

979

what is the difference between substr and instr function in oracle?

1145

What is acid mean in sql server?

1207

How do I find my localdb version?

1034

What is break?

1263

Why neo4j is used?

What is blob data type in oracle?

1210

The select into statement is most often used to create backup copies of tables or for archiving records?

1124

What is the difference between mdf and ndf files?

1164

what data regions are and what are the different data regions?

146

how do you do sql tuning?

2149

For More Un-Answered { Databases } Questions Click Here