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 11030

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 55172

Explain the use of table functions.

2585

Name three advisory statistics you can collect.

1 8363

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

2706

Explain materialized views and how they are used.

2 6481

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

1 5000

What background process refreshes materialized views?

1 4844

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

2179

Describe what redo logs are.

1 3946

How would you force a log switch?

1 3728

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

1 6855

What does coalescing a tablespace do?

2 19738

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

2 22663

Name a tablespace automatically created when you create a database.

HCL,

3 8995

Un-Answered Questions { Databases }

Does mysql support sequence?

993

What is the difference between ms access and mysql?

928

What is the purpose of the master database?

1201

How to call shell script from pl sql procedure?

1359

How to omit columns with default values in insert statement in oracle?

1099

What is a temporal data type?

1114

How to check your oracle database 10g xe installation?

1053

How to use timestamp datatypes

2079

Explain the Ways to improve the performance of a sql azure database?

Is pdo faster than mysqli?

951

Explain top-n analysis in DBMS.

1655

State three differences between Dbms and Rdbms?

1121

What is raiseerror? What is raiseerror?

1194

What are the different types of tables in sql?

1068

What are the different types of database?

1062

For More Un-Answered { Databases } Questions Click Here