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

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

HCL,

1 8474

What are statistics, under what circumstances they go out of date, how do you update them?

HCL,

2 9050

What are the different ways of moving data/databases between servers and databases in SQL Server?

HCL,

3 15100

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

HCL,

2 10621

What is database replicaion? What are the different types of replication you can set up in SQL Server?

Aptech, HCL, Perpetual, SAIC,

5 25607

How to determine the service pack currently installed on SQL Server?

HCL,

4 10546

Can you have a nested transaction?

HCL,

4 11985

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

HCL,

3 12574

What is the system function to get the current user's user id?

HCL,

2 13267

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

HCL,

1 5294

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 39224

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

2096

what is latest version in reports

KPIT, Wipro,

3 7670

what is difference between procedure and function

MCN Solutions, Wipro,

10 16645

in procedure how to return a value

Wipro,

3 11488

Un-Answered Questions { Databases }

What is progress actional?

1016

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1025

Explain the benefits of user-defined functions?

1082

How to delete duplicate rows from table except one?

1003

What do you mean by checkpoints in dbms?

890

What is difference between stored function and application function?

1221

what is sql server? : Sql server database administration

1008

What are four major operators that can be used to combine conditions on a where clause?

1072

What are all the Common SQL Function?

1150

Differentiate pl/sql and sql?

1079

Where in ms sql server is ’100’ equal to ‘0’?

1103

What is wal in postgresql?

875

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

574

What is unique key in mysql?

1000

What is a system database and what is a user database? : sql server DBA

1250

For More Un-Answered { Databases } Questions Click Here