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 rename an existing table in mysql?

1089

How to extract a unit value from a date and time?

1005

How to get a list of all tables in a database?

1110

What tools available for managing mysql server?

1087

How to drop an existing view in mysql?

975

What are date and time data types?

1043

What are the 'mysql' command line options?

1055

How to check server status with 'mysqladmin'?

1235

What are date and time functions in mysql?

1070

What is 'mysqladmin' in mysql?

1081

How to calculate the difference between two dates?

1125

What are the differences between binary and varbinary?

1131

What is 'mysqldump'?

1126

How to convert character strings to dates?

1150

How to escape special characters in sql statements?

1015

Un-Answered Questions { Databases }

how can you communicate with operating system files from oracle?

1097

Difference between Row Id and Row Num?

734

What is clustered index

1069

What are the data types in oracle?

1103

Compare in and exists?

966

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2818

What is a schema in postgres?

852

Explain odi architecture?

667

How do I run a sql script?

1235

How do you open tables in pgadmin?

849

When was mongodb founded?

What language does mysql use?

961

Explain locking?

958

Explain, why is rdbms better than dbms?

1058

For More Un-Answered { Databases } Questions Click Here