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

Display the records between two range?

2 3635

Select the Nth lowest value from a table?

4 5485

What is difference between Rename and Alias?

1 4481

Difference between an implicit & an explicit cursor.?

2 7424

What is a OUTER JOIN?

1 2804

What is the purpose of a cluster?

1 3354

What is OCI. What are its uses?

1 3227

How you open and close a cursor variable.Why it is required?

2 3787

Display Odd/ Even number of records?

3 6577

What are various constraints used in SQL?

Polaris,

1 3850

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3886

Difference between NO DATA FOUND and %NOTFOUND?

1 4480

Can you use a commit statement within a database trigger?

4 5459

What WHERE CURRENT OF clause does in a cursor?

2 4235

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 4029

Un-Answered Questions { Databases }

How global temporary tables are represented and its scope?

975

What are two types of data in a database environment?

915

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617

Give an example of why you would want to denormalize a database

976

How to define a record variable to store a table row?

1058

Is mongodb still popular?

What objects does the fn_my_permissions function reports on? : sql server security

1034

Mention what is the difference between single instance environment and rac environment?

Do you know sql server 2008 backup compression?

964

What is a string in mysql?

901

Illustrate physical database architecture in brief? : sql server architect

758

How do I create a database in mysql workbench?

871

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2208

what is the diffrence between core dba and apps dba?

2569

How long does it take to learn ms access?

1247

For More Un-Answered { Databases } Questions Click Here