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

What is a transaction? Describe mysql transaction properties.

1114

Explain the difference between delete and truncate.

1001

How can an index be declared in mysql?

960

How can you filter the duplicate data while retrieving records from the table?

909

What are the features of mysql?

1003

What is the function of mysqldump?

1083

What is view? How can you create and drop view in mysql?

946

How can you import tables from a sql file into a database by using the mysql client?

1046

How you can create a trigger in mysql?

1011

What is the purpose of using timestamp data type?

930

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1036

What are the functions of commit and rollback statements?

1040

What is a csv table?

1016

How can you count the total number of records of any table?

934

How can you retrieve a particular number of records from a table?

950

Un-Answered Questions { Databases }

What is rs.exe utility?

160

How to start SQL Server in minimal configuration mode?

7999

What are the uses of mongodb? Explain

What is transaction control statement and how many types of transaction control statement in Oracle?

1178

What are the two types of periodical indexes?

950

Can you have more than one cursor open at any one time in a program ?

971

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

940

Can you explain different types of locks in sql server?

959

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2305

How to load data from external tables to regular tables?

1073

Is it good to save image in database?

1035

What is nvl?

1071

How to round a numeric value to a specific precision?

1085

Is it important for a database administrator to understand the operating system and file access?

1013

How to build data dictionary view an new database?

1018

For More Un-Answered { Databases } Questions Click Here