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

1 4082

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

2 5172

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

Aufait, CSS, Wipro,

4 14719

How do you prevent MySQL from caching a query?

1 4780

What?s the difference between query_cache_type 1 and 2?

1 7468

How can we repair a MySQL table?

Infosys,

2 7305

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

5 33558

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

Accenture, Pioneer, TISL,

3 30994

How many values can the SET function of MySQL take?

Creative Informatics,

2 9974

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

SigmaTree,

2 7467

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

2 5120

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 43104

Give the syntax of Grant and Revoke commands?

1 9197

Explain Normalization concept?

Inuva,

2 10312

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

3 8264

Un-Answered Questions { Databases }

How to copy data from one table to another table?

996

Can you tell me some of the common replication dmv's and their use? : sql server replication

927

What does the acronym acid stand for in database management?

1032

What is a trace file?

1074

What is set serveroutput on?

1136

How do I remove all records from a table?

1072

How big can a postgres database be?

914

How to retrive a single data from a database

1193

how to pass a variable more than one values?

650

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2410

How do we represent comments in oracle?

1048

Explain mirroring?

866

How to combine two function together?

2125

How to use mongoose with node.js?

how to drop an existing view in mysql? : Sql dba

1060

For More Un-Answered { Databases } Questions Click Here