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

What does “select count(*) from tab” result?

IBM, Student, Wipro,

15 29084

What does “select count(1) from tab” result?

IBM,

10 21153

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 12702

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

Relq,

5 9626

What is the default value of CHAR type?

Bosch,

3 10063

If CPU is very slow What can u do to speed up?

1 4518

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 4019

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1738

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2036

how many tupples can insert in 1 second in sql

1 5677

i have marks in table,how to find total?

1 5321

what is difference between nchar and char in Sql server ?

3 8195

How can we write or define DDL statements in Sql server and DML statements?

3 6510

How many memory layers are in the shared pool?

3 7759

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

IBM,

2 11355

Un-Answered Questions { Databases }

Define tool Manage Statistics in SQL Server 2000 query ?

1100

What are the limitations oracle database 10g xe?

1053

How do I set up pgadmin?

796

how to include character strings in sql statements? : Sql dba

1081

How to fetch alternate records from a table?

1253

Is primary key clustered index?

955

How do I start mysql database?

981

What are the default system databases in sql server 2000?

1034

Which are the different languages supported by mongodb?

How many tables can a sql database have?

985

What is oracle pl sql developer?

990

What is the port number for postgresql?

900

Tell me the phases a transaction has to undergo?

969

What are rest-style architecture's?

172

Which tcp/ip port does sql server run?

1017

For More Un-Answered { Databases } Questions Click Here