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 SET a SQL Keyword?

BitWise,

4 15500

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 5387

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 9608

Define Normalization with example?

1 5067

what is dynamic SGA and static SGA

Oracle,

4422

sql query to get zero records from a table

CTS,

7 11716

What is A BI Ap;plication?

HCL,

1 4176

What is Database?

2 4892

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

4 13222

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

CTS,

8 25990

what is difference between primary key and unique key ?

2 5203

Difference between MS Access and Oracle

CMC,

2 17919

How do we tune the code?

2 6012

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

2150

what is integrity constrains?

3 5948

Un-Answered Questions { Databases }

How do we use distinct statement? What is its use?

1037

Write the SQL query to drop, truncate and delete table.

979

Can excel and access work together?

830

what is port in oracle? how is it related to database application.

1950

What command would you use to add a column to a table in sql server?

1314

What is postgres process?

898

Is mysql a nosql database?

1143

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1072

What is the difference between dataadapter and datareader?

1012

How a tablespace is related to data files?

1110

how to use in conditions? : Sql dba

1016

What is the difference between migration and upgradation in sql server?

1102

Have you attended the client meetings?

604

What is a file group?

1097

How to list all field names in the result set using mssql_field_name()?

918

For More Un-Answered { Databases } Questions Click Here