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

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 3628

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 5515

How many levels can subqueries be nested in a FROM clause?

7 26303

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

1 5270

what is the 4 types of validation

2 7571

How to get employee name from employee table which is the fiveth highest salary of the table

Infosys, Rolta,

20 30321

what is trigger . hw will it use them

TCS,

2 6489

How to remove a row in a database table?

IBM,

5 9064

How to retrieve 5th highest sal from emp table?

8 11965

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

IBM,

3 7296

Un-Answered Questions { Databases }

What are the different subsets of sql?

1642

Why should you use or avoid select * statements?

1103

Can one drop a column from a table?

1080

Does group by remove duplicates?

1106

What is current version of mysql?

1063

What is acid mean in sql server?

1230

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

How to use values from other tables in update statements using oracle?

1144

How to select all columns of all rows from a table in oracle?

1115

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

What are the source of constraints?

1006

What are the two main functions of queries in databases?

1519

What kind of problems occurs if we do not implement proper locking strategy?

1490

What is oracle latest version?

1166

Any work done in oracle workflow builder. Did you customize or build a new workflow?

For More Un-Answered { Databases } Questions Click Here