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 10951

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54779

Explain the use of table functions.

2489

Name three advisory statistics you can collect.

1 8294

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

2640

Explain materialized views and how they are used.

2 6382

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

1 4901

What background process refreshes materialized views?

1 4768

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

2127

Describe what redo logs are.

1 3858

How would you force a log switch?

1 3643

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

1 6777

What does coalescing a tablespace do?

2 19619

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

2 22543

Name a tablespace automatically created when you create a database.

HCL,

3 8893

Un-Answered Questions { Databases }

What is a covered query in mongodb?

What is a read only transaction in oracle?

1029

How can you fix a poorly performing query?

1186

How to maintain a fill factor in existing indexes?

1006

How to create a dynamic cursor with the dynamic option?

1047

Is sql developer case sensitive?

1003

What area unit the various kinds of info compression introduced in sql server 2008?

1098

How delete all data from table in sql?

1019

How to disconnect the user connection?

889

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

959

How would you lock a table in sybase?

937

What are all the different types of indexes?

1149

List few restrictions that are imposed while creating views?

883

Give a example to search fr a string in all stored procedure in sql server.

988

What is Service Broker in sql server 2012?

1022

For More Un-Answered { Databases } Questions Click Here