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

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 6402

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

Oracle,

1 4524

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 6511

how to store only time in a data base table

2 5142

how to get the no employee in each department including the dept which has 0 employee

5 7494

hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 6255

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2283

how do we insert 100 records at a time in a table without using for loop in database

1 4943

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 7263

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 8135

Un-Answered Questions { Databases }

hiding item in report how like that properly,thats manually but at runtime i want to do

3323

define join and explain different type of joins? : Sql dba

1002

Does mongodb support acid transactions?

How to write html code in pl sql?

1161

Who are mongodb competitors?

How can we find out the duplicate values in an oracle table?

1121

Write a sql query to convert all character to uppercase after hypen.

1486

How much does sqlite cost?

1094

How many types of segments in Oracle?

1116

Tell me what is fill factor?

1013

Does access use sql?

1101

How to filter out duplications in the returning rows using oracle?

1068

How do I completely remove mysql from windows?

1026

What type of database is sql?

1068

where are cookies actually stored on the hard disk? : Sql dba

1080

For More Un-Answered { Databases } Questions Click Here