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 6226

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

Oracle,

1 4463

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 6425

how to store only time in a data base table

2 5047

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

5 7331

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 6166

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

2238

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

1 4882

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

1 7191

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 7896

Un-Answered Questions { Databases }

whats the maximum size of view state??

2193

Which normal form is best?

951

What is the name of reporting services config file and what’s it’s used for?

146

How do I start tns listener?

1047

Differentiate between % rowtype and type record.

1311

What is the difference between bind and lexical parameter?

1082

Explain relational data?

929

how to create “alternate row colour”?

146

What is called dbms?

1054

Explain the covered query in mongodb.

What are procedures in dbms?

920

What is the starting oracle error number?

1058

What is the main difference between ‘between’ and ‘in’ condition operators?

1195

What do you understand by replication in sql server? Mention the different types of replication in sql server.

949

Does a user_objects view have an entry for a trigger?

1017

For More Un-Answered { Databases } Questions Click Here