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 4849

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

Oracle,

1 3760

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 5352

how to store only time in a data base table

2 4120

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

5 5465

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 5326

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

1810

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

1 4244

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

1 6415

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 6023

Un-Answered Questions { Databases }

What does executeupdate return?

542

What is the difference between postgresql and sql?

402

Explain the the delete statements in sql?

581

Does mongodb need a lot of ram?

How to run sql*plus commands in sql developer?

592

How do I grant privileges to a user in mysql phpmyadmin?

478

What is the difference between access and excel?

423

Which commands you use to lock the database in mongodb?

what is a stored procedure? : Sql dba

561

What is a storage engine in mongodb?

Is microsoft access available in office 365?

498

What are named parameters?

616

What is sql and how does it work?

551

What are the constraints in odi?

326

What is a cursor, index in sql?

582

For More Un-Answered { Databases } Questions Click Here