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 8457

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

HCL,

2 9027

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

HCL,

3 15088

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

HCL,

2 10606

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

Aptech, HCL, Perpetual, SAIC,

5 25577

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

HCL,

4 10521

Can you have a nested transaction?

HCL,

4 11955

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

HCL,

3 12559

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

HCL,

2 13259

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 5284

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 39115

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.

2091

what is latest version in reports

KPIT, Wipro,

3 7650

what is difference between procedure and function

MCN Solutions, Wipro,

10 16601

in procedure how to return a value

Wipro,

3 11469

Un-Answered Questions { Databases }

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2507

How to change the data type of an existing column with "alter table" statements in ms sql server?

990

Explain the advantages and disadvantages of stored procedure?

1153

What are different types of blocks used in stored procedure?

1137

tell me about various levels of constraint. : Sql dba

1041

What is supporting issues GL AP and AR?

2567

Why mysql is used with php?

982

What is the meaning of database backup?

628

Explain dml compiler?

1060

What does COMMIT command do?

1070

Can a synonym name of a table be used instead of a table name in a select statement?

1050

What is pl/sql table? Why is it used?

1054

How view is related to data independence?

987

Explain the use of online redo log files in oracle.

1040

Which are the third-party tools used in sql server and why would you use them?

916

For More Un-Answered { Databases } Questions Click Here