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

when loggined as SYSTEM,how to display all the users of database using sql query?

2 5011

how to create a new database in oracle?

TCS,

6 8828

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

IBM, TCS,

7 9077

What is @@Identity in sql?

Cap Gemini,

1 6274

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 12188

What is Difference Between delete and Truncate?

9 11775

What is Difference between StoredProcedure and function?

3 7535

what is Difference between Having and Where clause?

IBM,

5 11002

How many rows will return from dual table?

Fujitsu,

4 12029

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

IBM,

1 5412

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

TCS,

2969

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2188

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

Goldman Sachs,

2471

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

Goldman Sachs,

1 6119

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2071

Un-Answered Questions { Databases }

How do I restart sql?

979

What is dense_rank?

935

How to create table with same structure of student table in mysql?

951

What is the use of pivot table?

893

How subquery works in sql?

1074

How can we get total number of records by query in mysql?

909

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1349

What are dml and ddl statements?

986

What are the rules of setting a primary key?

828

What is an SQL FORMS ?

2795

Can you get microsoft access for free?

864

What is composite primary key in sql?

999

Why do we backup Active Directory ?

1047

what are the different stages of Report Processing?

135

What are five types of database models?

899

For More Un-Answered { Databases } Questions Click Here