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

Oracle (3253)
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 11033

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 55178

Explain the use of table functions.

2588

Name three advisory statistics you can collect.

1 8368

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

2707

Explain materialized views and how they are used.

2 6482

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

1 5001

What background process refreshes materialized views?

1 4845

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

2180

Describe what redo logs are.

1 3950

How would you force a log switch?

1 3729

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

1 6857

What does coalescing a tablespace do?

2 19740

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

2 22667

Name a tablespace automatically created when you create a database.

HCL,

3 8996

Un-Answered Questions { Databases }

Which is better access or excel?

908

How to prepare for oracle pl sql certification?

1109

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2190

Why select is used in sql?

1071

Explain the types of joins in sql?

1079

How to start an oracle instance?

1076

How to use count function in mysql?

973

What are the three levels of data abstraction?

1174

What is repeatable read?

1097

How do I do transactions/locking in mongodb?

What is sqlerrd?

1017

Can mongodb used for cache management?

What is data in dbms?

966

Does mongodb database have tables for storing records?

For More Un-Answered { Databases } Questions Click Here