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 can you determine what protocol is being used for interconnect traffic?

What is oracle real application clusters?

When system tablespace is created?

1056

What are the database administrators utilities available?

1056

What is system tablespace?

1116

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1069

How does one get the view definition of fixed views/tables?

1036

What is a snapshot log?

1019

Can objects of the same schema reside in different tablespace?

1073

How index is implemented in oracle database?

1023

How are extents allocated to a segment?

1147

How does one create a new database?

606

What database block size should I use?

745

How does one coalesce free space?

567

Introduction of rollup clause using sum and group by clause?

985

Un-Answered Questions { Databases }

Do companies use microsoft access?

899

What is the purpose of access?

877

What is oracle server autotrace in oracle?

1186

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2166

Why cross join is used?

1101

How many columns can a mysql table have?

924

How to create id with auto_increment on oracle?

1001

How to set a transaction to be read only in oracle?

1112

Do you know what is a linked server in sql server?

1038

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2046

what is heap table? : Sql dba

1117

What are the technical features of MySQL?

1031

Can't connect mysql server on localhost?

1081

What is microsoft access 2013 runtime?

854

How to create percentile function?

159

For More Un-Answered { Databases } Questions Click Here