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

i want table name basis on column name.

5 8503

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 8057

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

1 8023

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 5043

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 28124

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

Polaris,

5 11946

How to create logins using windows Authentication mode?

2 4995

write the query for taking database restore in sql?

2 5724

What is the difference between OLEDB and ODBC

CFCI,

4 13001

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

Accenture,

6 60575

what are the API of GL,PO,AP

1 2336

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.

1 2447

. 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?

1 2509

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

Value Labs,

1 2582

What is the difference between DTS and SSIS?

Allianz,

3 37826

Un-Answered Questions { Databases }

What is acid mean in sql server?

1240

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1845

Can we rollback truncate?

1072

Can we do dml on views?

1032

Have you used lexical parameters in reports?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How to use values from other tables in update statements using oracle?

1150

what is sql server agent? : Sql dba

1179

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

What are the different types of subquery?

1232

Have you written applications to retrieve stored images in a table?

1084

Is there some bulk load or other way to import a lot of data fast?

931

Can one drop a column from a table?

1082

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8226

For More Un-Answered { Databases } Questions Click Here