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

Explain coalesce.

959

You need to remove the affected rows and dashes. How would you do that?

951

Explain update statistics.

868

How would you lock a table in sybase?

949

You need to multiply all values of a single column. How would you do that?

898

What is the role of replication server in sybase?

974

You need to manipulate varbinary columns in sybase. How would you do that?

979

explain engines?

925

Explain bind cache?

954

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

905

Explain relationship between jdbc and sybase.

919

You need to remove duplicate rows from a sybase table. How would you do that?

897

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

891

Explain intimate shared memory(ism)

920

What are the operating systems in which sybase could take its presence?

916

Un-Answered Questions { Databases }

what is a table in a database ? : Sql dba

1057

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2536

Difference between transaction type and transaction sources. : oracle accounts receivable

1041

What are the different type of relationships in the dbms?

881

explain different levels of normalization? : Sql server database administration

1015

What do I need to start working with sql studio? : sql server management studio

1124

Explain insert into select statement?

970

What is a file group?

1114

What are rows and columns?

1030

How many tables we can create in mysql database?

964

How to handle bulk data?

1329

Compare and contrast between sql and sql server and explain its various functions?

978

Does mongodb support primary-key, foreign-key relationship?

What is difference between aggregate and analytic function?

948

Does mongodb store data in memory?

For More Un-Answered { Databases } Questions Click Here