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 6216

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 5041

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

5 7321

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 6159

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

2234

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 7183

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 7882

Un-Answered Questions { Databases }

What is the difference between push and pull subscription? : sql server replication

1216

How to download microsoft sql server 2005 express edition?

1047

What is service based database?

892

How to execute stored procedure in select statement sql server?

1061

What is user-defined scalar function?

965

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

534

Give the different types of rollback segments.

1031

What are click through reports?

142

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1116

What advantages does DBMS have over traditional file systems?

1035

How to modify existing triggers using "alter trigger"?

1017

Explain different forms of normalization?

945

Explain user account with reference to oracle.

987

What is difference between rank () row_number () and dense_rank () in sql?

1101

Which is better cte or subquery?

1027

For More Un-Answered { Databases } Questions Click Here