Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2461

wa procedure to return the month and the no'f developers joined in each month.

Fidelity,

4 9952

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

Fidelity,

4 11968

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

Fidelity, Oracle,

1 8256

how to retrieve the top 2 salaried persons from a database?

Orion Laboratories,

7 9612

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

IBM,

6 10241

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

Cap Gemini, IBM,

4 19690

What is materialised View?

IBM,

2 5669

Give an example of Full Outer Join?

IBM,

1 5414

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

IBM,

3518

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

ABC,

1 2979

how to retrive xml data for using sql query?

IBM, TCS,

3 6870

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

IBM,

1 4575

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6212

How to provide Security for package?

Convergys,

1 6934

Un-Answered Questions { Databases }

How can you select unique records from a table?

995

What are the functions of database management system?

901

What are the protection features in ms access?

824

What is the maximum number of columns in sql table?

1089

What is the full meaning of dbms?

990

What is the cartesian product of table?

932

What is the concept of optimization?

991

what is the information that can be stored inside a bit column? : Sql server database administration

904

What do you need to connect php to mysql?

934

What is difference between mysql_connect and mysql_pconnect?

976

what is the difference between data migration and production migration.

2276

What are the drivers in MySQL?

1369

What is the difference between inner join and left join?

938

Explain about merge replications?

967

What is the difference between case version and decode version?

963

For More Un-Answered { Databases } Questions Click Here