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 about Normalization?

Infosys,

1 1137

What are triggers? How do you invoke a trigger on demand?

Hexaware,

1 1381

Explain about Joins?

Infosys,

1 1053

What are the purpose of Normalisation?

HCL,

1 1106

Difference between group by clause and having clause in SQL?

Flextronics,

1 1033

What are the types of subscriptions in SQL Server replication?

HCL,

1 1130

Â Explain what is sql override for a source taLle in a mapping?

Informatica,

1 1071

What are the characteristics of modern DBMS?

Ericsson,

1 1162

How to change the system date and time from SQL Plus Terminal ?

MCN Solutions,

1 1303

Define DML and DCL statements?

Hexaware, NIIT,

1 1771

What is function of ROLLUP ?

HCL,

1 1153

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3258

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1 1131

Define Unique Key?

HCL,

1 1082

Difference between aggregate functions of sql?

EXL,

1 1157

Un-Answered Questions { Databases }

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

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

925

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2300

How to put more than 1000 values into an oracle in clause?

1098

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

What are the two main functions of queries in databases?

1517

Where can you add custom error messages to sql server?

1194

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?

2549

what are aggregate and scalar functions? : Sql dba

1118

What are the properties of the transaction?

1061

What is standby servers? Explain types of standby servers.

1067

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1182

How to start an oracle instance?

1088

what is bcp? When does it used? : Sql dba

1048

For More Un-Answered { Databases } Questions Click Here