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 7691

Explain the relationship among Database, Tablespace and Data file?

4 12781

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 64504

What are Schema Objects ?

2 5632

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

3 9492

Can a Tablespace hold objects from different Schemes ?

3 7726

what is Table ?

2 5368

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 10308

What is a Sequence ?

3 7045

What is a Synonym ?

3 7199

What are the type of Synonyms?

1 5929

What is a Private Synonyms ?

1 5119

Un-Answered Questions { Databases }

What is data model example?

1131

Are null values the same as that of zero or a blank space?

1096

What the is the diff between local index and global index. give some example.

1688

What is a super key?

1086

Can you explain the 'between' clause?

1180

What is vacuum in database?

924

What is the security principal at the server level that represents your session?

1065

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1069

Describe the functionalities that views support.

1153

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2048

What is a table index in oracle?

1189

What is the contrast amongst drop and truncate?

1082

What is microsoft access and its uses?

926

What is a 3nf table?

941

What is faster join or union?

1325

For More Un-Answered { Databases } Questions Click Here