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

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

2 5101

how to create a new database in oracle?

TCS,

6 9065

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 9318

What is @@Identity in sql?

Cap Gemini,

1 6364

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 12357

What is Difference Between delete and Truncate?

9 12059

What is Difference between StoredProcedure and function?

3 7686

what is Difference between Having and Where clause?

IBM,

5 11172

How many rows will return from dual table?

Fujitsu,

4 12179

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

IBM,

1 5485

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

TCS,

3025

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

2236

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,

2523

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 6191

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....

2119

Un-Answered Questions { Databases }

How to list all user accounts in oracle?

1070

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1230

Why stored procedure is faster than query?

1164

What is mongodb in big data?

What is a nested table and how is it different from a normal table?

1115

What is relational database in mysql?

981

What are the features of mysql?

1046

Which function is used to return remainder in a division operator in sql?

1207

How do you import data from another access database?

920

why would you call update statistics? : Sql server database administration

1164

what is transaction? : Sql dba

1065

What is character functions?

1119

can we use lexical perameter in oracle plsql if yes how

2378

What is the difference between join and inner join?

1074

How to retrieve data from mongodb using java?

For More Un-Answered { Databases } Questions Click Here