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

What do you mean by e-r model?

1 1063

Explain all codd's rules for relational database system?

1 995

What is data independence and also explain its types?

1 982

Explain the advantages of rdbms?

1 990

What is normalization and why it is used?

1 1194

What do you mean by super key, primary key, foreign key and candidate key?

1 1027

What do you mean by denormalization?

1 1111

What do you mean by conflict serializability in dbms?

1 976

What do you mean by dml compiler?

1 1132

What is the difference between delete and truncate command in dbms?

1 1073

What do you mean by buffer manager?

1 1109

What is acid property in dbms?

1 1033

What is database management system(dbms) and why it is used?

1 1094

What is bcnf standard form in dbms?

1 1099

Explain the difference between dbms and rdbms?

1 1002

Un-Answered Questions { Databases }

What is the current mysql version?

1082

what is the age limit for groups1 examination

2323

Suppose database is running slow, what will you do?

2580

what is schema? : Sql dba

1124

How to write a left outer join with the where clause in oracle?

1136

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

1095

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2285

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

1040

When should you use an instead of trigger?

1033

Is primary key always clustered index?

1081

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

please send me oracle pl/sql exp resume. and also faqs...

2554

Have you used lexical parameters in reports?

what is the difference between openrowset and openquery?

1174

What are the steps in creating a database?

985

For More Un-Answered { Databases } Questions Click Here