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

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 7168

what is the difference between table and view

1 3299

I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

1890

plss anybody specify tha constrian management system in dbms

Police Constable,

2150

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.

GE,

2 5328

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

GE,

4 9946

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 3803

The use of LAST_VALUE() AND FIRST_VALUE() with an example

Amazon,

1 5042

.dbf file corrupted Dear Friends, I am using DBF file in Foxpro. DBF file corrupt and show message "Not a database file" Waiting for your reply. With regards!

3 6135

How to genrate automaticlly empid like gt001

4 5721

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so

3 6351

when normalization is required

HCL,

3 7791

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

TCS,

3 5800

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2617

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2120

Un-Answered Questions { Databases }

What do you mean by subquery?

1087

Why foreign key constraint is important?

804

Can you rollback after commit?

983

Can you create an index on an array field in mongodb? If yes, what happens in this case?

What is the standby server?

953

Explain the use of owner option in exp command.

1041

What is 3nf normalization?

995

How to move files from one directory to another in pl sql?

1193

What are the levels of architecture?

804

What are the Types of Scd's?

579

20. Using a set operator, display the client number of all clients who have never placed an order.

2185

How to create user defined functions with parameters?

1232

What is Command line parameters in PLSQL.?

1128

What do you mean by starvation in dbms?

1201

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8493

For More Un-Answered { Databases } Questions Click Here