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 SYSTEM tablespace and When is it Created?

2 7689

Explain the relationship among Database, Tablespace and Data file?

4 12781

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 64498

What are Schema Objects ?

2 5631

Can objects of the same Schema reside in different tablespaces.?

3 9490

Can a Tablespace hold objects from different Schemes ?

3 7724

what is Table ?

2 5367

What is a View ?

3 6643

Do View contain Data ?

10 23756

Can a View based on another View ?

3 11916

What are the advantages of Views ?

3 10307

What is a Sequence ?

3 7042

What is a Synonym ?

3 7199

What are the type of Synonyms?

1 5927

What is a Private Synonyms ?

1 5117

Un-Answered Questions { Databases }

What is the difference between varchar and varchar(max) datatypes?

1138

What is the best partition size for windows 10?

1059

What does asynchronous call backs means?

1239

How concurrency problems effect the database?

1212

Can you move the resources after pausing the node? : sql server database administration

1171

Why procedure is used in sql?

1087

Explain the difference between replace() and translate() functions in oracle?

1088

Explain insert into select statement?

1012

What is the maximum row of a size?

1072

In which database can extended stored procedures be added?

954

What are the set operators in sql?

1138

what are all types of user defined functions? : Sql dba

1089

What do you understand by join?

1199

What is user defined functions?

1031

How to pass a parameter to a cursor in oracle?

1234

For More Un-Answered { Databases } Questions Click Here