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 would you best determine why your MVIEW couldnt FAST REFRESH?

1 1946

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1 2318

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1 1944

How would you begin to troubleshoot an ORA-3113 error?

1 2142

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1 1976

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1 2117

How would you extract DDL of a table without using a GUI tool?

1 4543

Youre getting high busy buffer waits - how can you find whats causing it?

1 2696

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

Infosys,

1 2363

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1 2230

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1 2073

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1 2391

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 1994

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1 2200

Explain how you would restore a database using RMAN to Point in Time?

1 2207

Un-Answered Questions { Databases }

What is acid mean in sql server?

1229

What is in place upgrade in sql server?

1118

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

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2694

What are the kinds of subquery?

1092

How to select all columns of all rows from a table in oracle?

1114

What is standby servers? Explain types of standby servers.

1067

What versions of clipper does netlib support?

1070

When should you use an instead of trigger?

1041

What are different types of constraints?

989

Have you written applications to retrieve stored images in a table?

1081

How to export data from database and import into another?

985

Are you familiar with user exits in reports?

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

2302

Can sql servers link to other servers like oracle?

905

For More Un-Answered { Databases } Questions Click Here