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 is difference between logical standby database and physical standby database?

1 739

What is the easiest method to create a file on unix?

1 639

using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?

1 1107

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

1 629

What is explain plan and how is it used?

1 691

What is the purpose of the grep command?

2 2229

How do you set up tablespaces during an oracle installation?

1 678

You have taken a manual backup of a datafile using os. How rman will know about it?

1 627

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

1 681

How many control files should you have? Where should they be located?

1 647

What are four common errors found in an alert .log?

1 622

How do you generate file output from sql?

1 695

You see multiple extents in the temporary tablespace. Is this a problem?

1 657

What is the finger command?

1 636

What does >> do?

1 660

Un-Answered Questions { Databases }

How can you append an identity column to a temporary table?

1065

what is collation? : Sql dba

1225

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

931

Have you used lexical parameters in reports?

How do I remove duplicates in two columns?

1178

Where can you add custom error messages to sql server?

1203

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

what is the age limit for groups1 examination

2337

What is normalization and what are the advantages of it?

1054

define sql insert statement ? : Sql dba

1094

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

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?

1844

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?

2558

What is sql server query analyzer?

1123

Do we need to rebuild index after truncate?

1129

For More Un-Answered { Databases } Questions Click Here