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 convert to a different table type?

1 4172

How do you index just the first four bytes of the column?

2 5279

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

Aufait, CSS, Wipro,

4 14885

How do you prevent MySQL from caching a query?

1 4850

What?s the difference between query_cache_type 1 and 2?

1 7560

How can we repair a MySQL table?

Infosys,

2 7434

What are the advantages of stored procedures, triggers, indexes?

5 33770

What is the maximum length of a table name, database name, and fieldname in MySQL?

Accenture, Pioneer, TISL,

3 31132

How many values can the SET function of MySQL take?

Creative Informatics,

2 10082

What are the other commands to know the structure of table using MySQL commands except explain command?

SigmaTree,

2 7561

How many tables will create when we create table, what are they?

2 5231

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 43571

Give the syntax of Grant and Revoke commands?

1 9321

Explain Normalization concept?

Inuva,

2 10403

How can we find the number of rows in a table using MySQL?

3 8388

Un-Answered Questions { Databases }

What is sql prepared statement?

1036

Which data type cannot be used as a parameter in a udf?

1024

How to do performance tunning a database in DB2 V8.2 UDB in linux

2308

How do I start sql server agent automatically?

1027

What are the various ingredients of sga?

610

How to use regular expression in pattern match conditions?

1021

what is acid property in database? : Sql dba

1071

Is mongodb a data lake?

what is self-join? : Sql dba

1244

Does mysql need a server?

983

How do I start mysql in ubuntu?

1093

What is a dirty read sql?

1247

What you mean by Object Relational DBMS?

1109

What is the structure of a database?

975

What is database collection?

1053

For More Un-Answered { Databases } Questions Click Here