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

Oracle (3253)
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 5491

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

8 12414

What is STATSPACK tool?

Wipro,

3 9460

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12212

all the queries used in sql

TCS,

1 2732

What is the default value of CHAR type?

Bosch,

10 22088

How to find the last update record in SQL Server?

4 17331

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 12224

Can we create a clustered index on composite primary key.

IGT,

3 19843

how to find nth lowest salary

4 17455

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

ACC,

1 4042

ru compare the 2 null values?

ACC,

2 5990

How can you do the fine tunning?

ACC,

3 6357

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,

1 2212

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

ACC,

1 2105

Un-Answered Questions { Databases }

What is the difference between case version and decode version?

1104

What is temporary table in sql server? Why we use temp table?

1013

What is sql or structured query language?

1220

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2292

How to export data from database and import into another?

994

What are the types of database explain each of them briefly?

1054

what is spatial nonclustered index

1054

Disadvantages of the indexes?

1220

What are the kinds of subquery?

1101

How to provide default values to function parameters?

1251

What is your daily office routine?

2341

What are the two main functions of queries in databases?

1525

Can one drop a column from a table?

1082

How to convert character strings into numeric values?

1186

What versions of clipper does netlib support?

1088

For More Un-Answered { Databases } Questions Click Here