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

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 4481

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 4255

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

CGI,

4 11178

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

Apple,

3 6911

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 11816

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 10879

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

IBM, L&T,

3 7231

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 3536

What are joins, explain all types of joins?

Bravura Solutions,

2363

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

Bravura Solutions, Cap Gemini,

1 4606

Write query to fetch second maximum salary from employee table.

Bravura Solutions, HCL,

4 7632

What is your daily office routine?

Data Vision,

2316

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

2173

Suppose database is running slow, what will you do?

2570

what is scan listener.

2285

Un-Answered Questions { Databases }

What are different types of clusters present?

1115

What is the max nvarchar size?

1031

How to create id with auto_increment on oracle?

1043

Can two tables share the same primary key?

987

What is sql entity?

1175

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2230

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

966

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

843

How to improve query performance using index hunting?

1227

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2442

What is break?

1256

What is a trigger word?

1081

What is a sequence? Explain it with one example?

1279

Is mongodb unstructured?

What can sql server reporting services do?

1165

For More Un-Answered { Databases } Questions Click Here