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

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

908

How does partition assignment relate to transactions in sybase?

875

What is asa in sybase?

927

How do I configure the burn factor in sybase?

878

What is replication server in sybase?

833

What are the best monitoring tools for the sybase database?

825

What is cis and how can I use it?

1077

How do I choose which tables to partition in sybase?

865

How to clear tempdb when the tempdb gets filled in sybase?

840

How do I correct time slice -201?

953

What is the command for quitting from sybase?

929

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

854

How to view the log files in sybase?

936

How do I turn off marked suspect on my database in sybase?

883

How do I bcp null dates in sybase?

934

Un-Answered Questions { Databases }

How to divide query output into groups in oracle?

992

How is a developer added to a trusted publishers list?

839

Suppose you are designing an access database form. How will you get your next control in the form to be automatically selected?

837

What are different type of Collation Sensitivity?

1003

What is synchronized subquery?

1170

What is clob in mysql

947

How do you rename a database?

910

What are the advantages of using a stored procedure?

1008

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

526

What are cursors stored procedures and triggers?

1021

What is transparent data encryption? : sql server DBA

1195

What is a trigger oracle?

1088

Disadvantages of the indexes?

1125

How do I count records in sql?

1009

How do you create type- insensitive operator?

1046

For More Un-Answered { Databases } Questions Click Here