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 to execute a stored procedure?

1 1188

What is mutating table error?

1 1246

How to convert a date to char in oracle? Give one example.

1 1142

What is the difference between translate and replace in oracle?

1 1243

What are the different types of synonyms?

1 1227

How do you store pictures in a database?

1 1081

What is the use of file param in imp command?

1 1237

What is a system tablespace?

1 1161

In the oracle version 9.3.0.5.0, what does each number shows?

1 1378

What are the different types of modules in oracle forms?

1 1075

What are the limitations of check constraint?

1 1103

How to convert a string to a date in oracle database?

1 1134

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1 1086

Can you create a synonym without having a table?

1 1122

What are the components of logical database structure in oracle database?

1 1169

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

1265

What is temporary table in sql server? Why we use temp table?

1017

Why use identity in sql server?

1193

What is the primary use of the model database?

1146

What are the steps in creating a database?

1009

Any work done in oracle workflow builder. Did you customize or build a new workflow?

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?

2561

Can delete statement be rollbacked?

1053

What is clustered index

1083

what are the advantages of sql ? : Sql dba

1140

What is a scheduled job or what is a scheduled task?

1035

What is normalization and what are the advantages of it?

1054

What is a view in sql?

1037

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2178

Does group by remove duplicates?

1112

For More Un-Answered { Databases } Questions Click Here