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

What command would you use to encrypt a PL/SQL application?

1 10945

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54761

Explain the use of table functions.

2488

Name three advisory statistics you can collect.

1 8292

Where in the Oracle directory tree structure are audit traces placed?

2639

Explain materialized views and how they are used.

2 6379

When a user process fails, what background process cleans up after it?

1 4900

What background process refreshes materialized views?

1 4763

How would you determine what sessions are connected and what resources they are waiting for?

2127

Describe what redo logs are.

1 3857

How would you force a log switch?

1 3637

Give two methods you could use to determine what DDL changes have been made.

1 6776

What does coalescing a tablespace do?

2 19613

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 22541

Name a tablespace automatically created when you create a database.

HCL,

3 8886

Un-Answered Questions { Databases }

Can a database table exist without a primary key?

953

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

How do I install microsoft access 2013?

811

What is sybase ?

920

Explain alternate key, candidate key and composite key in sql server?

916

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2513

Do you know what is lock escalation?

1013

tell me about various levels of constraint. : Sql dba

1035

Can you explain what are commit and rollback in sql?

941

Explain indexed views?

985

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

What is plpgsql language?

1065

What is different between sql and mysql?

1021

What is the drawbacks of normalization?

964

What is the difference between a function and a trigger?

1083

For More Un-Answered { Databases } Questions Click Here