Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

i want table name basis on column name.

5 6733

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 6796

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

1 6915

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 4147

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 23616

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

Polaris,

5 9965

How to create logins using windows Authentication mode?

2 3743

write the query for taking database restore in sql?

2 4623

What is the difference between OLEDB and ODBC

CFCI,

4 10989

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

Accenture,

6 58064

what are the API of GL,PO,AP

1767

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.

1951

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

1972

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

Value Labs,

2076

What is the difference between DTS and SSIS?

Allianz,

3 35827

Un-Answered Questions { Databases }

How to convert string to objectid in mongoose?

What are the different types of database management systems?

519

What are three major types of constraints?

511

What is the difference in accessing db between sql server vs sql azure?

157

What is normalization in dbms?

473

What is an etl file?

518

What is a domain in microsoft access?

439

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

1657

Define normalization.

574

What is data directory in mysql?

474

What area unit the various kinds of info compression introduced in sql server 2008?

561

What causes the "snapshot too old" error? How can this be prevented or mitigated?

252

Does truncate need commit?

502

Explain each trigger related to mouse.

what are the properties and different types of sub-queries? : Sql dba

495

For More Un-Answered { Databases } Questions Click Here