Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What are the different types of upgrades that can be performed in sql server? : sql server DBA

Question Posted / navneet kaur

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

Post New Answer

More DB Administration Interview Questions

What would you do with an "in-doubt" distributed transaction?

0 Answers  

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

Hot backup procedure?

2 Answers  

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

0 Answers  

Explain the use of table functions.

1 Answers  

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

What is fill factor? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories