Software Interview Questions
Questions Answers Views Company eMail

Give the reasoning behind using an index.

2 7652

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 6621

What type of index should you use on a fact table?

1 3268

Give two examples of referential integrity constraints.

2 7569

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1996

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 22367

What command would you use to create a backup control file?

2 4214

Give the stages of instance startup to a usable state where normal users may access it.

1 2692

What column differentiates the V$ views to the GV$ views and how?

3 9051

How would you go about generating an EXPLAIN plan?

2 7046

How would you go about increasing the buffer cache hit ratio?

2 5941

Explain an ORA-01555

2 5870

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 17330

How would you determine the time zone under which a database was operating?

2 9600

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 8315


Un-Answered Questions { Software }

Who command in linux?

516


Explain 'grep' function.

535


Why is it required to use sandbox solution in sharepoint?

404


How are domain user accounts created and managed in window server 2012?

168


What is planned order creation? Can you convert a planned order to production order, how? : supply chain management

5






What are the benefits of a deferred execution in linq?

68


What is flat table?

110


What is bindings?

463


Does a specific recovery model need to be used for a replicated database? : sql server replication

529


Why is lazy evaluation good?

403


What is jsp action tags?

503


What is a development class? : abap data dictionary

699


Describe ‘ruleset’?

296


What are windows components?

433


How can the default settings be maintained for cost elements per company code?

619