Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

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

1 10054

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 50651

Explain the use of table functions.

1785

Name three advisory statistics you can collect.

1 7346

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

2114

Explain materialized views and how they are used.

2 5283

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

1 4087

What background process refreshes materialized views?

1 3922

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

1606

Describe what redo logs are.

1 2991

How would you force a log switch?

1 2937

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

1 6009

What does coalescing a tablespace do?

2 18386

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

2 20936

Name a tablespace automatically created when you create a database.

HCL,

3 7135

Un-Answered Questions { Databases }

What do you know about Master Data & Transaction Info Package?

519

Does the order of columns in update statements matter?

470

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

532

How to transfer a table from one schema to another?

553

What is a trigger what are the advantages of trigger?

517

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

281

What are some predefined exceptions in pl/sql?

540

What objects are present in the table msysobjects of microsoft access database?

467

Characterize join and name diverse sorts of joins?

522

Can we use delete in merge statement?

506

What happen when we delete the table using trigger?

481

Can mongodb store structured data?

Why Master database is required?

592

What is the difference between coalesce() & isnull()?

523

What is the use of extent in informix?

For More Un-Answered { Databases } Questions Click Here