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

2525

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

Fidelity,

4 10157

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 12160

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

Fidelity, Oracle,

1 8338

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

Orion Laboratories,

7 9892

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 10491

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 19909

What is materialised View?

IBM,

2 5772

Give an example of Full Outer Join?

IBM,

1 5499

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

IBM,

3569

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

ABC,

1 3069

how to retrive xml data for using sql query?

IBM, TCS,

3 7005

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 4680

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6303

How to provide Security for package?

Convergys,

1 7035

Un-Answered Questions { Databases }

What are the rules to be applied to nulls whilst doing comparisons?

1323

What are the differences between char and varchar data types?

1107

types of receipts and detail desription about recipts and tables effected by receipts?

2075

Explain about sql server login?

1086

Explain how we can do multi-join query in ms access?

855

What is pl/sql table? Why is it used?

1042

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2215

How would you go about increasing the buffer cache hit ratio?

2599

What are data resources?

911

What is set serveroutput on?

1136

How do I start postgresql on windows?

919

How do I become a data manager?

527

Is sql workbench free?

994

Explain boyce and codd normal form(bcnf)?

958

Is mongodb better than cassandra?

For More Un-Answered { Databases } Questions Click Here