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

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 7949

how to genarate random numbers in oracle for particular row?

3 7913

What is use of oracle?

Satyam,

2 5613

what is difference b/w pravite procedures and public procedures?

Steria, Wipro, Zensar,

3 20452

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1 2595

explain the type of contraints

3 5569

Why do you want to join software field as you have done your BE in Electronics?

Cap Gemini, HCL,

1 2218

what is sql injection?

2 6112

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 10381

Can we passed multiple recordset(set of records) using a Stored Procedure

2 5552

cursor types? explain with example programs?

HP,

1 6054

<> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

ITC Infotech,

1 4984

what is the use of HASH, LIST partitions?

ITC Infotech,

1 5481

what is SCALAR Queries?

ITC Infotech,

2 7998

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1 2065

Un-Answered Questions { Databases }

Have you created fact table and dimension tables?

696

What are different types of constraints?

995

What are the two main functions of queries in databases?

1518

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

Can we use distinct and group by together?

1129

How to export data from database and import into another?

985

Is inner join faster than left join?

1271

Does group by remove duplicates?

1106

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1059

Who proposed the relational model?

1027

What are the steps in creating a database?

997

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

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

2207

How efficient you are in oracle and SQL server?

1249

What are the source of constraints?

1006

For More Un-Answered { Databases } Questions Click Here