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

Write a query to create a database and a table?

917

How to determine the location of the data directory?

981

What is the purpose of -> in the mysql terminal?

1143

What you can use regular expression for in mysql? Support your answer with an example?

931

How would concatenate strings in mysql?

1054

What is difference between mysql_connect and mysql_pconnect?

1063

what is the procedure to configure the application of mysql?

1058

Where’s database data actually stored? Is there a way to see the files which are stored?

993

Write a query to stop mysql in unix

1066

What does the file with the extension: frm, myd, and myi contain?

941

What are enums used for in mysql?

1019

How database are managed?

1007

When to use order by in delete statement?

1037

Why to use char instead of varchar in the database?

1216

How can you make a database as your current database?

1068

Un-Answered Questions { Databases }

How to determine what records to extract?

What is schema in mongodb?

Explain the architecture of ms sql reporting service?

938

How to convert character strings into numeric values?

1113

Define join types.

963

What will be the maximum number of indexes per table?

980

Explain tables in SQL Azure?

122

What is the full meaning of mysql?

978

What is server name sql?

1161

If a table does not have a unique index, can a cursor be opened on it?

929

What are the types of trigger in oracle?

1000

What is cost in sql execution plan?

1000

How would you change old and new values in an insert, delete and update triggers?

1042

What is concurrency in oracle?

1028

How to divide by zero and nulls in sybase?

970

For More Un-Answered { Databases } Questions Click Here