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 8596

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

HCL,

2 9172

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

HCL,

3 15265

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

HCL,

2 10753

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

Aptech, HCL, Perpetual, SAIC,

5 25843

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

HCL,

4 10753

Can you have a nested transaction?

HCL,

4 12156

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

HCL,

3 12722

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

HCL,

2 13420

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 5370

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 40015

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.

2153

what is latest version in reports

KPIT, Wipro,

3 7821

what is difference between procedure and function

MCN Solutions, Wipro,

10 17073

in procedure how to return a value

Wipro,

3 11641

Un-Answered Questions { Databases }

How can you append an identity column to a temporary table?

1065

What is self contained sub query?

1138

How to write a left outer join with the where clause in oracle?

1149

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

How to define array in mongoose schema?

What is acid mean in sql server?

1237

What is the current version of sql?

1091

How to use values from other tables in update statements using oracle?

1149

Is primary key clustered index?

1015

What is clustered index

1083

What is the difference between upgrade and migration in sql server?

1178

What is the current mysql version?

1094

Design database draw er diagram for a certain scenario ?

4647

How can we solve concurrency problems?

1120

Are you familiar with user exits in reports?

For More Un-Answered { Databases } Questions Click Here