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

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

2 4223

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

IBM,

1 4103

can i create trigger on synonym is it possible or not please help me

CGI,

4 10836

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 6692

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 11578

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Saama Tech, TCS,

4 10557

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 6950

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

AllState,

1 3365

What are joins, explain all types of joins?

Bravura Solutions,

2235

Do you know about aggregate functions? What is row num function? Can it be used all databases?

Bravura Solutions, Cap Gemini,

1 4434

Write query to fetch second maximum salary from employee table.

Bravura Solutions, HCL,

4 7324

What is your daily office routine?

Data Vision,

2231

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2069

Suppose database is running slow, what will you do?

2487

what is scan listener.

2190

Un-Answered Questions { Databases }

how you can move data or databases between servers and databases in sql server? : Sql server administration

928

What is the difference between DataRow.Delete() and DataRow.Remove()?

1177

What are privileges and grants?

1017

What are the benefits of using access?

831

What are system databases in ms sql server?

986

Explain primary key, foreign key and unique key?

944

what are user defined datatypes and when you should go for them? : Sql server database administration

975

What is the process of debugging?

1024

How do I view tables in mysql workbench?

874

Explain having clause and where clause?

1002

Do you know what is xpath?

1018

What is difference between delete and truncate commands?

1024

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

873

How to connect with firebird database in delphi using tsqlconnection?

What are .mdf files?

896

For More Un-Answered { Databases } Questions Click Here