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 to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1 1199

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1 1125

Difference between CHAR and VARCHAR?

1 1192

How to Change a users password from unix shell.

1210

What are Heap tables?

2 1675

What are the different tables present in MySQL?

1 1182

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1 1103

What are federated tables?

1 1267

Give string types available for column?

1 1070

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1 1094

What are the column comparisons operators?

1 1332

How do you login to MySql using Unix shell?

1 1263

How to do login in mysql with unix shell.

1 1191

What are the nonstandard string types?

1355

How can we get the number of rows affected by query?

1 1137

Un-Answered Questions { Databases }

What are the steps in creating a database?

1004

What is the difference between for xml raw and for xml auto?

1108

What are the advantages of database?

1009

What is an indexed view?

1018

List the ways in which dynamic sql can be executed?

1077

Who proposed the relational model?

1027

When should you use an instead of trigger?

1042

How to put more than 1000 values into an oracle in clause?

1104

What is a concurrency problem in dbms?

1048

Are you familiar with user exits in reports?

What are the different subsets of sql?

1644

define sql insert statement ? : Sql dba

1092

What is the difference between case version and decode version?

1101

Do we need to rebuild index after truncate?

1128

What are the properties of the transaction?

1069

For More Un-Answered { Databases } Questions Click Here