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 9270

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

2 11047

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 7954

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 11706

hi in which phase of mload can i use .FILLER

IBM,

1 4859

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 6188

what is single byte over head in oracle..?

2404

please explain database architecture..

Infosys,

1 12702

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

2 16843

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?

2267

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 9161

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 20651

Un-Answered Questions { Databases }

What is an intersect?

1108

Differentiate sql server reporting services vs. Crystal reports?

203

What is postgresql jdbc driver?

912

What is primary key and foreign key with example?

933

What is sql data?

998

What are the steps you must follow to hide sql server instances?

978

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

Explain sql delete command?

1062

What is mysql database used for?

1035

How is data stored in a database?

935

What exactly do quotation marks around the table name do?

965

What are different functions in sql?

951

What is the advantages and disadvantages of database management system?

1021

How to define default values for formal parameters?

1047

What is dml and ddl?

960

For More Un-Answered { Databases } Questions Click Here