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

Is there an object-oriented version of MySQL library functions?

1 1465

What is the storage engine used for MySQL?

1 1476

What is the use of ENUM in MySQL?

1 1398

How to create triggers in MySQL?

1 1592

What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

1 1375

What is DDL in MySQL?

1 1529

What is DML in MySQL?

1 1312

What is DCL in MySQL?

1 1495

How to save images in MySQL?

2 1947

Explain GRANT command in MySQL.

1 1275

What are different TEXT data types in MySQL?

1 1452

What different Stored Objects are supported in MySQL?

1 1603

What is MySQL Stored Procedure?

1 1485

What are the features of Stored Procedures in MYSQL?

1 1351

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 1357

Un-Answered Questions { Databases }

How do I rename a table in mysql workbench?

960

What are security principals used in sql server 2005?

986

what are the informix isolation levels and can you explain each one ?

What are the basic functions for master, msdb, model, tempdb and resource databases?

986

How to load excel data sheet to oracle database

1024

Difference between primary key and clustered index?

1005

Can a commit statement be executed as part of a trigger?

1048

Which sql statement is used to delete data from a database?

956

What happen when we delete the table using trigger?

902

How to connect to a remote server?

1124

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1991

What are alternatives to mongodb?

Explain the creation and execution of a user-defined function in the sql server?

1051

How to delete the repeated records from a table?

977

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2460

For More Un-Answered { Databases } Questions Click Here