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

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

2 7711

Use mysqldump to create a copy of the database?

2 6453

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

TCS,

1 5068

What are some good ideas regarding user security in MySQL?

2 5055

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9789

What does myisamchk do?

1 4393

Explain advantages of InnoDB over MyISAM?

1 8182

Explain advantages of MyISAM over InnoDB?

1 6426

What are HEAP tables in MySQL?

1 12882

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

1 8925

What are CSV tables?

1 6154

Explain federated tables?

Tech Mahindra,

3 8971

What is SERIAL data type in MySQL?

Aspire,

3 47950

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

2 12280

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

ABC,

2 6175

Un-Answered Questions { Databases }

Mention what plvcmt and plvrb does in pl/sql?

1067

What are the major difference between truncate and delete?

995

What is primary key in database?

864

How large can a mysql database become?

922

Explain about merge replications?

981

Can a rule be bound to any column of any data type?

919

What are the new features are introduced in sql server 2012 reporting services?

145

what are the Prerequisites for Replication?

11253

What is an execution plan? When would you use it?

927

How do I change a procedure in mysql?

945

Explain natural key?

1061

What are mysql functions?

896

How to fine-tune reports?

251

Can I use a named pipe to bcp/dump data out or in in sybase?

960

Show code of a cursor for loop.

1010

For More Un-Answered { Databases } Questions Click Here