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

How to define Data Block size ?

2 5600

What is Row Chaining ?

Cognizant, CTS,

3 12916

What is an Extent ?

3 6405

What is a Segment ?

1 4748

What are the different type of Segments ?

2 4721

What is a Data Segment ?

3 6188

What is an Index Segment ?

2 4795

What is Rollback Segment ?

3 6331

What are the uses of Rollback Segment ?

2 5863

What is a Temporary Segment ?

2 5223

What is a Data File ?

1 4651

What are the Characteristics of Data Files ?

3 6663

What is a Redo Log ?

3 7445

What is the function of Redo Log ?

1 5192

What is the use of Redo Log Information ?

2 6662

Un-Answered Questions { Databases }

How to query multiple tables jointly?

1004

What joins are and how you can open the database in access?

871

Explain indexing and what are the advantages of it?

1044

Explain unique key in sql server?

1021

How do I view data in mysql workbench?

1027

please differentiate between delete and truncate?

1004

Can a table have multiple primary keys?

915

What happens if you are trying to access a schema not owned by you?

982

What is the function of access?

846

What is system catalog or catalog relation? How is better known as?

862

What is a delimiter in mysql?

1047

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1798

Explain how would you store your query in an SSRS report or a Database server?

131

How can we call UDF(User Define Function) using C# code in ASP.net ?

6900

How do I find duplicates in sql?

945

For More Un-Answered { Databases } Questions Click Here