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 8272

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 7873

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

1 7875

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 4918

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 27581

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

Polaris,

5 11699

How to create logins using windows Authentication mode?

2 4852

write the query for taking database restore in sql?

2 5563

What is the difference between OLEDB and ODBC

CFCI,

4 12719

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

Accenture,

6 60245

what are the API of GL,PO,AP

2273

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.

2370

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

2444

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

Value Labs,

2510

What is the difference between DTS and SSIS?

Allianz,

3 37535

Un-Answered Questions { Databases }

What do you mean by a replica set in mongodb?

What is strict mode in mysql?

914

How do you use excel for access?

919

how can you schedule a job in database?

1128

What is local database?

980

How do I create a database in access 2010?

869

What is difference between materialized view and view?

919

How to define an anonymous block?

1160

Which database is faster?

907

What are system versioned tables?

1032

How do you create a database using microsoft access?

933

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2598

What is sp_helptext?

1070

Can you explain important index characteristics?

993

What do you understand by database triggers?

935

For More Un-Answered { Databases } Questions Click Here