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

Are foreign key constraints necessary?

850

What is pg_hba conf file?

825

What is tableplus?

904

What is pgrouting?

799

What is gis data?

798

Why do we need connection pooling?

827

What is max pool size?

786

What is a table catalog?

790

What is the index key?

939

How do you backup a database?

1000

What does mysqli stand for?

950

How to check if value already exists in mysql database in php?

896

What is the use of mysqli_fetch_array?

1063

Is mysql deprecated?

929

How to set mysql variable in php?

939

Un-Answered Questions { Databases }

How to get the Installed Oracle Version Information ?

1136

How to grant a permission in ms sql server using "grant execute" statements?

1107

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

1212

What is the use of access?

879

Can you tell what are various ways to create an index?

898

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2134

How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.

2404

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2279

What is built-in function?

1023

How to set a transaction to be read only in oracle?

1108

Is sql server 2016 free?

954

what is the size of informix page?

217

What program will open a mdb file?

982

If you have an example table, what is the best way to get sizing data for the production table implementation?

563

how to trace the traffic hitting a sql server? : Sql server database administration

1894

For More Un-Answered { Databases } Questions Click Here