Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 do you change a password for an existing user via mysqladmin?

2 7923

Use mysqldump to create a copy of the database?

2 6675

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

TCS,

1 5222

What are some good ideas regarding user security in MySQL?

2 5267

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9950

What does myisamchk do?

1 4552

Explain advantages of InnoDB over MyISAM?

1 8351

Explain advantages of MyISAM over InnoDB?

1 6593

What are HEAP tables in MySQL?

1 13056

How do you control the max size of a HEAP table?

1 9081

What are CSV tables?

1 6298

Explain federated tables?

Tech Mahindra,

3 9250

What is SERIAL data type in MySQL?

Aspire,

3 48358

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 12490

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

ABC,

2 6404

Un-Answered Questions { Databases }

What is the function of inner join?

1126

How to Check if table exists in sql server?

1188

Mention the different types of dbms.

1100

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1114

What is a bit datatype?

1021

What are numeric data types?

1043

What is metadata in dbms?

1017

what is oracle data integrator (odi)?

664

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

1026

What is mongodb and why we use?

What is sqlcmd?

1136

What is object data modeling?

1017

Is postgresql the same as mysql?

964

How to check your oracle database 10g xe installation?

1049

Why use triggers?

1068

For More Un-Answered { Databases } Questions Click Here