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

Wht is Stuff in sql ser

2 5379

how to get 25th row in any table in sqlserver can u tell me syntax

8 12102

What is STATSPACK tool?

Wipro,

3 9272

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12080

all the queries used in sql

TCS,

2663

What is the default value of CHAR type?

Bosch,

10 21630

How to find the last update record in SQL Server?

4 17145

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 11859

Can we create a clustered index on composite primary key.

IGT,

3 19635

how to find nth lowest salary

4 17211

what is the Dynamic management views? where can you use?

ACC,

1 3930

ru compare the 2 null values?

ACC,

2 5796

How can you do the fine tunning?

ACC,

3 6170

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

ACC,

2141

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

ACC,

2012

Un-Answered Questions { Databases }

what are the oracle forms services components include?

1037

What are bind variables and why are they important?

549

What is 1nf 2nf 3nf in dbms?

907

Is left join faster than inner join?

1133

How big is a big database?

895

Is a primary key unique?

996

What is a primary key called that is made up of more than one field?

1356

What is rdms?

943

Can you explain the 'between' clause?

1132

What is row_number()?

990

Explain the difference between clustered and non-clustered index?

932

What is count * in sql?

1002

How to change a password for an existing user via mysqladmin?

987

Can sub report data source be different from that of the parent report?

144

What are triggers in sql?

1026

For More Un-Answered { Databases } Questions Click Here