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

Differentiate between clustered and non-clustered index.

892

How would you configure identities in sybase?

1039

How do you use workspace in sybase?

928

How would you improve throughput in sybase?

994

When you change a database option when will it come into effect?

881

How would you replicate col = col + 1 in sybase?

1073

Explain open server?

949

What is replication server? What is its role in sybase?

965

What are the main differences between 11.x and 12.x versions of sybase?

852

Explain timestemp datatype in sybase.

990

What is replication server?

939

How would you check the long running transaction?

937

You need to purge data from audit database. What will you do?

910

Tempdb is full. How would you clear it?

901

What mandatory options are required for bcp command utility?

952

Un-Answered Questions { Databases }

Is left join faster than inner join?

1141

How to get the ddl of a table in postgresql?

884

How to replace the Query Result 'Null Value' with a text ?

1057

What is the meaning of database backup?

635

What purpose does the model database server? : sql server DBA

1212

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

1002

how to create a new table by selecting rows from another table in mysql? : Sql dba

1124

What are the lock types?

966

What is the default Port No on which SQL Server listens?

1143

What privilege is needed for a user to create indexes in oracle?

1042

how could you increase the speed of ontape/onbar backups ?

Explain the difference between dbms and rdbms?

948

What is Data Redundancy and Consistency ?

1016

Can we rename a column in the output of sql query?

1008

How to use subqueries with the in operator using oracle?

1108

For More Un-Answered { Databases } Questions Click Here