What is a correlated sub-query? : sql server DBA
what are the benefits of flashback feature?
how can a session indicate its interest in receiving alerts?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Describe what redo logs are.
How to determine the service pack currently installed on SQL Server?
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???
How can you rebuild an index?
What view would you use to look at the size of a data file?
Which autogrowth database setting is good? : sql server DBA
What is transparent data encryption? : sql server DBA
when does an alert gets signaled?
What are the steps you will take to improve performance of a poor performing query?