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 6403

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 6514

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 7496

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 6257

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

2284

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 7264

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 }

What is one tier architecture?

823

Why mongodb is so popular?

what is 'mysqlimport'? : Sql dba

1115

What would you do with an in-doubt distributed transaction?

2049

Is foreign key mandatory?

1064

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

958

Is there a 64 bit version of ssms?

1001

Mention what is the command syntax for inserting a document?

Explain what are the database objects? : sql server architect

976

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1301

How do I view a procedure in sql server?

1038

How to generate query output in html format?

1213

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

1079

How would you enter characters as hex numbers?

991

What is the contrast between sql and pl/sql?

1200

For More Un-Answered { Databases } Questions Click Here