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

1 1335

Which mysql function is used to concatenate string?

1 1501

What are the advantages and disadvantages of using mysql?

1012

What are the differences between char and varchar data types?

1121

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

1083

Explain the different types of mysql joins.

942

What are the differences between innodb and myisam engines?

991

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

932

What is the default port number of mysql?

962

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

1198

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

992

What is a storage engine?

979

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

1 1409

What is the purpose of using a heap table?

1132

How can you change the password of a mysql user?

971

Un-Answered Questions { Databases }

What do you understand by the term 'normalization'?

683

What is dbms in mysql?

985

What are different clauses used in sql?

1131

What is normal form in dbms?

922

How can you determine the space left in a file system?

662

How do you create a db file?

1028

Explain system rowset functions?

1014

What is the advantage of the database management approach

1067

What is pcbs (program communication blocks)?

1020

What is an index in a database?

994

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2084

What are the four types of database?

1039

What is the difference between restoring a database and recovering a database?

What is the difference between partitioning and sharding?

1021

Is sql port 1433 encrypted?

1040

For More Un-Answered { Databases } Questions Click Here