Answer / pallavi

cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

what is logical system in sap basis

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

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  

---

what is the use of home directory???

1 Answers   HP,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 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  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---