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 4116

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

2 5194

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

Aufait, CSS, Wipro,

4 14767

How do you prevent MySQL from caching a query?

1 4794

What?s the difference between query_cache_type 1 and 2?

1 7487

How can we repair a MySQL table?

Infosys,

2 7339

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

5 33608

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

Accenture, Pioneer, TISL,

3 31032

How many values can the SET function of MySQL take?

Creative Informatics,

2 10000

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

SigmaTree,

2 7500

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

2 5153

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 43238

Give the syntax of Grant and Revoke commands?

1 9218

Explain Normalization concept?

Inuva,

2 10335

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

3 8298

Un-Answered Questions { Databases }

What is raid? : SQL Server Architecture

1198

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?

1006

What are “lock” hints?

1071

explain how to create a new schema in a database? : Sql server database administration

1122

What is a join in the sql?

1004

Who developed mysql?

1035

What are subqueries in sql server?

1137

Is progress software supports to ( pl/sql )?

1054

Write a query to get maximum and second maximum in oracle?

1064

Can a function call a stored procedure in sql server?

973

What is microsoft access best used for?

935

How to handle a single quote in oracle sql?

1073

Explain about the properties of cursors?

1032

How to use sql*plus built-in timers?

1214

What is sql query limit?

987

For More Un-Answered { Databases } Questions Click Here