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 4336

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 4190

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

CGI,

4 10998

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

Apple,

3 6795

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 11674

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 10718

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

IBM, L&T,

3 7080

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 3444

What are joins, explain all types of joins?

Bravura Solutions,

2299

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

Bravura Solutions, Cap Gemini,

1 4517

Write query to fetch second maximum salary from employee table.

Bravura Solutions, HCL,

4 7465

What is your daily office routine?

Data Vision,

2269

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

2120

Suppose database is running slow, what will you do?

2520

what is scan listener.

2228

Un-Answered Questions { Databases }

What is openedge abl in terms of taking the perspective of the developer?

918

what is cte? : Mysql dba

945

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1123

Do you know the different ddl commands in sql?

1054

how to control the amount of free space in your index pages? : Sql server database administration

1037

How do I grant privileges to a user in mysql phpmyadmin?

954

How to validate email addresses in mysql?

1125

How do I run sql profiler?

1068

How many types of tables supported by oracle?

1076

What is the usage of when clause in trigger?

1057

What is the Repository and how many types of repository?

575

Explain what is a field in a database and record in a database?

1097

What is a initialization parameter file in oracle?

1035

How to get data from mongodb in flask?

What is the difference between the conventional and direct path loader? : aql loader

1152

For More Un-Answered { Databases } Questions Click Here