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 does mysql encrypt passwords?

905

How do I view mysql logs?

902

How to declare variable in mysql trigger?

1028

How does mysql clustering work?

938

How to use rank function in mysql?

1005

How do you shutdown a mysql database?

1070

How many threads can mysql handle?

990

How many tables we can create in mysql database?

970

How do I enable mysqli extension?

1022

How much does mysql cost?

951

How do you restart mysql?

924

How to delete a trigger in mysql?

942

How many types of indexes are there in mysql?

921

How set mysql root password?

934

How do I zip a file in mysql?

996

Un-Answered Questions { Databases }

What is the difference between Clustered and Non-Clustered Index?

1074

How many ways to get the current time?

985

How do I start mysql in ubuntu?

1050

Explain what you mean by 3 tier architecture.

1097

What are the the Advantages of DBMS?

863

What is a table index?

1123

What are the various types of relationships in database? Define them.

905

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2585

How to drop an existing view in oracle?

961

What is composite foreign key?

753

Explain locks? : Transact sql

1024

What is set operator oracle?

1003

Explain exception handling in pl/sql?

1053

Define normalization.

969

What is the difference between a unique key and primary key?

971

For More Un-Answered { Databases } Questions Click Here