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 are the components of physical database structure in the Oracle database?

1 1495

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1213

how do you tune the slow running queries in oracle db , explain the methodology

2200

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 1801

Un-Answered Questions { Databases }

What is your favorite tool for day-to-day oracle operation?

511

Explain overloading. Can functions be overloaded?

946

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2187

Can we store files in mysql?

864

Explain the significance of the & and && operators in pl sql.

965

What is use of postgresql?

821

What is the maximum size of a database that can be opened in Microsoft Access?

844

Who are mongodb competitors?

What is an Oracle Data Segment?

998

Explain can SSRS reports Cache results?

151

What is implicit mode in sql server?

1041

Explain intellisense for query editing

988

What is mutating sql table?

1046

How to call stored procedure using http soap?

1013

What is coalesce in sybase?

895

For More Un-Answered { Databases } Questions Click Here