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 can you find out the version of the installed mysql?

1 1384

Which mysql function is used to concatenate string?

1 1572

What are the advantages and disadvantages of using mysql?

1059

What are the differences between char and varchar data types?

1195

What is a storage engine? What are the differences between innodb and myisam engines?

1117

Explain the different types of mysql joins.

976

What are the differences between innodb and myisam engines?

1052

How can you retrieve a portion of any column value by using a select query?

976

What is the default port number of mysql?

997

Which statement is used in a select query for partial matching?

1232

What is the difference between now() and current_date()?

1030

What is a storage engine?

1020

What is a join? Explain the different types of mysql joins.

1 1473

What is the purpose of using a heap table?

1200

How can you change the password of a mysql user?

1020

Un-Answered Questions { Databases }

Explain the usage of floor function in sql server.

1033

Which storage engine is best in mysql?

1010

How do temporal tables work?

1028

Why do we use sqlite?

1032

What is sql procedures and functions?

1082

How many types of tables are there in oracle?

1124

What is a text delimiter?

1010

What do you understand by a database object?

1120

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4418

How to use “drop” keyword in sql server and give an example?

1204

Why do we use partitions in sql?

1107

When is functional dependency said to be the fully functional dependency?

1172

What are the three pl sql block types?

1055

Can mongodb scale?

What is aggregation in mongodb?

For More Un-Answered { Databases } Questions Click Here