Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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?

1891

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

2262

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

1884

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

2084

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

1915

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

2052

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

1 4459

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

1 2608

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

Infosys,

2280

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

2162

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.

2007

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

2328

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

1934

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.

2132

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

2148

Un-Answered Questions { Databases }

What are the ways tablespaces can be managed and how do they differ?

2373

List types of tables in SQL Azure?

126

How to how to convert numeric expression data types using the convert() function??

1056

what are triggers? : Sql server database administration

910

explain advantages of innodb over myisam. : Sql dba

1132

Is primary key is clustered index?

1002

How do I start mongodb on mac?

What are the non-standard sql commands supported by 'mysql'?

998

Does full backup break log chain?

970

What is advantage of dbms?

1013

How we create SQL Server 2005 Reporting Services ? Give me Sample

1998

what are savepoint mode and cursor mode properties ?

What is new mysqli?

917

What is rank function?

1034

What is mysql procedure?

934

For More Un-Answered { Databases } Questions Click Here