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

i want table name basis on column name.

5 8266

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

iFlex,

3 7867

In clustered and non clustered indexes which one is faster while executing a query ?

1 7872

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 4914

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

FA, GE, Wipro,

11 27563

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

Polaris,

5 11691

How to create logins using windows Authentication mode?

2 4843

write the query for taking database restore in sql?

2 5554

What is the difference between OLEDB and ODBC

CFCI,

4 12710

What are mdf,ndf,ldf files and how to see the data in those files?

Accenture,

6 60227

what are the API of GL,PO,AP

2267

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2368

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

Value Labs,

2504

What is the difference between DTS and SSIS?

Allianz,

3 37523

Un-Answered Questions { Databases }

Define database lock and its types.

982

give a simple example of physical and logical data independence

2564

What is use of except clause? How does it differ from not in clause?

1020

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1046

How many rows can mysql hold?

886

how can you get actual data change values from previous transactions in oracle?

1089

How do I edit a trigger in mysql?

893

Can you please explain the difference between primary keys and foreign keys?

1110

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1101

What is implicit mode in sql server?

1105

What is procedure in mysql?

935

What is the function of sql server agent windows service?

1097

What are different types of statements that are supported by sql?

1047

What is the best way to do multi-row insert in oracle?

1067

How to create and drop temp table in sql server?

1051

For More Un-Answered { Databases } Questions Click Here