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 5385

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

8 12136

What is STATSPACK tool?

Wipro,

3 9291

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12091

all the queries used in sql

TCS,

2667

What is the default value of CHAR type?

Bosch,

10 21671

How to find the last update record in SQL Server?

4 17158

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 11884

Can we create a clustered index on composite primary key.

IGT,

3 19648

how to find nth lowest salary

4 17237

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

ACC,

1 3938

ru compare the 2 null values?

ACC,

2 5805

How can you do the fine tunning?

ACC,

3 6181

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,

2147

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

ACC,

2016

Un-Answered Questions { Databases }

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2463

Explain various types of locks in a transaction? Which is better and why?

1055

How we get sum of column.

1023

How do I open an access 2007 file?

838

What is microsoft access and its uses?

891

How to delete an existing row from a table in oracle?

1085

What is the exist operator?

What is bulk collect in pl sql?

1111

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1083

What are constraints?

1028

What is BLOCK statements in SQL?

1277

what is the difference between filters and conditions?

2437

What is data modelling in sql?

1037

Can I disable or restrict ssrs export formats (rendering formats)?

153

How many tables we can create in mysql database?

962

For More Un-Answered { Databases } Questions Click Here