Answer / rajat sharma

Data integrity is provided by various constrains
(UNIQUE,CHECk etc.) provided to us by SQL. By these
constrains the user cannot even make a mistake in inserting
the data.

How many memory layers are in the shared pool?

3 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

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

4 Answers  

---

why we use cursors

1 Answers  

---

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

What command would you use to create a backup control file?

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?

1 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

Name two files used for network connection to a database.

5 Answers  

---