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 will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

598

How can you tell if a tablespace has excessive fragmentation?

614

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

599

What is a database instance?

610

Which is the best option used to move database from one server to another serve on same network and why?

556

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

680

How can you determine the number of sqlnet users logged in to the unix system?

585

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

598

How can you find your id on a system?

577

What os user should be used for the first part of an oracle installation (on unix)?

567

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

586

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

613

Why are recursive relationships bad? How do you resolve them?

597

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

629

When configuring sqlnet on the client what files need to be set up?

655

Un-Answered Questions { Databases }

How do I open a .db file?

1056

Explain concepts of analysis services?

976

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1977

What command is used to type files to the screen?

606

Is left join same as join?

1009

How you can import data from other sources into access database?

1006

What is use command in mysql?

1057

what is the option or command used in informix for finding which dbspace a database resides?

103

What are indexes? Mention the differences between the clustered and non-clustered index?

980

What is a database example?

1008

What is the native system stored procedure to execute a command against all databases?

1053

What is materialized view. What are different methods of refresh?

1406

What is the recovery model?

1010

Please explain drop constraint oracle?

1125

How do you trace the traffic hitting a sql server?

1160

For More Un-Answered { Databases } Questions Click Here