Databases Interview Questions
Questions Answers Views Company eMail

How would you best determine why your MVIEW couldnt FAST REFRESH?

1410

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

1800

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

1455

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

1562

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

1467

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

1588

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

1 3615

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

1 1877

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

Infosys,

1777

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

1650

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.

1513

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

1782

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

1433

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.

1547

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

1611


Un-Answered Questions { Databases }

What do you understand by row chaining?

1


The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

281


Explain how would you store your query in an SSRS report or a Database server?

86


What is clause in sql?

561


What is the difference between natural join and equi join?

475






How do you modify a trigger?

505


How to get a list of columns in a view using the "sp_help" stored procedure?

549


How do you set up a database?

493


How do you determine the location of mysql data directory?

473


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1826


Define checkpoint.

500


How to calculate the difference between two dates?

468


Is mongodb better than mysql?

1


How do I spool in oracle?

517


How to remove duplicate rows from table?

569