Software Interview Questions
Questions Answers Views Company eMail

Give the reasoning behind using an index.

2 7641

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

2 6609

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

1 3257

Give two examples of referential integrity constraints.

2 7554

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?

1989

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

5 22359

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

2 4205

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

1 2681

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

3 9035

How would you go about generating an EXPLAIN plan?

2 7030

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

2 5929

Explain an ORA-01555

2 5858

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 17316

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

2 9591

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 8304


Un-Answered Questions { Software }

What is clang space engineers?

537


What is or mapping in hibernate?

284


What is the process flow in billing, ar, am. Gl, ap, po etc?

382


What is the difference between war file and jar file?

163


How does sort function work?

492






What is the difference between xpath and css?

275


How many rows mysql can handle?

500


How can I see all ip addresses on my network using cmd?

534


What are the steps that are followed when two computers connect through tcp?

512


Can xml be used as a database?

443


what is output mkvg pvname

1689


How do I use regsvr32?

441


What’s jboss jbpm?

572


How can you find a list of objects that have been repaired in the system?

726


Differentiate database index and match code.

585