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

Does rowid change in oracle?

1 1392

Is rowid unique in oracle?

998

Is primary key indexed by default in oracle?

987

What are triggers in oracle?

1039

What is max rowid in oracle?

1025

What is oracle rowcount?

1084

What is oracle rownum?

951

What is oracle analytical function?

1143

What is rowid and rownum in oracle?

1011

What is bulk collect in oracle?

996

What is truncate oracle?

971

Can we create trigger on view in oracle?

1 1326

Can we create trigger on materialized view in oracle?

992

Does oracle partitioning improve performance?

992

What are the different types of partitions in oracle?

977

Un-Answered Questions { Databases }

How do I order by ascending in sql?

1020

What is difference between sid and service name in oracle?

956

Is it necessary to install mongodb compass?

Differentiate between sql temp table vs table variable?

881

Can I create users through internet explorer in oracle 10g?

1084

Why do we use sql constraints?

1168

Can a table have 2 foreign keys?

905

Have you attended the client meetings?

602

What is the point of foreign keys?

776

What is query cost in sql server?

995

What can you do with mysql?

1010

List the advantages of access database ovr oracle database.

802

What is oracle d2k?

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2929

Explain what are the authentication modes in sql server?

1017

For More Un-Answered { Databases } Questions Click Here