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 7862

Use mysqldump to create a copy of the database?

2 6619

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

TCS,

1 5167

What are some good ideas regarding user security in MySQL?

2 5205

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9895

What does myisamchk do?

1 4503

Explain advantages of InnoDB over MyISAM?

1 8302

Explain advantages of MyISAM over InnoDB?

1 6552

What are HEAP tables in MySQL?

1 13005

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

1 9016

What are CSV tables?

1 6251

Explain federated tables?

Tech Mahindra,

3 9156

What is SERIAL data type in MySQL?

Aspire,

3 48192

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

2 12435

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

ABC,

2 6324

Un-Answered Questions { Databases }

How does sql profiler work?

1032

Is drop table faster than truncate?

1007

What are access modules?

783

Explain the wait events in statspack report 'db sequential real'?

654

Are null values same as that of zero or a blank space?

1043

What is the difference between dropping a database and taking a database offline?

1184

What is parameterized cursor in oracle?

1173

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1177

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1919

In which format data is stored in mysql database?

1006

How does left join work in sql?

1012

Why having clause is used in sql?

991

Explain difference between cross join and full outer join?

1019

How do convert or display the date or time as string?

1066

What is a non equi join?

991

For More Un-Answered { Databases } Questions Click Here