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

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

Zenith,

1 9267

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

2 11043

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 7947

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

L&T,

2 14804

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

2 11703

hi in which phase of mload can i use .FILLER

IBM,

1 4856

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

IBM,

2857

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

1 3833

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

Apollo,

2 6183

what is single byte over head in oracle..?

2404

please explain database architecture..

Infosys,

1 12697

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

2 16839

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?

2263

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 9156

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 20640

Un-Answered Questions { Databases }

What is the main difference between union and union all?

892

Does mongodb use sql?

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1906

List the different types of normalization?

946

I want to find out all databases starting with ‘test’, I have access to?

1155

Can you explain the 'between' clause?

1127

How to check if a column is nullable before setting to nullable?

1128

What do you understand by the analysis services in sql server?

939

What is like operator for and what are wild cards?

898

Difference between hot backup vs. Cold backup?

992

Which are the new data types introduced in sql server 2008?

881

What are types of indexes in sql?

1083

What is sql analyzer?

1025

How to check database size in sybase iq?

986

what happens on checkpoint? : Sql server database administration

1103

For More Un-Answered { Databases } Questions Click Here