Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 8550

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

HCL,

2 9124

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

HCL,

3 15191

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

HCL,

2 10710

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

Aptech, HCL, Perpetual, SAIC,

5 25759

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

HCL,

4 10672

Can you have a nested transaction?

HCL,

4 12109

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

HCL,

3 12679

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

HCL,

2 13366

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 5342

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 39709

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.

2131

what is latest version in reports

KPIT, Wipro,

3 7768

what is difference between procedure and function

MCN Solutions, Wipro,

10 16915

in procedure how to return a value

Wipro,

3 11579

Un-Answered Questions { Databases }

What is a database in layman terms?

1002

How many columns can a table have?

980

What is the latest mysql?

1002

What is anonymous block in sql?

1174

What is stored procedure in database?

991

Is mongodb better than other sql databases? If yes then how?

What database does facebook use?

1021

How to start postgresql server in windows 10?

892

Explain about the database management systems.

1029

What is a super key?

1084

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

What are the differences between interval year to month and interval day to second?

1070

Why we use mysql workbench?

956

Explain having clause?

1031

What is procedure explain with program?

1069

For More Un-Answered { Databases } Questions Click Here