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 7985

Use mysqldump to create a copy of the database?

2 6734

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

TCS,

1 5253

What are some good ideas regarding user security in MySQL?

2 5311

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9979

What does myisamchk do?

1 4577

Explain advantages of InnoDB over MyISAM?

1 8376

Explain advantages of MyISAM over InnoDB?

1 6624

What are HEAP tables in MySQL?

1 13108

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

1 9107

What are CSV tables?

1 6329

Explain federated tables?

Tech Mahindra,

3 9298

What is SERIAL data type in MySQL?

Aspire,

3 48426

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

2 12541

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

ABC,

2 6428

Un-Answered Questions { Databases }

How do I create a trace in sql server?

1109

What is sql or structured query language?

1218

What is standby servers? Explain types of standby servers.

1069

Is there some bulk load or other way to import a lot of data fast?

929

What is the difference between for xml raw and for xml auto?

1108

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

What is a concurrency problem in dbms?

1049

What are the properties of the transaction?

1069

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

What is your daily office routine?

2340

how to start mysql server? : Sql dba

1258

How to provide default values to function parameters?

1247

Where can you add custom error messages to sql server?

1197

How to start an oracle instance?

1095

What is the difference between upgrade and migration in sql server?

1173

For More Un-Answered { Databases } Questions Click Here