How would you go about generating an EXPLAIN plan?

2 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

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  

---

Hot backup procedure?

2 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---