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 4830

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

Oracle,

1 3748

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 5341

how to store only time in a data base table

2 4112

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

5 5446

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 5316

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

1804

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

1 4232

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

1 6405

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 6001

Un-Answered Questions { Databases }

Is mongodb a json?

which types of join is used in sql widely? : Sql dba

537

What is union, minus and interact commands?

748

Define entity, entity type, and entity set.

531

How to create an inline table-valued function?

533

What is the syntax and use of the coalesce function?

598

What are Heap tables?

837

What is trigger explain with example?

550

Find nth lowest salary or get nth lowest salary?

593

List out the difference between union and union all in sql server?

517

Can an extended stored procedure be called from inside a user-defined function?

607

Can we insert delete data in view?

542

What will be the maximum number of index per table?

587

Explain what is table in a database?

577

3. Steps in UAT?

1947

For More Un-Answered { Databases } Questions Click Here