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

Explain the use of control file?

1 1202

Explain an extent?

1 1185

Explain what does a control file contain?

1 1183

Explain a synonym?

1 1115

What is data file?

1 1182

Explain do view contain data?

1 1063

Explain an index segment?

1 1181

What is redo log?

1 1131

What is the difference between recovery and restoring of the oracle database?

1 1332

What is the difference between oracle media recovery and crash recovery?

1 1232

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1 1226

What is an Oracle database Partial Backup?

1 1225

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1 1483

What is an Oracle database Full Backup?

1 1200

What is Restricted Mode of Instance Startup in Oracle?

1 1259

Un-Answered Questions { Databases }

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?

2553

Do we need to rebuild index after truncate?

1128

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

2088

how to escape special characters in sql statements? : Sql dba

1110

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

How to rebuild the master database?

1157

Are you familiar with user exits in reports?

What are wait types?

1235

what is the age limit for groups1 examination

2335

What is your daily office routine?

2340

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1852

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

Have you used lexical parameters in reports?

What is a view in sql?

1035

What is sql or structured query language?

1217

For More Un-Answered { Databases } Questions Click Here