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

How to run a sql statement?

1038

How to get the number of rows selected or affected by a sql statement?

927

What is a result set object?

975

Write a command to view mysql database table structure?

978

What is required to create mysql database?

999

Where’s database data actually stored?

978

write a query to mysql in safe mode and to change the root password

972

how to take mysql database backup?

1090

How will you export tables as an xml file in mysql?

941

how to connect a php script with the mysql database?

1061

How to find the unique values if the value in the column is repeated?

1011

What are the applications required to support mysql?

970

How would you enter characters as hex numbers?

964

Why phpmyadmin is used for mysql?

961

write a command to view the content of the table

913

Un-Answered Questions { Databases }

What is pl sql quora?

1188

What is memory optimized?

1096

Is oracle faster than sql server?

972

What is a data collection table?

1023

What are .mdf files?

968

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

2524

List the ways in which dynamic sql can be executed?

1029

Is mongodb hard to learn?

Which version of postgresql should I use?

934

What is scaling in mongodb?

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1760

Can journaling feature be used to perform safe hot backups?

What is cold data?

973

What is materialized view in Oracle?

1083

What is the difference between dropping a database and taking a database offline?

1188

For More Un-Answered { Databases } Questions Click Here