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 10953

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54788

Explain the use of table functions.

2491

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 6385

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

1 4906

What background process refreshes materialized views?

1 4769

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

2127

Describe what redo logs are.

1 3861

How would you force a log switch?

1 3645

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

1 6779

What does coalescing a tablespace do?

2 19623

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

2 22548

Name a tablespace automatically created when you create a database.

HCL,

3 8897

Un-Answered Questions { Databases }

How to delete existing triggers using "drop trigger"?

1059

Can we update data in a view?

1038

What is memory table in mysql?

948

How to modify an existing user defined function?

1114

What is the use of mysql workbench?

1017

How do I run a pl sql procedure in sql developer?

976

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1161

How to retrieve values from data fields in record variables?

1120

What is the difference between database and table?

1009

What is type of end users?

814

explain different types of joins? : Sql server database administration

990

Explain the wait events in statspack report 'db scattered read'?

583

Explain the difference in execution of triggers and stored procedures?

1024

How to define numeric 9(3) in db2 table without decimal point??

2853

Explain the working of foreign key?

1071

For More Un-Answered { Databases } Questions Click Here