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

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 9381

what are the advantages of Oracle over other databases..? please give me reply...

2 11181

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 8091

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

L&T,

2 14974

What is the use 'return' keyword in Stored Procedure?

2 11863

hi in which phase of mload can i use .FILLER

IBM,

1 4966

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

IBM,

1 2915

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 3928

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 6335

what is single byte over head in oracle..?

1 2465

please explain database architecture..

Infosys,

1 12815

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 16978

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1 2317

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

Thomson,

5 9371

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

TCS,

10 21021

Un-Answered Questions { Databases }

What is your daily office routine?

2329

How raid can influence database performance?

1093

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

1037

Equi join and non equi join is possible with sql server?

1110

What are the steps in creating a database?

985

What are the two main functions of queries in databases?

1509

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2081

What is standby servers? Explain types of standby servers.

1067

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

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2089

What are the types of database explain each of them briefly?

1038

Can delete statement be rollbacked?

1038

what is the command syntax for inserting a document?

Can we use distinct and group by together?

1116

For More Un-Answered { Databases } Questions Click Here