What is the difference between clustered and non-clustered index? : sql server DBA


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

Describe what redo logs are.

1 Answers  


Explain what partitioning is and what its benefit is.

2 Answers  


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

0 Answers  


what is ora 24313?what is the procedure to exclude that error?

0 Answers  


Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  






How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  


what is incremental checkpoint?

1 Answers   CTS,


what do you understand by flashback feature of oracle?

0 Answers   Oracle,


How would you determine who has added a row to a table?

4 Answers  


How would you force a log switch?

4 Answers  


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


how can you initialize log miner?

0 Answers   Oracle,


Categories