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 is analyze command ? what kind of statistics does it generate?

2 5008

how do u know the total no of rows in a table?

6 9110

what are archived logs?

2205

what are bitmap indexes? How does they work?

2260

what are the database links ?

2 4780

does the query needs a hint to access a materialized view?

1 3869

what are different types of locks?

6 8614

master table and child table performances and comparisons in Oracle ?

2139

what are the different types of cursors? explain?

4 10236

what are different types of deletes?

1 3772

can a view be updated?

3 9785

what is pragma?

2 6783

can you write commit in triggers?

4 10894

can u call user defined functions in select statements

2 5353

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 7000

Un-Answered Questions { Databases }

How are extents allocated to a segment?

1130

State some of the uses of MS Access?

885

How do we Backup SQL Azure Data?

108

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1069

Why is replication required on the sql server?

1066

What is right outer join in sql server joins?

1186

Is time a data type in sql?

913

What is index fragmentation in ms sql server?

1092

Describe in brief sql server monitoring ways.

1055

How to drop an existing index in mysql?

1110

How to get a list of columns in a view using the "sp_help" stored procedure?

1035

How to read data in a table with "select" statements?

976

What is the difference between resultset and resultsetmetadata?

981

Explain what is an index?

1064

What is mongod command?

For More Un-Answered { Databases } Questions Click Here