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 6218

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

Oracle,

1 4459

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 6421

how to store only time in a data base table

2 5042

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

5 7322

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 6161

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

2235

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

1 4880

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

1 7185

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 7886

Un-Answered Questions { Databases }

What is an anonymous block?

1250

Is primary key clustered index?

949

How to connect Silverlight application to database?

1059

How do I completely uninstall postgresql?

865

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1045

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

Which function is used to return remainder in a division operator in sql?

1140

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...

3199

What do you understand by physical_only option in dbcc checkdb?

980

How do I make a resultset scrollable?

960

Can we insert in view in sql?

1059

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1025

How to concatenate two strings in SQL Server.

1149

Is mongodb encrypted?

What is the default isolation level in sql server? : Transact sql

1023

For More Un-Answered { Databases } Questions Click Here