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 29063

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

IBM,

10 21140

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 12694

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 9618

What is the default value of CHAR type?

Bosch,

3 10055

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

1 4512

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 4017

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.

1735

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??

2034

how many tupples can insert in 1 second in sql

1 5667

i have marks in table,how to find total?

1 5312

what is difference between nchar and char in Sql server ?

3 8191

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

3 6504

How many memory layers are in the shared pool?

3 7754

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

IBM,

2 11348

Un-Answered Questions { Databases }

What is dba software?

650

How can we tune a oracle database if log file sync issue comes

2111

What should a dba know?

533

If no size is defined while creating the database, what size will the database have?

996

What is data definition language?

1097

What are the different types of dbms?

1016

How to get maxsal , minsal, ename department wise in single query

1551

Name some of the open source software that you can use in alternative to SSR?

161

What is trigger and types?

1030

How to check parameter value in stored procedure sql server?

980

Why do we use procedures in pl sql?

1045

Why do we need cursor in pl sql?

1139

How do I view a stored procedure in sql server?

986

What do you mean by catalog?

870

what are the performance views in an oracle rac environment?

1057

For More Un-Answered { Databases } Questions Click Here