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 the difference between mysql_connect() and mysql_pconnect()?

TCS,

7 28283

How can we store binary data in mysql?

HP,

2 7577

How can you get your MySQL root password, if you lost it?

PCS,

1 4201

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 8122

What is Statement Auditing ?

2 5539

What are the use of Roles ?

3 6291

What is Object Auditing ?

2 5196

What is Privilege Auditing ?

1 4248

What are the system resources that can be controlled through Profile ?

3 5200

What is Auditing ?

3 5996

What are the different Levels of Auditing ?

1 7059

What are Roles ?

2 5171

How to prevent unauthorized use of privileges granted to a Role ?

1 4956

What is default tablespace ?

3 5312

What is Tablespace Quota ?

2 4862

Un-Answered Questions { Databases }

How does one create a new database?

591

Explain about integrity constraint?

1124

what is a replica set?

Explain about query and reporting.

2091

How to write a query with an inner join in ms sql server?

1047

What are the types of database schema? : sql server analysis services, ssas

1134

What is the difference between grant and with grant while giving permissions to the user?

964

how to rename an existing column in a table? : Sql dba

1020

What are the different sql commands?

1073

Is postgres a database?

821

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

946

What are the types of indexing?

1084

What do you understand by cursor? Mention the different types of cursor?

1056

How do I remove a user from mysql?

988

Can you index views?

895

For More Un-Answered { Databases } Questions Click Here