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

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How do you change a password for an existing user via mysqladmin?

2 6594

Use mysqldump to create a copy of the database?

2 4987

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

TCS,

1 4305

What are some good ideas regarding user security in MySQL?

2 4252

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9136

What does myisamchk do?

1 3755

Explain advantages of InnoDB over MyISAM?

1 7562

Explain advantages of MyISAM over InnoDB?

1 5813

What are HEAP tables in MySQL?

1 12157

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

1 8128

What are CSV tables?

1 5449

Explain federated tables?

Tech Mahindra,

3 7735

What is SERIAL data type in MySQL?

Aspire,

3 46202

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

2 11365

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

ABC,

2 5306

Un-Answered Questions { Databases }

What is primary key in database?

490

Explain an integrity constrains?

690

What is postmaster in postgresql?

423

Tell me something about security and sql azure?

100

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1569

how to load data files into tables with 'mysqlimport'? : Sql dba

508

How do I start mysql in ubuntu?

469

what is object cache in neo4j?

What are all the different normalizations?

576

What is the role of 8 analysers in mongodb?

what is 'mysqladmin' in mysql? : Sql dba

522

What is the difference between value type and reference type?

543

Is sql different from sql server?

498

What is the usage of nvl function?

586

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

522

For More Un-Answered { Databases } Questions Click Here