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 6212

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 5359

Explain prerequisites and post activities of oracle database installation

2188

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

1 5192

How to clone the database using RMAN back

2326

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?

2310

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

3 6118

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 4824

Un-Answered Questions { Databases }

What are the three types of databases?

986

Why normalisation is required?

1017

What is the difference between in and between in sql?

1111

What are programming functions?

1004

How many rows can be inserted in mysql at a time?

1070

How do you concatenate strings in mysql?

1056

All questions related to Control m monitoring tool

2607

What is the difference between internal and external schema?

972

How many types of database language exist?

1113

Which should I use, repagent or ltm in sybase?

1031

What is pl sql script?

1091

Define the "integrity rules"?

872

What's the difference between inner join and left join?

1042

How to define a sub function?

1206

What is required to create mysql database?

1039

For More Un-Answered { Databases } Questions Click Here