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

Is SET a SQL Keyword?

BitWise,

4 15635

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 5453

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

Wipro,

5 9781

Define Normalization with example?

1 5200

what is dynamic SGA and static SGA

Oracle,

4493

sql query to get zero records from a table

CTS,

7 11935

What is A BI Ap;plication?

HCL,

1 4277

What is Database?

2 4976

Where are magic tables stored ? Is it in the same database where it is created ?

4 13385

sql query to get zero records from a table having n no of records

CTS,

8 26213

what is difference between primary key and unique key ?

2 5364

Difference between MS Access and Oracle

CMC,

2 18044

How do we tune the code?

2 6122

Are there any features that are decommissioned in 11g that are not present in 11g?

2200

what is integrity constrains?

3 6073

Un-Answered Questions { Databases }

How many types of indexes are there in sql?

1048

Where is mysql installed on linux?

974

What is dbms and its application?

1058

What language is sql server written in?

1081

explain the storage models of olap? : Sql server database administration

1018

How many types of locks are present in a database?

1184

How to move a multi-file database?

1093

How to enter binary numbers in sql statements?

1010

What is sql and where is it used?

994

What is before and after trigger?

1012

Explain the truncate command? : SQL Server Architecture

1236

What is pl sql variable?

1036

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1074

What is a mysql server?

1036

What will happen when you remove a document from database in mongodb? Does mongodb remove it from disk?

For More Un-Answered { Databases } Questions Click Here