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 5121

how to create a new database in oracle?

TCS,

6 9100

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 9366

What is @@Identity in sql?

Cap Gemini,

1 6383

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 12383

What is Difference Between delete and Truncate?

9 12100

What is Difference between StoredProcedure and function?

3 7717

what is Difference between Having and Where clause?

IBM,

5 11191

How many rows will return from dual table?

Fujitsu,

4 12207

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

IBM,

2 5503

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

TCS,

1 3032

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

1 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,

1 2524

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 6201

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

1 2127

Un-Answered Questions { Databases }

List out the different types of locks available in sql server?

1037

Have you used lexical parameters in reports?

please send me oracle pl/sql exp resume. and also faqs...

2554

define sql insert statement ? : Sql dba

1086

How to enter binary string literals in ms sql server?

1231

Why we use the openxml clause?

1059

What is the best sql course?

1031

What is acid mean in sql server?

1218

Does view occupy space?

998

Can we shrink data file in sql server?

1112

How to use values from other tables in update statements using oracle?

1139

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8210

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2201

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1899

What is a view in sql?

1033

For More Un-Answered { Databases } Questions Click Here