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 8317

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 7899

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

1 7893

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 4948

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 27660

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

Polaris,

5 11729

How to create logins using windows Authentication mode?

2 4865

write the query for taking database restore in sql?

2 5580

What is the difference between OLEDB and ODBC

CFCI,

4 12755

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

Accenture,

6 60294

what are the API of GL,PO,AP

2286

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.

2381

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

2455

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

Value Labs,

2522

What is the difference between DTS and SSIS?

Allianz,

3 37557

Un-Answered Questions { Databases }

What is sequence in sql?

1039

What is a node in neo4j?

what are the drivers in mysql? : Sql dba

1034

How to change a password for an existing user via mysqladmin?

996

Define phantom deadlock.

1028

What is the use of <> sql?

993

What are the advantages of microsoft access?

908

How to get a list of columns in a view using the "sp_help" stored procedure?

1061

When cursors are useful?

1123

What is write ahead logging in sql server?

1062

What are dba privileges?

546

can sql servers linked to other servers like oracle? : Sql dba

1018

Do you know sql server 2008 introduces automatic auditing?

996

What is the maximum number of records in mysql table?

936

What is domain in dbms?

967

For More Un-Answered { Databases } Questions Click Here