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

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1 2098

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1 1974

How would you begin to troubleshoot an ORA-3113 error?

1 4918

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 6434

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 5384

How would you extract DDL of a table without using a GUI tool?

1 2542

You're getting high "busy buffer waits" - how can you find what's causing it?

1 5580

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 4613

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1 2100

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

Infosys,

1 2367

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1 2025

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 4454

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1 2055

Explain how you would restore a database using RMAN to Point in Time?

1 6816

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4464

Un-Answered Questions { Databases }

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

Can we do dml on views?

1024

what is the command syntax for inserting a document?

How to export data from database and import into another?

978

What are the different types of subquery?

1222

Does group by remove duplicates?

1100

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2081

What is a coalesce function?

1261

what is schema? : Sql dba

1124

What is subquery? Explain the properties of a subquery?

1046

Explain system functions or built-in functions? What are different types of system functions?

1053

Is there some bulk load or other way to import a lot of data fast?

923

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2545

How raid can influence database performance?

1093

Do we need to rebuild index after truncate?

1114

For More Un-Answered { Databases } Questions Click Here