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 28274

How can we store binary data in mysql?

HP,

2 7571

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 8117

What is Statement Auditing ?

2 5533

What are the use of Roles ?

3 6291

What is Object Auditing ?

2 5191

What is Privilege Auditing ?

1 4247

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

3 5194

What is Auditing ?

3 5992

What are the different Levels of Auditing ?

1 7055

What are Roles ?

2 5158

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

1 4955

What is default tablespace ?

3 5304

What is Tablespace Quota ?

2 4860

Un-Answered Questions { Databases }

how can you initialize log miner?

1144

What are date and time data types in mysql?

1021

You need to migrate the ms access database tables to oracle. What steps will you take?

815

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

Why olap is used?

968

Can you import multiple excel files into access?

846

what are actual and formal parameters?

1104

What are the three pl sql block types?

1009

explain what is odi?why is it different from the other etl tools.

616

What does dml stand for?

947

Is mongodb a data lake?

Can we call procedure inside function in oracle?

1087

Why is foreign key used?

833

Can we join same table in sql?

1019

What does mysql flush tables do?

963

For More Un-Answered { Databases } Questions Click Here